7.1 Open the 7Data spreadsheet - NSC Computer Application Technology - Question 7 - 2016 - Paper 1
Question 7
7.1 Open the 7Data spreadsheet. Work in the Inves worksheet.
7.1.1 Set the print area to cells G1:N50.
7.1.2 Use data validation to validate the data in cells G2:G... show full transcript
Worked Solution & Example Answer:7.1 Open the 7Data spreadsheet - NSC Computer Application Technology - Question 7 - 2016 - Paper 1
Step 1
7.1.1 Set the print area to cells G1:N50.
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 set the print area, navigate to the Page Layout tab in the Ribbon. Click on 'Print Area' and select 'Set Print Area' after highlighting cells G1 to N50.
Step 2
7.1.2 Use data validation to validate the data in cells G2:G101 to accept only whole numbers greater than or equal to 0.
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
Select cells G2 to G101. Go to the Data tab and click on 'Data Validation.' Choose 'Whole Numbers' and set the criteria to 'greater than or equal to' 0.
Step 3
7.2 Open the 7DataImpc database and import the data in the Inves worksheet of the 7Data spreadsheet.
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
Open the 7DataImpc database. Use the 'External Data' option to import data from the 7Data spreadsheet. Select the Inves worksheet and ensure that the field names are imported correctly. Save the new table as Clients.
Step 4
7.3.1 Accept all the track changes in the document and stop the track changes.
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 7Gem_Edel document, navigate to the Review tab, use the 'Accept All Changes' option, and then turn off the 'Track Changes' feature.
Step 5
7.3.2 Convert the endnote to a footnote.
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
Locate the endnote, right-click on it, and select 'Convert to Footnote' from the context menu.
Step 6
7.3.3 Change the paragraph spacing of the text in the paragraph.
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
Select the paragraph in question, right-click, and choose 'Paragraph.' Adjust the spacing after to 3 pt.
Step 7
7.3.4 Apply the same tab setting to the <<Birthstone_Geboortesteen>> field.
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
Select the <<Birthstone_Geboortesteen>> field text, go to the Paragraph settings, and apply the same tab settings as used in the <<Month_Maand>> field.
Step 8
7.3.5 Ensure that the 7Gem_Edel mail merge document is linked to the data source.
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
In the 7Gem_Edel document, navigate to 'Mailings,' then to 'Select Recipients.' Ensure the data source is set to the 7DOB spreadsheet.
Step 9
Replace the text '<<InvestorName_BelegerNaam>>' with the merged field InvestorName_BelegerNaam.
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
Use the find and replace option to find '<<InvestorName_BelegerNaam>>' and replace it with 'InvestorName_BelegerNaam' to link the field.
Step 10
Edit the data source recipient list.
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
Go to 'Edit Recipient List' in the Mailings tab and filter the list to only show investors whose month of birth is October.
Step 11
7.3.6 Complete the merge and save the document as 7GemMerge.
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 Mailings tab, click 'Finish & Merge' and select 'Edit Individual Documents.' Save the merged document as 7GemMerge.
Step 12
7.4.1 How many investors bought coins in any dollar currency?
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
In the 7Coin_Munt spreadsheet, filter on CoinFaceValue to find entries containing '$' or use the COUNTIF function:
=COUNTIF(M2:M101,"*")
Step 13
7.4.2 How many long-term investors have a start date in September?
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
Use the filter on InvestmentTerm='Long' and filter StartDate between '01/09/yyyy' and '30/09/yyyy'. Count the entries that fall within this range.
Step 14
7.4.3 What is the name of the most popular coin that appears?
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
Use the COUNTIF function to find the most frequently occurring coin:
=MODE(D2:D101) for determining the most popular coin.
