The supply and demand of platinum is stored in the 3Platinum spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Question 3
The supply and demand of platinum is stored in the 3Platinum spreadsheet. The supply and demand of platinum is measured in thousands of ounces ('000 ounces).
NOTE:
... show full transcript
Worked Solution & Example Answer:The supply and demand of platinum is stored in the 3Platinum spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Step 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 'Sheet1' tab at the bottom of the spreadsheet and select 'Rename'. Type 'Platinum' and press Enter.
Step 2
Format row 1 as follows: - Merge cells A1:E1, but DO NOT centre the text. - Increase the font size of the text to 16. - Apply gradient fill to cells A1:E1.
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
Select cells A1 to E1. Right-click and choose 'Format Cells'. In the Alignment tab, select 'Merge Cells' without centering the text.
To increase font size, go to the Font tab and change the size to 16.
To apply gradient fill, select the cells again and use the fill options to choose a gradient style.
Step 3
Remove the comment from cell E2.
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
Right-click on cell E2 and select 'Delete Comment' to remove any existing comment.
Step 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
Use a formula in cell E3 to determine the percentage increase/decrease in South Africa's platinum supply between the figures for 2014 and 2016.
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
This will give you the percentage change between the years 2014 and 2016.
Step 6
Use a spreadsheet feature to automatically apply any border to the top 40% of the values in 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 the range B8:D11, then go to 'Conditional Formatting'. Choose 'New Rule' and select 'Format only top or bottom ranked values'. Specify 40% and choose a border style.
Step 7
Change the chart/graph to include the data of all suppliers for 2015 and 2016.
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
Select the chart and adjust the data range to include all suppliers from 2015 and 2016. Make sure to include the necessary data series.
Step 8
Insert a FORMULA in cell D10 to determine and display the number of stars for a brooch with a weight of 1 300 grams.
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:
=INT(1300/550)
This will calculate the number of stars based on the weight of the brooch.
