Photo AI
QUESTION 3: SPREADSHEET NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2024 - Paper 1
Question 3
QUESTION 3: SPREADSHEET NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet. - Use absolute cell references ONLY where necessary to ensure... show full transcript
Worked Solution & Example Answer:QUESTION 3: SPREADSHEET NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2024 - Paper 1
Step 1
Step 2
Step 3
Insert a SUMIFS function in cell E3 to determine the total budget for all the mammals that arrived after 2015.
Answer
In cell E3, enter the formula:
=SUMIFS(G7:G59,D7:D59,"Mammals",F7:F59,">2015/01/01")
``` This formula sums the budget of mammals where the arrival date is after January 1, 2015.
Step 4
Modify the conditional formatting of the grooming budget so that: - A value of 15000 or more will be marked with a red flag - A value of 10000 and above will be marked with a yellow flag - Any other values will be marked with a green flag.
Answer
Select the range of cells for the grooming budget (e.g. H7:H59). Go to 'Conditional Formatting' > 'New Rule.' Set the rules as follows:
- For the red flag, use 'Format cells that are greater than or equal to 15000.' Choose the red fill color.
- For the yellow flag, use 'Format cells that are greater than or equal to 10000 but less than 15000.' Choose the yellow fill color.
- For the green flag, use 'Format cells that are less than 10000.' Choose the green fill color.
Step 5
Insert a formula in cell I7 to determine the amount for the 2025 budget based on the annual food and grooming budgets plus an increase of 2.25%.
Answer
In cell I7, input the following formula:
=SUM(G7*12, H7)*1.0225
``` This formula calculates the 2025 budget by summing the annual food budget (G7 times 12) and the grooming budget (H7), then applying a 2.25% increase.
Step 6
Modify the chart to appear as follows:
Answer
Select the data for the chart and go to 'Insert' > 'Chart.' Adjust the chart type to 'Pie Chart' and make sure the percentages and labels are displayed correctly. For data labels, ensure the separator is a space, and the chart reflects the proportions for Grass/Hay, Endives, and Water for 2024.