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
To set the print area, go to the Page Layout tab and select 'Print Area' -> 'Set Print Area'. Highlight the range G1:N50 to define the print area.
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, and click on 'Data Validation'. In the settings, choose 'Whole number' from the Allow dropdown, set the Data option to 'greater than or equal to', and input '0'.
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 and go to the Import function. Import the data from the Inves worksheet, ensuring to use the column headings and name the 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 Review tab of the 7Gem_Edel document, click 'Accept All Changes' to finalize the edits. Next, disable track changes from the Track Changes menu.
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 in the document, 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 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
Highlight the paragraph, go to the Layout tab, and adjust the spacing after the paragraph to 3 pt in the paragraph spacing options.
Step 7
7.3.4 Apply the same tab setting to the <<Birthstone_Geboorsteen>> 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
Highlight the <<Birthstone_Geboorsteen>> field, go to the Home tab, and replicate the tab settings from the <<Month_Maand>> field.
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
In the 7Gem_Edel document, locate '<<InvestorName_BelegerNaam>>', highlight it, and replace it with the merged field, ensuring the correct data is displayed.
Step 9
7.3.6 Complete the merge and save the document as 7GemMerge.
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
After completing the mail merge process, save the document under 'Save As' and name it '7GemMerge'.
Step 10
7.4.1 How many investors bought coins in any dollar currency?
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
To determine how many investors bought coins in any dollar currency, filter the CoinFaceValue column for records containing '$' or use the function: =COUNTIF(M2:M101,"*Dollar*") to count the occurrences.
Step 11
7.4.2 How many long-term investors have a start date in September?
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
You can find this by applying Long Investment filter on the InvestmentTerm column and filtering the Start Date column for 'September' by using the function:=COUNTIFS(D2:D101,"Long",P2:P101,"September").
Step 12
7.4.3 What is the name of the most popular occurring coin?
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
Use the count if function: =7 COUNTIFS(IF(7, "*Maple Leaf*")) to find the most counted occurrence of the coin in your dataset.
