3.1 Insert today's date in cell H1 in the format dd mmm YY - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Question 3
3.1 Insert today's date in cell H1 in the format dd mmm YY.
3.2 Merge and centre the cells A1 to G2.
3.3 Insert a thick border on the left and right side of each cel... show full transcript
Worked Solution & Example Answer:3.1 Insert today's date in cell H1 in the format dd mmm YY - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Step 1
Insert today's date in cell H1 in the format dd mmm YY.
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 insert today's date in cell H1 in the required format, select cell H1 and use the formula =TEXT(TODAY(), "dd mmm YY"), ensuring that the format matches the specified criteria.
Step 2
Merge and centre the cells A1 to G2.
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 A1 to G2, right-click, and choose 'Format Cells'. Then go to the 'Alignment' tab and check 'Merge cells'. Finally, select 'Center' to centre the text.
Step 3
Insert a thick border on the left and right side of each cell from A3 to O3.
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
Select cells A3 to O3, right-click, choose 'Format Cells', go to the 'Border' tab, and apply a thick border to the left and right edges.
Step 4
Freeze row 3.
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 freeze row 3, navigate to View > Freeze Panes. Select 'Freeze Top Row' to ensure that row 3 remains visible while scrolling.
Step 5
Use suitable text functions to create a member code in cell A4.
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 cell A4, use the formula =CONCATENATE(B4, LEN(E4), "#code"), where B4 contains the Name field and E4 contains the Membership Status field.
Step 6
Insert a function/formula in cell H4 to determine the Years Of Service.
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 cell H4, use the formula =ROUNDUP(YEAR(H1) - YEAR(G4), 0) to calculate the years of service, rounding as necessary.
Step 7
Use a formula/function in cell N20 to find the total amount raised by James.
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 N20, enter the formula =SUM(I2:M2) for the total amount, ensuring that it reflects values specific to James.
Step 8
Apply conditional formatting to the Amount Raised values in column N.
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 the cells in column N, use Conditional Formatting, and set rules to shade cells between R 200 and R 250.
Step 9
Use a function in cell O4 to find the type of reward for Jacob.
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 O4, input the formula =IF(N4 <= 0, "Adoption Cert", IF(N4 <= 100, "Participation Cert", "")) to determine the reward based on the calculated difference.
Step 10
Calculate in cell E51, the total amount raised by all the platinum members.
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 E51, use the formula =SUMIF(D:D, "Platinum", N:N) to sum the total amounts raised by platinum members.
Step 11
Calculate the number of members who belong to SEE Turtles Campaign, in cell E52.
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
For cell E52, input =COUNTIF(D:D, "SEE Turtles Campaign") to get the number of members in that campaign.
Step 12
Calculate the average age of all the female members in cell E53.
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
To find the average age, use =AVERAGEIF(C:C, "Female", E:E) in cell E53, where column C contains gender and column E contains age.
Step 13
Use a function in cell E54 to find the number of Members who did not participate.
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 E54, use the formula =COUNTIFS(F:F, "Not Participated", G:G, "Turtle Goodies") to count members who did not participate in both events.
Step 14
Change the graph to appear with specific requirements.
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
Edit the graph by including 2014 data, making series overlap at -50°, labeling the x-axis, and setting the minimum y-axis value to 5 through the format options.
