QUESTION 4: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2019 - Paper 1
Question 4
QUESTION 4: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet.
- Use absolute cell references ONLY where necessary to ensure ... show full transcript
Worked Solution & Example Answer:QUESTION 4: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2019 - Paper 1
Step 1
4.1 Change the tab colour of the Chart_Grafiek worksheet to yellow.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To change the tab colour of the Chart_Grafiek worksheet to yellow, first navigate to the Chart_Grafiek tab. Right-click on the tab and select 'Tab Color'. From the color palette, choose yellow.
Step 2
4.2 Swop the order of the two worksheets so that the Provinces_Provinies worksheet appears first.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To swap the order of the worksheets, click and hold the Provinces_Provinies tab and drag it to the left of the Chart_Grafiek tab. Release it to place it first.
Step 3
4.3 Insert a function in cell M7 to determine the number of entries from Limpopo (LP) (column C).
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In cell M7, enter the formula =COUNTIF(C3:C188,"LP"). This function counts the number of times "LP" appears in the specified range.
Step 4
4.4 Sort only the data in cells L3:M11 in descending order according to province.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Select the range L3:M11. Then, go to the 'Data' tab and select 'Sort'. Choose to sort by 'Column L' and set it to sort in descending order.
Step 5
4.5 Use a spreadsheet feature to apply shading to all the cells that contain dates that appear more than once in column E.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Select the range in column E. Then, from the 'Home' tab, choose 'Conditional Formatting', select 'Highlight Cell Rules' and then 'Duplicate Values'. Choose a shading color and click OK.
Step 6
4.6 Use a formula in column J to display the surname of the overall winner who achieved the highest total points (column I).
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In cell J3, input the formula =IF(I3=MAX($I$3:$I$188),A3,""). This formula checks if the score in I3 is the maximum and returns the corresponding surname from column A. Drag the fill handle down to copy the formula to other cells in column J.
Step 7
4.7 Change the chart/graph to display similar to the one shown below.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In the Chart_Grafiek worksheet, select the current chart and change its type to a bar chart by right-clicking on it and selecting 'Change Chart Type'. Remove the data series for the province with the least entries by right-clicking on that specific data series and selecting 'Delete'. Then, apply a glow effect to the remaining data series. Adjust the gap width by right-clicking on the bars, selecting 'Format Data Series', and changing the gap width to 50%. Finally, change the color of the major vertical gridlines to red in the formatting options.
