Photo AI
In the calculation for the Total cost for transport, in cell C4, the formula was: =B4*$E$1 - NSC Computer Application Technology - Question 8 - 2017 - Paper 2
Question 8
In the calculation for the Total cost for transport, in cell C4, the formula was: =B4*$E$1. The formula was then copied down (Autofill) for the other items. Name th... show full transcript
Worked Solution & Example Answer:In the calculation for the Total cost for transport, in cell C4, the formula was: =B4*$E$1 - NSC Computer Application Technology - Question 8 - 2017 - Paper 2
Step 1
Name the TWO types of cell references used in the formula and explain the difference between the two.
Answer
-
Relative Cell Reference: This type changes when the formula is copied. For example, if the formula in cell C4 is copied to C5, the reference would change to B5.
-
Absolute Cell Reference: This type remains constant regardless of where the formula is copied. In this case, 1 will always refer to cell E1, no matter the location of the formula.
Step 2
Explain TWO ways in which this can be corrected.
Answer
-
Change Regional Settings: Adjust the settings on the computer to South African currency in the control panel, ensuring that the currency format reflects the correct symbols.
-
Formatting Options: Change the cell format to currency and manually select the South African Rand symbol instead of the default dollar sign.
Step 3
Name THREE items that should be added to the pie chart, to make it meaningful and easy to interpret.
Answer
-
Title/Heading: A descriptive title that explains what the pie chart represents.
-
Legend: Include a legend that identifies each section of the pie chart and its corresponding category.
-
Data Labels/Percentage: Show the actual amounts or percentages for each category to provide a clearer understanding of the breakdown.