NSC Computer Application Technology Information management: 7.1 The managing director reques

Question

7.1 The managing director requested a directory table that contains the names of some prestige sponsors.

Open the 7Distribute word processing document and enter your examination number in the footer.

7.1.1 Create a mail merge as follows:

NOTE: Select the Directory option when you start the mail merge.

- Link the 7Prospects spreadsheet as a data source for the 7Distribute mail merge document.
- Edit the data source recipient list to include ONLY the data of those members who have a 'Yes' Prestige_Aanmelden status AND contributed an amount greater than or equal to 800.
- Enter the merged field Surname_Van in the first cell of the table.
- Enter the merged field Name_Naam in the second cell of the table.

Save the 7Distribute document, but do NOT close it.

7.1.2 Complete the merge and save the document as 7Directory. Save and close all documents.

7.2 Open the 7Reorder spreadsheet.

Work in the Subtotal worksheet.

The SUBTOTAL feature displays the total amount donated per category.
Change the SUBTOTAL feature to determine the number of countries in each category.

7.3 Continue working in the 7Reorder spreadsheet.

7.3.1 Work in the Stock worksheet.

Use an appropriate lookup function in cell D4 to determine the minimum number of items that should be in stock using the data in the Order worksheet.

Ensure that the correct results will display if the function were to be copied to the other cells.

7.3.2 Work in Order worksheet.

Use an IF function in cell C5 to display the quantity of the stock item that must be reordered, e.g., 74 764 Drips.

NOTE: The reorder quantity is the number of items that must be ordered if the number of items in stock (Stock worksheet) is less than the number of items required.

7.1 The managing director requested a directory table that contains the names of some prestige sponsors - NSC Computer Application Technology - Question 7 - 2021 - Paper 1

Worked Solution & Example Answer:7.1 The managing director requested a directory table that contains the names of some prestige sponsors - NSC Computer Application Technology - Question 7 - 2021 - Paper 1

7.1.1 Create a mail merge as follows:

7.1.2 Complete the merge and save the document as 7Directory.

7.2 Open the 7Reorder spreadsheet.

7.3.1 Work in the Stock worksheet.

7.3.2 Work in Order worksheet.

Join the NSC students using SimpleStudy...