4.1 Format the worksheet as follows:
Change the page orientation to landscape - NSC Computer Application Technology - Question 4 - 2020 - Paper 1
Question 4
4.1 Format the worksheet as follows:
Change the page orientation to landscape.
Ensure that row 2 will be repeated at the top of each page when you print the workshee... show full transcript
Worked Solution & Example Answer:4.1 Format the worksheet as follows:
Change the page orientation to landscape - NSC Computer Application Technology - Question 4 - 2020 - Paper 1
Step 1
Page layout
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
Change the page orientation to landscape by navigating to the Page Layout tab in the ribbon and selecting 'Orientation' -> 'Landscape'.
For row 2, go to the Page Layout tab, click on 'Print Titles', and set 'Rows to repeat at top' to $2:$2.
Step 2
Cell D3 (Check for building blocks)
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 extract text after the '@' sign in cell C3, the formula will be:
=RIGHT(C3, LEN(C3) - SEARCH("@", C3))
This uses the SEARCH function to find the position of '@', and RIGHT to extract the portion of the string after it.
Step 3
Cell F4
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
To find the location of the pyramid using a lookup function, use:
=VLOOKUP(E4, Code_Kode!$A$2:$C$43, 3)
This looks up the date of birth from E4 in the Code_Kode worksheet and retrieves the location.
Step 4
Cell H5 (Check for building blocks)
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
To calculate the age of 'Gabriel Willard', use:
=INT((TODAY() - G5) / 365.25)
This formula finds the difference between today's date and the birth date in G5, divides by the average number of days in a year, and rounds down to get completed years.
Step 5
Cell I14 (Check for building blocks)
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
To determine if a visitor is under 60 and visited Giza, use:
=IF(AND(H14 < 60, I14 = "Giza"), "Yes", "No")
This checks both conditions and displays 'Yes' if true, otherwise 'No'.
