Photo AI
Pollution is a concern for many companies and the responsibility to control it rests with the management of the companies - NSC Computer Application Technology - Question 7 - 2021 - Paper 1
Question 7
Pollution is a concern for many companies and the responsibility to control it rests with the management of the companies. 7.1 After monitoring the pollution in a s... show full transcript
Worked Solution & Example Answer:Pollution is a concern for many companies and the responsibility to control it rests with the management of the companies - NSC Computer Application Technology - Question 7 - 2021 - Paper 1
Step 1
7.1.1 Change the form controls in the letter as follows:
Answer
To change the form controls in the 7Letter document:
- Open the 7Letter document.
- Locate the form field control below the text 'Date:'.
- Set this field to display the current date using the shortcut Alt + F9.
- Ensure that the drop-down form field next to 'Reply required within:' includes the option '14'.
Step 2
7.1.2 Prepare the mail merge as follows:
Answer
To prepare the mail merge:
- Link the 7Letter document to the 7Company spreadsheet as the data source.
- Filter recipients by selecting only those companies that have a 'high' or 'very high' pollution level.
- Replace the placeholder text '<Company>' with the actual company name and '<Level>' with the pollution level from the 7Company spreadsheet.
- Save the changes to the 7Letter document once completed.
Step 3
7.2 Complete the functionality in cell D3 to display the name of the companies that have a low level (column B) of pollution and where the monitor date (column C) was in November:
Answer
In cell D3 of the Monthly worksheet, enter the formula:
=IF(AND(B3="Low", MONTH(C3)=11), A3, "")
This will return the company name if its level is 'Low' and the monitor date is in November.