Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Question 3
Use formulae and/or functions for ALL calculations in the spreadsheet. Use absolute cell references only where necessary to ensure that formulae are correct when you... show full transcript
Worked Solution & Example Answer:Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Step 1
3.1 Merge and centre the contents of cells A1:M1.
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 merge and centre the contents of cells A1:M1, select the range A1:M1 and use the 'Merge & Center' option in the toolbar.
Step 2
3.2 Insert a function in cell G2 that will always display the current date.
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 cell G2, use the formula =TODAY() to display the current date, which updates automatically.
Step 3
3.3 Insert a function in cell B3 to determine the number of members listed.
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 cell B3, insert the formula =COUNTA(B5:B103) to count all the entries in the members' names listed in the specified range.
Step 4
3.4 The surnames should appear in capital letters. Use a function in cell A5 to display the surname in cell B5 in capital letters.
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 cell A5, enter the formula =UPPER(B5) to convert the surname in cell B5 to uppercase letters.
Step 5
3.5 Set the print area of the Member_Lid worksheet to include a list of only the members' surnames, names and their year of birth, with gridlines.
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
To set the print area, select the range B4:D103, go to the Page Layout tab, and set the print area in the 'Print Area' section. Ensure that gridlines are enabled for printing.
Step 6
3.6 Change the format of ALL the data in column G to appear as dates in the format 1998-03-26.
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 column G and format the cells by choosing 'Date' from the Format Cells options, ensuring to select the yyyy-mm-dd format.
Step 7
3.7 Use a function/formula to add the area code '011' to the beginning of the number and display in cell H5.
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 cell H5, use the formula =CONCATENATE("011", I5) or ="011" & I5 to prepend the area code '011' to the number in cell I5.
Step 8
3.8 Insert a function in cell K5 to determine if an e-mail must be sent.
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 cell K5, enter the formula =IF(ISBLANK(J5), "Yes", "No") to check if cell J5 is blank and return 'Yes' if it is, otherwise return 'No'. Ensure to copy this formula down to K6:K103.
