Format row 1 as follows:
- Merge and centre cells A1:1 - NSC Computer Application Technology - Question 3 - 2020 - Paper 1
Question 3
Format row 1 as follows:
- Merge and centre cells A1:1.
- Increase the font size of the text to 13.
Insert an appropriate date function in cell C3 to extract the mo... show full transcript
Worked Solution & Example Answer:Format row 1 as follows:
- Merge and centre cells A1:1 - NSC Computer Application Technology - Question 3 - 2020 - Paper 1
Step 1
Format row 1 as follows:
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 format row 1, first merge and center the cells A1 through A1. Then, increase the font size to 13 to enhance visibility.
Step 2
Insert an appropriate date function in cell C3.
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 C3, use the function =MONTH(A3) to extract the month from the date in A3. Ensure the cell is formatted as 'General' or 'Text' so that the month number displays correctly.
Step 3
Enter a function in cell C4.
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 C4, enter the formula =AVERAGE(H8:H19). This will calculate the average number of tourists per month, ensuring that the result shows no decimal places.
Step 4
Use the SUMIF function in cell C5.
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 C5, apply the formula =SUMIF(B:B,"Peak",G:G). This will sum the total number of tourists from the peak season for 2019.
Step 5
Insert a formula in cell I8.
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 I8, use the formula =IF(C8=SUM(D8:D12),"Correct","Error"). This formula will check if the total in column H matches the expected total and display 'Correct' or 'Error' accordingly.
Step 6
Copy the formula down to the other cells.
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
To apply the formula in I8 to the other cells in column I, drag the fill handle down from cell I8 to fill the corresponding cells.
Step 7
Apply a fill colour to the cell range C8:G19.
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 range C8:G19 and use conditional formatting to set a fill color of your choice for the cells where the number of tourists is lower than the average for the years 2015 to 2019.
