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. When ... 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
The two types of cell references in the formula are:
-
Relative Cell Reference: This type changes when the formula is copied to another cell. For example,
B4is a relative reference; if copied down to the next row, it would change toB5. -
Absolute Cell Reference: This reference remains constant when the formula is copied.
E$1is an absolute reference, which keeps the row fixed while allowing the column to change.
Step 2
Explain TWO ways in which this can be corrected.
Answer
-
Change Regional Settings: Adjust the settings in the control panel to reflect the currency format of South Africa, which would display the R-sign.
-
Format as Currency: In the spreadsheet software, select the cells showing currency and format them explicitly as South African Rand (R).
Step 3
Name THREE items that should be added to the pie chart to make it meaningful and easy to interpret.
Answer
- Title/Heading: Provide a clear title for the pie chart to explain what it represents.
- Legend: Include a legend that identifies each section of the pie chart according to the categories of costs.
- Data Labels/Percentages/Values: Display data labels or percentages on each section to indicate the cost value relative to the total.