8.1 You typed the word 'text', but M appeared - NSC Computer Application Technology - Question 8 - 2020 - Paper 2
Question 8
8.1 You typed the word 'text', but M appeared.
How do you ensure that the word 'text' is displayed instead of the symbols?
8.2 Name ONE setting that can be adju... show full transcript
Worked Solution & Example Answer:8.1 You typed the word 'text', but M appeared - NSC Computer Application Technology - Question 8 - 2020 - Paper 2
Step 1
How do you ensure that the word 'text' is displayed instead of the symbols?
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
To ensure the word 'text' is displayed instead of symbols, change the font settings or use the Format Painter to apply the correct font style.
Step 2
Name ONE setting that can be adjusted by using the ruler of a word processor.
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
One setting that can be adjusted using the ruler option is the margin settings, which can be modified for page width and height.
Step 3
What must you do before you can insert an automated citation in a word processing document?
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
Before inserting an automated citation, you must use the 'Manage Sources' option to select the reference source or add a reference source in the citation options.
Step 4
Which spreadsheet option would you use to print only the cell range A1:D10?
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 print only the cell range A1:D10, use the 'Set Print Area' option in the print settings.
Step 5
Which Paste Special option would you use to enable the graph in the word processing document to update when the data in the spreadsheet changes?
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
Use the 'Paste link' option when pasting the graph to maintain a connection that updates it automatically with changes.
Step 6
Why do the letters C and D not appear in the spreadsheet, as shown in the screenshot below?
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 letters C and D do not appear because their columns have been set to a width of zero or they are hidden.
Step 7
Explain the concept of a circular reference in a spreadsheet.
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
A circular reference occurs when a formula refers back to its own cell, creating a loop that prevents the formula from calculating correctly.
Step 8
Suggest ONE way to ensure that the correct marks appear for all listed learners.
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
One way to ensure correct marks is to use the VLOOKUP function accurately by ensuring the lookup table is correctly formatted or transposing the data as needed.
