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
Give ONE reason why words such as 'color' and 'favor' are NOT identified as spelling errors when you do a spell check.
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 is set to English (US), and 'color' and 'favor' are the correct spellings in this variant, which does not recognize 'colour' and 'favour' as errors.
Step 2
Give TWO possible reasons why a main mail merge document fails to load the data source.
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, making it inaccessible to the mail merge document.
The linking to the data source may have been incorrectly done, resulting in a failure to locate the file.
Step 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.
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/Text
Date of Test
Date/Time
Mark
Number
Step 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 lock or protect the specified cells. This is done by using the 'Protect' function in the spreadsheet settings, which prevents any changes to the locked cells.
Step 5
Explain how you would correct the error that causes the message #VALUE! 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 fix the #VALUE! error, make sure that the text in the referenced cell contains a valid number. Check the cell's contents and ensure it does not contain any erroneous, non-numeric data.
Step 6
Suggest ONE correction for EACH of the two underlined arguments in the VLOOKUP function.
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
Replace cell reference A1 with a direct cell reference such as A1 to avoid broken references when copied.
Change L1:M5 to L1:M5 to maintain reference integrity when the formula is dragged down.
Step 7
Suggest ONE function that can be used to replace the whole formula in 8.7.1.
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
You can use the CONCATENATE function: =CONCATENATE(A1, A2, A3).
Step 8
Suggest ONE function that can be used to replace the whole formula in 8.7.2.
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
You can simplify this using the AVERAGE function: =AVERAGE(A1, A2, A3, A4, A5).
Step 9
Explain the purpose of EACH of the following HTML tags: <a name="NAME">
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
This tag is used to create a bookmark within the web page that you can link to. It allows you to jump to a specific section of the page when clicked.
Step 10
Explain the purpose of EACH of the following HTML tags: <a href="#NAME">
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
This tag creates a hyperlink that links to the bookmark specified, enabling users to navigate directly to that anchor point in the page when clicked.
