QUESTION 4: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2017 - Paper 1
Question 4
QUESTION 4: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet.
- Use absolute cell references ONLY where it is required by th... show full transcript
Worked Solution & Example Answer:QUESTION 4: SPREADSHEET
NOTE:
- Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2017 - Paper 1
Step 1
Change the page orientation to landscape.
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
Navigate to the 'Page Layout' tab and select 'Orientation' to change it to 'Landscape'.
Step 2
Change row 1 as follows:
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
To change the row height to 135 pt, right-click on the row number and select 'Row Height', then enter '135'.
Step 3
Change the picture size to fit into the merged cell A1.
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
Select the picture, and adjust its size by dragging the corners to fit into merged cell A1.
Step 4
Change the headings in cells A2:K2 as follows:
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
Select cells A2:K2, and click on the 'Bold' button in the Home tab. Then, use the 'Fill Color' option to shade the background in any color.
Step 5
Use the DATE function in cell K1 to insert the date '1 February 2018'.
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
Enter the formula =DATE(2018,2,1) in cell K1.
Step 6
Use a function in cell G4 to determine the total number of hours a parade lasted.
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
Enter the formula =(F4-E4)*24 in cell G4, ensuring that the formatting is set to display as a number.
Step 7
Insert a formula in cell N3 to determine the average ticket sales in column H.
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
Use the formula =ROUNDDOWN(AVERAGE(H3:H80),0) in cell N3 to find the average and round it down.
Step 8
Insert a formula in cell J3 to determine if the number of tickets sold in cell H3 falls between the averages.
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
Utilize the formula =IF(AND(H3>=N2, H3<=N3), 'TRUE', 'FALSE') in cell J3.
Step 9
Use a function in cell K3 to determine the total value of all the tickets sold.
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
Enter the VLOOKUP function: =VLOOKUP(I3, Places_Plekke!A2:C7, 3, FALSE) * H3 in cell K3.
