Photo AI
NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2022 - Paper 1
Question 4
NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet. - Use absolute cell references ONLY where necessary to ensure that formulae are corre... show full transcript
Worked Solution & Example Answer:NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2022 - Paper 1
Step 1
4.1 Insert the 4Logo image as the background of the worksheet.
Answer
To insert the 4Logo image as the background, navigate to the 'Page Layout' tab in the spreadsheet. Select 'Background' and choose the 4Logo image from the file directory. This image will then be applied as the worksheet's background.
Step 2
Step 3
4.3 Insert a combination of text functions in column B to extract the traveller's surname from column A.
Answer
In column B, use the formula:
=RIGHT(A1,LEN(A1)-FIND(" ", A1))
This formula finds the space in the full name and extracts the surname by returning all characters after the first space.
Step 4
4.4 Insert a suitable LOOKUP function in cell I15 to determine the cost per person for Necker Island.
Answer
In cell I15, input the following formula:
=VLOOKUP(F15,Cost!A3:D18,4,FALSE)
This will look for the value 'Necker Island' in cell F15 and retrieve the corresponding cost from the Cost worksheet.
Step 5
4.5 Use the subtotal feature to display the highest group cost (column C) for each traveller in the 4Bookings spreadsheet.
Answer
To use the subtotal feature, select the data range in column C, navigate to the 'Data' tab, and select 'Subtotal'. Choose 'Max' in the 'Use function' dropdown to display the highest cost for the group.