QUESTION 3: SPREADSHEET
The supply and demand of platinum is stored in the 3Platinum spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Question 3
QUESTION 3: SPREADSHEET
The supply and demand of platinum is stored in the 3Platinum spreadsheet. The supply and demand of platinum is measured in thousands of ounc... show full transcript
Worked Solution & Example Answer:QUESTION 3: SPREADSHEET
The supply and demand of platinum is stored in the 3Platinum spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Step 1
3.1 Rename the Sheet1 worksheet as Platinum.
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 rename the worksheet, right-click on the tab labeled 'Sheet1' and select 'Rename.' Type 'Platinum' and press Enter.
Step 2
3.2 Format row 1 as follows:
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
Merge cells A1:E1 by selecting them, right-clicking, and choosing 'Merge Cells.' Keep text un-centred.
Set the font size to 16 by selecting row 1, right-clicking, and choosing 'Format Cells,' then selecting 'Font.'
Apply a gradient fill by selecting A1:E1, right-clicking, selecting 'Format Cells,' and under 'Fill,' choose a gradient.
Step 3
3.3 Remove the comment from the spreadsheet.
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
Select cell E2 where the comment is located. Right-click on the cell and select 'Delete Comment' to remove it.
Step 4
3.4 Enter a function in cell B6 to determine the total supply of platinum for 2014.
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
In cell B6, enter the formula: =SUM(B3:B5) to calculate the total supply of platinum for 2014.
Step 5
3.5 Use a formula in cell E3 to determine the percentage increase/decrease.
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
In cell E3, enter the formula: =((D3 - B3) / B3) * 100 to calculate the percentage increase/decrease in South Africa's platinum supply.
Step 6
3.6 Use a spreadsheet feature for cells B8:D11.
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
Select cells B8:D11. Use 'Conditional Formatting' from the 'Home' tab, choose 'Top/Bottom Rules,' and select 'Top 40%.' Then, set the desired border for these cells.
Step 7
3.7 Change the chart/graph as specified.
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
Click on the chart and select 'Select Data.'
Extend the data selection to include cells A3:D5.
Ensure 'South Africa' data is filled with the stacked fill effect.
Move the legend below the chart in the 'Legend Options.'
Adjust the vertical axis to display years (2014, 2015, 2016).
Step 8
3.8 Insert a FORMULA in cell D10 for stars.
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
In cell D10, enter the formula: =LEFT(B1, TRUNC(B10/550)) to calculate the number of stars for a brooch with a weight of 1 300 grams.
