7.1 Find the 7Pics folder and do the following:
• Rename the Q7_1 image file in this folder to: Lions
• Change this folder to a compressed folder in your examination data folder - NSC Computer Application Technology - Question 7 - 2024 - Paper 1
Question 7
7.1 Find the 7Pics folder and do the following:
• Rename the Q7_1 image file in this folder to: Lions
• Change this folder to a compressed folder in your ... show full transcript
Worked Solution & Example Answer:7.1 Find the 7Pics folder and do the following:
• Rename the Q7_1 image file in this folder to: Lions
• Change this folder to a compressed folder in your examination data folder - NSC Computer Application Technology - Question 7 - 2024 - Paper 1
Step 1
Rename the Q7_1 image file in this folder to: Lions
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
Locate the Q7_1 image file within the 7Pics folder and right-click to rename it to 'Lions'.
Step 2
Change this folder to a compressed folder in your examination data folder.
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
Right-click on the 7Pics folder and select 'Compress' or 'Send to > Compressed (zipped) folder' to compress it.
Step 3
Use a spreadsheet feature to display a list of all bear species where the reproduction in captivity is very easy.
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 the Q7_2 worksheet, apply a filter to the 'Species' column containing the word 'bear' and set the 'Reproduction in Captivity' filter to 'Very Easy'. Record the number of results that match this criteria.
Step 4
Use a spreadsheet feature to display the unique mating systems.
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
In the Q7_3 worksheet, utilize the 'Remove Duplicates' feature to isolate the unique mating systems from the relevant column. Ensure that the result shows exactly 10 unique mating systems.
Step 5
Use spreadsheet features to modify the data as in the screenshot.
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
In the Q7_4 worksheet, sort the 'Reproduction in Captivity' column alphabetically, ensuring that each change is reflected accurately. Utilize the MAX function for the 'Max' column and ensure subtotal calculations are correctly added.
Step 6
Use the 7MemAccess database to create a merged document for Gold status access card members.
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
Execute a query: SELECT * FROM 'Info' WHERE 'DateJoined' >= '2000/01/01' AND 'DateJoined' <= '2020/12/31'. Create the merge fields <Name>, <Surname>, and <ID Number> to populate the corresponding areas in the document.
Step 7
Complete the mail merge and save the merged document as 7Merged.
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
After inserting the required fields into the 7AccessCard document, complete the mail merge and save it under the name '7Merged'.
