Photo AI
Open the 7Discount spreadsheet - NSC Computer Application Technology - Question 7 - 2022 - Paper 1
Question 7
Open the 7Discount spreadsheet. Work in the Code worksheet. 7.1.1 The travel company has decided to give some of their travellers a pensioner's discount if their y... show full transcript
Worked Solution & Example Answer:Open the 7Discount spreadsheet - NSC Computer Application Technology - Question 7 - 2022 - Paper 1
Step 1
7.1.1 Use a nested IF function or a formula in cell D2
Answer
To display the appropriate discount code in cell D2, you can use the following formula:
=IF(AND(YEAR(B2)<1960, C2="Mid-range"), 5, IF(AND(YEAR(B2)<1960, C2="Luxury"), 4, 0))
Explanation:
YEAR(B2)<1960: This checks if the traveller's birth year is before 1960.C2="Mid-range": Checks if their travel style is Mid-range. If both conditions are met, the formula returns 5.- If the first condition fails, it checks for the Luxury travel style and returns 4 if that condition is met.
- If neither condition is satisfied, it returns 0 for all other travellers.
Step 2
7.1.2 Filter the worksheet to display the records of the travellers born in the first three months of 1979
Answer
To filter the worksheet for travellers born in the first three months of 1979:
- Activate the filter option in the List worksheet.
- Set the filter criteria to display records with the year of birth as 1979.
- Further refine the filter to include only records from January, February, and March.
This approach will yield only the relevant records for the specified criteria.