8.1 Spreadsheets are used to organise and analyse information - NSC Computer Application Technology - Question 8 - 2024 - Paper 2
Question 8
8.1 Spreadsheets are used to organise and analyse information.
8.1.1 What is the purpose of a COUNTA function?
8.1.2 When would one use the SUMIFS function?
8.1.3... show full transcript
Worked Solution & Example Answer:8.1 Spreadsheets are used to organise and analyse information - NSC Computer Application Technology - Question 8 - 2024 - Paper 2
Step 1
What is the purpose of a COUNTA function?
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
The COUNTA function is used to count all cells that contain any value in a specified range. This includes numbers, text, logical values, and errors.
Step 2
When would one use the SUMIFS function?
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 SUMIFS function is utilized when adding values based on multiple criteria across one or more ranges. This allows for conditional summation, making it particularly useful in scenarios where you need to sum data that meets specific conditions.
Step 3
When will the error message #REF! be displayed in an Excel spreadsheet?
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
#REF! error appears when a formula refers to a cell that has been deleted or moved, or when the formula is copied and references a non-existing cell.
Step 4
What other cell information can be used to sort data, excluding cell values?
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
Besides cell values, other information that can be used for sorting includes:
Font color
Cell color
Conditional formatting icon
Step 5
Suggest any THREE changes to the HTML code below to resemble the screenshot of the webpage.
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
Line 3 – Title text 'SAM's dealership' is missing.
Line 10 – Remove width attribute/width="100%".
Line 11 – Missing the break <br> tag.
Step 6
Give TWO reasons why the values for the combo box do not appear.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The row source type may not be linked to the value list.
No values were entered into the row source or cells of the wizard.
Step 7
Give TWO examples of functions that can be used in a report footer.
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
Sum
Average (AVG)
Step 8
Explain how the result of Query 2 will differ from Query 1 when executed.
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
Query 1 displays all records where Amount is less than 800 or greater than 2000 and ignores the NumberOfNights field. Query 2, on the other hand, shows all records where the NumberOfNights is greater than 2000 and the DOB is empty or not greater than 5 which is defined as certain criteria limits. Consequently, the results of these two queries will vary significantly in terms of the data they return.
