Open the 7Data spreadsheet - NSC Computer Application Technology - Question 7 - 2016 - Paper 1
Question 7
Open the 7Data spreadsheet. Work in the Inves worksheet.
7.1 Set the print area to cells G1:N50.
7.1.2 Use data validation to validate the data in cells G2:G101 to... show full transcript
Worked Solution & Example Answer:Open the 7Data spreadsheet - NSC Computer Application Technology - Question 7 - 2016 - Paper 1
Step 1
7.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
In the Inves worksheet of the 7Data spreadsheet, navigate to the Page Layout tab and select 'Print Area'. Choose 'Set Print Area' and specify cells G1: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:G101, go to the Data tab, click on 'Data Validation', choose 'Whole Number' from the 'Allow' dropdown, set 'Minimum' to 0, then click OK.
Step 3
7.2 Open the 7DataImp database and import the data in the Inves worksheet of the 7Data spreadsheet to a new table called Clients in the 7DataImp database.
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 7DataImp database. Use the 'External Data' tab to import data from the 7Data spreadsheet. Select the Inves worksheet, choose 'Table' option, name the new table 'Clients', and ensure the field names match those in the spreadsheet.
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, go to the Review tab, select 'Accept All Changes', then choose 'Track Changes' to turn it off.
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
Right-click on the endnote reference in the 7Gem_Edel document, select 'Convert to Footnote' to change its format.
Step 6
7.3.3 Change the paragraph spacing of the text in the paragraph with the paragraph border towards the end of the page to 3 pt after.
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 near the end of the page, right-click, choose 'Paragraph', and set the spacing 'After' to 3 pt.
Step 7
7.3.4 Apply the same tab setting to the <<Birthstone_GeboorteSteen>> field that was used on the <<Month_Maand>> 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 and apply the tab settings used on <<Month_Maand>> by matching the tab stop position and alignment.
Step 8
7.3.5 Replace the text '<<InvestorName_BelegerNaam>>' with the merged field InvestorName_BelegerNaam.
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
Find '<<InvestorName_BelegerNaam>>' in the 7Gem_Edel document and replace it with the field placeholder '<<InvestorName_BelegerNaam>>' using the Mailings tab.
Step 9
7.3.5 Edit the data source recipient list to include ONLY the data of those investors whose month of birth is October.
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 data source (7DOB spreadsheet), apply a filter on the month of birth column to select records for October only.
Step 10
7.3.6 Complete the merge and save the document as 7GemMerge.
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 Mailings tab, select 'Finish & Merge' then 'Edit Individual Documents', choose 'All' and click OK. Save the merged document as '7GemMerge'.
Step 11
7.4.1 How many investors bought coins in any dollar currency?
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 7Coin_Munt spreadsheet, filter the CoinFaceValue column for entries containing '$' or use the formula:
=COUNTIF(M2:M101,"∗Dollar∗")
Step 12
7.4.2 How many long-term investors have a start date in September?
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
Using the InvestmentTerm column, filter for 'Long' and the StartDate column for 'September'. Count these records. Alternatively, use:
=COUNTIFS(D2:D101,"Long",P2:P101,"September")
Step 13
7.4.3 What is the name of the most popular occurring coin?
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
Utilize the COUNTIF function to find the most occurring coin name. Use the formula:
