3.1 Delete Sheet3 from the workbook - NSC Computer Application Technology - Question 3 - 2023 - Paper 1
Question 3
3.1 Delete Sheet3 from the workbook.
3.2 Set the print area to cells A12:E62.
3.3 Add the text 'Marathon Logo' as the Alt Text of the image in cell A3.
3.4 Insert... show full transcript
Worked Solution & Example Answer:3.1 Delete Sheet3 from the workbook - NSC Computer Application Technology - Question 3 - 2023 - Paper 1
Step 1
Delete Sheet3 from the workbook.
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 delete Sheet3, right-click on the sheet tab labeled 'Sheet3' and select 'Delete'.
Step 2
Set the print area to cells A12:E62.
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
Navigate to the Page Layout tab, find the 'Print Area' option, and select 'Set Print Area'. Highlight the cells from A12 to E62 before confirming.
Step 3
Add the text 'Marathon Logo' as the Alt Text of the image in cell A3.
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 the image in cell A3, select 'Format Picture', go to the 'Size & Properties' tab, and enter 'Marathon Logo' in the 'Alt Text' section.
Step 4
Insert a function in cell F5 to determine the average qualifying time.
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 F5, use the formula:
=AVERAGE(I13:I62)
This formula calculates the average of the values in the range I13 to I62.
Step 5
Insert a formula in cell F8 to calculate how many stations will be placed on the route.
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 F8, the following formula can be used:
=TRUNC(F3/5)+2
This calculates the number of 5 km sections in the distance (F3) and adds 2 for the start and finish stations.
Step 6
Generate an entry number in cell B20 for the athlete, Kuda.
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 B20, use the formula:
=CONCATENATE(RANDBETWEEN(1,50), LEFT(C20,2), A20)
This formula generates a random number between 1 and 50, followed by the first two letters of Kuda's name, and then the registration number from A20.
Step 7
Insert a VLOOKUP function in cell J17 to display the colour of the wristband that Lucky will wear.
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 J17, input the following VLOOKUP function:
=VLOOKUP(F17,Band!$A$1:$B$6,2,FALSE)
This looks up the age group in cell F17 and returns the corresponding wristband colour from the table in the Bands worksheet.
