Open the 3Sales spreadsheet, which includes a summary of the gallery's sales - NSC Computer Application Technology - Question 3 - 2018 - Paper 1
Question 3
Open the 3Sales spreadsheet, which includes a summary of the gallery's sales. Work in the Summary_Opsomming worksheet.
3.1 Change the vertical alignment of row 1 to... show full transcript
Worked Solution & Example Answer:Open the 3Sales spreadsheet, which includes a summary of the gallery's sales - NSC Computer Application Technology - Question 3 - 2018 - Paper 1
Step 1
3.1 Change the vertical alignment of row 1 to centre.
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 vertical alignment of row 1 to centre, select row 1 in the spreadsheet and navigate to the alignment settings in the toolbar. Choose 'Centre' from the vertical alignment options.
Step 2
3.2 Insert a function in cell K3 to determine the average selling price of all the art pieces sold (column G).
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 K3, use the formula: =AVERAGE(G3:G43) to calculate the average selling price of the art pieces by selecting the appropriate range in column G.
Step 3
3.3 Insert a COUNTIFS function in cell K4 to determine the number of art pieces sold in less than R30 (column F) AND sold for an amount of more than R2000 (column G).
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 K4, insert the following formula: =COUNTIFS(F3:F43,"<30",G3:G43," >2000"). This will count the art pieces sold for less than R30 in column F and more than R2000 in column G.
Step 4
3.4 Insert a function in cell K5 to determine the total value of all the pieces sold (column G), for experience code 1 (column D).
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 K5, use the formula: =SUMIF(D3:D43,"1",G3:G43). This will sum the values in column G where the experience code in column D is equal to 1.
Step 5
3.6 Change the chart in the worksheet to appear as shown below.
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 the Chart_Grafiek worksheet, to change the chart: insert data labels for the amounts, remove the legend, set the major axis units to 10,000, and fill the back wall of the chart with your chosen color.
