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 examinatio... 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
To rename the file, navigate to the 7Pics folder, right-click on the Q7_1 image file, select 'Rename', and enter 'Lions' as the new filename.
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
To compress the folder, right-click on the 7Pics folder, select 'Send to', and then choose 'Compressed (zipped) folder'.
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. Set the filter criteria to include only entries containing 'bear' and set the 'Reproduction in Captivity' filter to 'Very Easy'. This will display the unique bear species that meet the 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, use the 'Remove Duplicates' feature on the 'Mating System' column to display the unique mating systems. Verify that there are a total of 10 unique mating systems after this operation.
Step 5
Use spreadsheet features to modify the data so that it appears 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. Ensure that each change in the column is captured, with a subtotal added to the 'Max' and 'Maks' columns. Verify that all modifications align with the provided screenshot.
Step 6
Use the 7MemAccess database to create a merged document for only those members who qualify for a Gold status access card.
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
Open the 7AccessCard document. Employ the mail merge feature by linking it to the 7MemAccess database. Filter the records based on the 'Date Joined' field, ensuring to only include those from the year 2000 to the end of 2020.
Step 7
Replace the text <Name>, <Surname> and <ID Number> with the appropriate merge fields.
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 mail merge document, replace the placeholders <Name>, <Surname>, and <ID Number> with the corresponding merge fields from the 7MemAccess database.
Step 8
Complete the mail merge and save the merged document as 7Merged.
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
Finish the mail merge process to generate the document, ensuring data fields are populated correctly. Save this final document as '7Merged'.
