The conservation of the Taj Mahal is an urgent priority - NSC Computer Application Technology - Question 7 - 2019 - Paper 1
Question 7
The conservation of the Taj Mahal is an urgent priority.
7.1 Open the 7Protect word processing document and do the following:
7.1.1 Add an automatic caption to the... show full transcript
Worked Solution & Example Answer:The conservation of the Taj Mahal is an urgent priority - NSC Computer Application Technology - Question 7 - 2019 - Paper 1
Step 1
7.1.1 Add an automatic caption to the picture.
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 add an automatic caption to the picture, navigate to the picture, right-click, and select 'Insert Caption'. Use the caption text 'Unobstructed view of Taj Mahal'. This automatically generates the caption with the appropriate formatting.
Step 2
7.1.2 Accept only the changes made by author ABC.
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 'Review' tab in the 7Protect document. Click on 'Accept' and then select 'Accept Changes Made by ABC'. This will ensure that only ABC's changes are retained, ignoring all others.
Step 3
7.2.1 Insert a formula/function in cell B2.
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
In cell B2, use the following formula to determine the number of words in the country's name:
This formula checks the number of '#' characters to ascertain if there are multiple words.
Step 4
7.2.2 Use the SUBTOTAL feature.
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 use the SUBTOTAL function, first sort the data by 'Traveller Type' and 'Gender'. Then, apply the SUBTOTAL function. For example:
=SUBTOTAL(1, C2:C100)
This will appropriately summarize the data based on the specified criteria.
Step 5
7.3 Import the data stored in the 7Half HTML file.
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 'Import' function in the 7Numbers database to load the data from the 7Half HTML file. Make sure to create a new table named 'In' for the imported data. Set the first row as field names and ensure to select an appropriate field size.
