NSC Computer Application Technology Uses of common applications: 7.1 Open the 7Years spreadsheet.

Question

7.1 Open the 7Years spreadsheet.

7.1.1 Copy the data from cells A1:B6 in the Chart worksheet to cells A2:F3 in the Data worksheet.

The copied data in the Data worksheet must appear as follows:

Tourists in Egypt from 2015 to 2019
Year	2015	2016	2017	2018	2019
Number of tourists per year	11532	9464	9878	9328	4847

7.1.2 Work in the Chart worksheet. Modify the chart to display as follows:

Number of tourists per year

7.1.3 Save the pyramid chart as a 7Chart.jpg image file in your examination folder.

Work in the Visitors worksheet.

7.1.4 A named range has already been created for the amounts in column F.

Insert a function in cell J3 that uses the named range to determine how many of the amounts in the named range are greater than R14 000.

7.1.5 A validation rule has been set on cells E2:E194 to obtain data from the list in cells M4:M9. However, there are errors and omissions in the validation list (cells M4:M9), which cause data in column E to be invalid.

Correct the Validation List AND update the Validation Rule so that the data in column E becomes valid.

HINT: To identify the invalid data in column E, use the Circle Invalid Data option from the Data Validation icon in the Data Tools group.

Save and close the 7Years spreadsheet.

7.2 Open the 7Invitation word processing document.

Complete a mail merge as follows:

7.2.1 Use the 7Mail database as a data source for the 7Invitation mail merge document.

Edit the data source recipient list to include ONLY the data of those visitors who have an edu domain type AND who are born after 1960.

Name = ‘<Name>’ with the merged field Name

Add a field in the footer of the document to show the date and time the document is opened.

Save the 7Invitation document.

7.2.2 Complete the mail merge and save the document as 7InvitationMerge.

7.1 Open the 7Years spreadsheet - NSC Computer Application Technology - Question 7 - 2020 - Paper 1

Worked Solution & Example Answer:7.1 Open the 7Years spreadsheet - NSC Computer Application Technology - Question 7 - 2020 - Paper 1

Copy the data from cells A1:B6 in the Chart worksheet to cells A2:F3 in the Data worksheet.

Work in the Chart worksheet. Modify the chart to display as follows:

Save the pyramid chart as a 7Chart.jpg image file in your examination folder.

Insert a function in cell J3 that uses the named range to determine how many of the amounts in the named range are greater than R14 000.

Correct the Validation List AND update the Validation Rule so that the data in column E becomes valid.

Open the 7Invitation word processing document.

Use the 7Mail database as a data source for the 7Invitation mail merge document.

Save the 7Invitation document.

Complete the mail merge and save the document as 7InvitationMerge.

Join the NSC students using SimpleStudy...