QUESTION 4: SPREADSHEET
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2016 - Paper 1
Question 4
QUESTION 4: SPREADSHEET
Use formulae and/or functions for ALL calculations in the spreadsheet. Use absolute cell references only where necessary to ensure that formu... show full transcript
Worked Solution & Example Answer:QUESTION 4: SPREADSHEET
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2016 - Paper 1
Step 1
4.1 Adjust the width of column B so that all the data in this column is displayed and visible.
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 adjust the width of column B, click on the right border of the column header (B) and drag it to the right until all the content in the cells of that column is fully visible.
Step 2
4.2 Display the contents of column G to TWO decimal places.
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 column G, right-click and choose 'Format Cells'. In the 'Number' tab, select 'Number' and set Decimal places to 2. Click OK to apply the format.
Step 3
4.3 Add a LOOKUP function in cell F2 in the Music_Musiek worksheet to determine the song's storage type.
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 F2, enter the formula: =VLOOKUP(A2, Code_Kode!$C$2:$D$4, 2, FALSE). This looks up the value in A2 within the Code_Kode worksheet and returns the corresponding storage type.
Step 4
4.4 Insert a function in cell H2 to determine the new increased price based on the information above.
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 H2, enter the formula: =IF(A2=1,G2*120/100,IF(A2=2,G2*125/100,IF(A2=3,G2*115/100))). This checks the song type and applies the appropriate percentage increase.
Step 5
4.5 Change the function in cell L2 so that it can be copied to cells L3:L17.
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
Modify the formula in L2 to: =COUNTIF(D$2:D$612,K2), ensuring absolute reference for rows to maintain accuracy when copied.
Step 6
4.6 Use a function in cell L21 to determine the total value of all the 'Pop' albums.
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 L21, enter: =SUMIF(E2:E612, "Pop", G2:G612). This calculates the total price of albums categorized as 'Pop'.
Step 7
4.7 In cell J2, display the number of different owners in the list.
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 J2, use the formula: =COUNTA(G2:G636), which counts all unique owners listed. In J3, explain that this method counts all entries to determine ownership without duplicates.
