A spreadsheet was created that contains data on the longest rivers in the world - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Question 7
A spreadsheet was created that contains data on the longest rivers in the world.
7.1 Open the 7Rivers_Riviere spreadsheet.
7.1.1 Add the worksheet name as a field ... show full transcript
Worked Solution & Example Answer:A spreadsheet was created that contains data on the longest rivers in the world - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Step 1
Add the worksheet name as a field in the left section of the header.
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
In the 7Rivers_Riviere spreadsheet, navigate to the header section and add the worksheet name in the left area of the header.
Step 2
Change the named range to 'Name_River'.
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
Open the named ranges section and modify the existing named range for the rivers to 'Name_River'.
Step 3
Protect column A to column C so that users cannot enter text.
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
Select columns A through C and apply protection settings, ensuring that users cannot edit these columns. Set the password to '123'.
Step 4
Open the 7River_Rivier database and import the data.
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
Access the 7River_Rivier database and import data from the 7Rivers_Riviere spreadsheet, creating a new table called 'Rivers'.
Step 5
What is the gutter position setting of the document?
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
The gutter position setting of the document is 'Top'.
Step 6
How many paragraphs appear in the document?
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
There are 83 paragraphs in the document.
Step 7
How many occurrences of the letter 'm' (upper case and lower case) appear in the 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
The document contains 185 occurrences of the letter 'm' (both upper and lower case).
Step 8
What is the first word that appears on line 100 in the document?
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 first word that appears on line 100 is 'rates'.
Step 9
What is the line weight/width of the 'Intense Quote' style?
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
The line weight of the 'Intense Quote' style is 0.5 OR (1/2) pt.
Step 10
Which word is marked as an index?
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
The word marked as an index is 'SHARPS'.
Step 11
What is the title of the single-source citation that appears in the document?
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
The title of the single-source citation is 'Water Savers'.
