QUESTION 3: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2019 - Paper 1
Question 3
QUESTION 3: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet.
- Use absolute cell references ONLY where necessary to ensur... show full transcript
Worked Solution & Example Answer:QUESTION 3: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2019 - Paper 1
Step 1
Merge cells A1:M1 and centre the data vertically.
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 merge cells A1:M1, select the cells, then click on the 'Merge & Center' option on the toolbar. This will merge the cells into one single cell and centre the text vertically.
Step 2
Fill the cells A1:M1 with any blue pattern of your choice.
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:M1 and apply a blue fill color from the formatting options. You can choose a solid blue color or a blue gradient based on your preference.
Step 3
Continue the numbering pattern in cells A3:A6 to allocate a number to EVERY participant.
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 A3, enter the first participant number (e.g., 1). In A4, use the formula =A3+1 to continue the pattern. Drag the fill handle down from A4 to A6 to auto-fill the numbers for the remaining participants.
Step 4
Insert a formula in cell D3 to display only the participants' initials from column B.
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 D3, use the formula =LEFT(B3,1)&IF(ISNUMBER(FIND(" ",B3)), MID(B3,FIND(" ",B3)+1,1), "") to extract the initials from the full name in column B. Drag the fill handle down to apply this formula to the subsequent cells.
Step 5
Insert a formula in cell F4 to allocate a unique code to each participant.
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 F4, use the formula =A4&E4&RAND()*100 where A4 contains the participant number and E4 contains the province. This will generate a unique code with a random two-digit number.
Step 6
Use a function in cell G5 to determine the full name of the province for the code in cell E5.
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 G5, apply the formula =VLOOKUP(E5,Province_Provinise!$A$2:$B$10,2,FALSE) to look up the full name of the province based on the code in E5.
Step 7
Insert a function in cell M3 to calculate the average score for the three rounds in cells J3:L3.
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 cell M3, use the formula =AVERAGE(J3:L3) to calculate the average score, and format the result to show no decimal places.
Step 8
Determine the date on which the winner will be announced in cell P2.
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 P2, use the formula =EDATE(P1,1) where P1 is the closing date, and add 31 days to get the announcement date.
Step 9
Use the SUBTOTAL to display the maximum total marks for each category.
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 the Subtotal worksheet, use the formula =SUBTOTAL(4, range) where 'range' corresponds to the category marks, to display the maximum total marks.
