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 adj... 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 rectify the appearance of symbols instead of text, you can change the font or utilize the 'Change Symbol' feature to input the correct text.
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 is the margin settings, which influence the indents of paragraphs.
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, ensure you have added a reference source using the 'Manage Sources' option.
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
You would utilize the 'Set Print Area' option to specify that only the cells from A1 to D10 should be printed.
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
You should use the 'Paste Link' option in the Paste Special dialog, which creates a link between the graph and the original data source.
Step 6
Why do the letters C and D not appear in the spreadsheet?
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 may not appear because their corresponding columns have been set to a width of zero or have been hidden from view.
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 to its own cell either directly or indirectly, creating a loop where the value cannot be calculated.
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 resolve the issue with the LOOKUP function is to transpose the data in the lookup table to match the expected order of the lookup values.
