Die skermkopie van die sigblad hieronder toon die verdienste van Sam, 'n verkoopsverteenwoordiger - NSC Computer Application Technology - Question 8 - 2022 - Paper 2
Question 8
Die skermkopie van die sigblad hieronder toon die verdienste van Sam, 'n verkoopsverteenwoordiger.
Sam's Sales
| Stock description | Date purchased | Date sold | N... show full transcript
Worked Solution & Example Answer:Die skermkopie van die sigblad hieronder toon die verdienste van Sam, 'n verkoopsverteenwoordiger - NSC Computer Application Technology - Question 8 - 2022 - Paper 2
Step 1
Watter sort formatting is in ry 1 gebruik, behalwe vir die veranderinge aan die font?
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
In row 1, the formatting used includes merging and centering the cells for a clean and structured appearance.
Step 2
Watter data in die sigblad het nie konsekwente formatting nie?
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
The data in 'Date purchased' and 'Date sold' columns does not have a consistent format, as they mix different formats (e.g., dd/mm/yyyy vs. yyyy/mm/dd).
Step 3
Die formule wat gebruik is om die bonuskommissie in sel G4 te bereken is:
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The −symbolinG$2 indicates that the reference to this cell is absolute. This means that when the formula is copied to other cells, this reference will remain constant and does not change.
Step 4
Hoe kan jy die fout wat in sel F9 voorkom, regstel?
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
To correct the error in cell F9, ensure that the formula references correct data ranges or correct any typographical errors in the cell references.
Step 5
Gee EEN rede waarom hierdie resultaat verkeerd is.
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
One reason the SUM function returns an incorrect result could be due to the inclusion of non-numeric values in the range intended for summation, which can lead to a miscalculation.
