8.1 Give ONE reason why words such as 'color' and 'favor' (instead of the expected 'colour' and 'favour') are NOT identified as spelling errors when you do a spell check on a word processing document - NSC Computer Application Technology - Question 8 - 2018 - Paper 2
Question 8
8.1 Give ONE reason why words such as 'color' and 'favor' (instead of the expected 'colour' and 'favour') are NOT identified as spelling errors when you do a spell c... show full transcript
Worked Solution & Example Answer:8.1 Give ONE reason why words such as 'color' and 'favor' (instead of the expected 'colour' and 'favour') are NOT identified as spelling errors when you do a spell check on a word processing document - NSC Computer Application Technology - Question 8 - 2018 - Paper 2
Step 1
8.1 Give ONE reason why words such as 'color' and 'favor' (instead of the expected 'colour' and 'favour') are NOT identified as spelling errors when you do a spell check on a word processing document.
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
One reason is that the language setting in the word processor is set to English (US), which recognizes 'color' and 'favor' as correct spellings.
Step 2
8.2 Give TWO possible reasons why a main mail merge document fails to load the data source when you are trying to open it.
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 source file may have been moved or deleted, leading to a failure in accessing it.
The link to the data source might not have been properly established or updated.
Step 3
8.3 Copy the table below into your ANSWER BOOK and complete it by adding a suitable data type for EACH of the THREE remaining fields (8.3.1 to 8.3.3).
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
Field Name
Data Type
Name
Text
ID Number
Short Text
Date of Test
Date/Time
Mark
Number
Step 4
8.4 How would you ensure that another user can NOT enter data into certain cells in a spreadsheet?
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 restrict data entry, you can protect the cells by locking them and enabling cell protection features in the spreadsheet software.
Step 5
8.5 Explain how you would correct the error that causes the message above to appear.
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
To resolve the #VALUE! error, check if the referenced cell contains valid data types, and update the references to ensure they point to cells that contain numeric values.
Step 6
8.6 Suggest ONE correction for EACH of the two underlined arguments.
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
Change the reference of 'A1' to use absolute referencing: =$A$1
Correct the range to fit the function criteria: change 'L1:M5' if necessary to ensure it contains the required data.
Step 7
8.7 Suggest ONE function that can be used to replace the whole formula in EACH of the following cases:
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
8.7.1 =A1&A2&A3 can be replaced with =CONCATENATE(A1, A2, A3).
8.7.2 =(A1+A2+A3+A4+A5)/5 can be replaced with =AVERAGE(A1:A5).
Step 8
8.8 Explain the purpose of EACH of the following HTML tags:
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
8.8.1 <a name="NAME"> creates a bookmark, allowing for navigation to this spot in the document.
8.8.2 <a href="#NAME"> creates a hyperlink that directs the browser to the bookmark specified.
