4.1 Change cells A2:M2 and its contents to display as follows:
Cape Town - Accommodation
Kaapstad - Verblyf
4.2 Insert a function in cell C4 to determine how many of the places do NOT allow pets - NSC Computer Application Technology - Question 4 - 2023 - Paper 1
Question 4
4.1 Change cells A2:M2 and its contents to display as follows:
Cape Town - Accommodation
Kaapstad - Verblyf
4.2 Insert a function in cell C4 to determine how many ... show full transcript
Worked Solution & Example Answer:4.1 Change cells A2:M2 and its contents to display as follows:
Cape Town - Accommodation
Kaapstad - Verblyf
4.2 Insert a function in cell C4 to determine how many of the places do NOT allow pets - NSC Computer Application Technology - Question 4 - 2023 - Paper 1
Step 1
Change cells A2:M2 and its contents to display 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 change the contents of cells A2:M2:
Select cells A2 to M2.
Type "Cape Town - Accommodation" in cell A2.
Type "Kaapstad - Verblyf" in cell A3.
Wrap text for both cells by selecting 'Wrap Text' from the Format menu.
Add top and bottom borders to these cells for better visibility.
Ensure the text in these cells uses a consistent style.
Step 2
Insert a function in cell C4 to determine how many of the places do NOT allow pets.
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 C4, use the formula:=COUNTIF(H10:H70, "No")
This function counts all occurrences of 'No' from the range H10 to H70, indicating places that do not allow pets.
Step 3
Distance from the airport to the place of accommodation:
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
This formula checks if the distance is less than 100 for 'Short', compares with the smallest distances to determine 'Medium', or assigns 'Long' otherwise.
Step 4
If there is a swimming pool available, it will show 'yes', otherwise 'no'.
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 G10, use:
=IF(L10="Yes", "Yes", "No")
This checks if the swimming pool is available based on a Yes/No value in cell L10.
Step 5
Calculate the pricing of accommodation based on a 12.5% discount.
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 M13, implement the formula:
=C13*(1-0.125)
This calculates the final price after applying a 12.5% discount on the original price in cell C13.
