3.1 Voeg vandag se datum in sel H1 in die formaat dd mmm YY - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Question 3
3.1 Voeg vandag se datum in sel H1 in die formaat dd mmm YY.
3.2 Merge en sentreer die selle A1 tot G2.
3.3 Voer 'n dik selyn in die linker- en regterkantyn van el... show full transcript
Worked Solution & Example Answer:3.1 Voeg vandag se datum in sel H1 in die formaat dd mmm YY - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Step 1
Voeg vandag se datum in sel H1 in die formaat 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
In cell H1, input today's date formatted as dd mmm YY. This can be done by selecting the cell, going to Format Cells, and selecting the appropriate date format.
Step 2
Merge en sentreer die selle A1 tot 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 the range A1 to G2, and then use the Merge & Center feature in the toolbar to merge and center the cells.
Step 3
Voer 'n dik selyn in die linker- en regterkantyn van elke sel A3 tot 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 the range A3 to O3, then go to Border options and select the Border style. Apply the thick border setting to both the left and right sides of each cell in the selected range.
Step 4
Vries (Freeze) ry 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, go to the View tab, select Freeze Panes, and choose Freeze Top Row to keep Row 3 visible while scrolling.
Step 5
Gebruik hy gepaste teksfunksie om 'n lidkode (member code) in sel A4 te skep.
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") to create a member code that concatenates the member's ID and a code.
Step 6
Voeg 'n funksie/formule in sel H4 om die aantal jare diens (Years of Service) te bepaal.
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, input the formula =ROUNDDOWN((H$1-G4)/365.25,0) to calculate the years of service by dividing the difference by 365.25.
Step 7
Pas voorwaardelike formatting (conditional formatting) toe op die Amount Raised waardes.
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 column N, then go to Conditional Formatting and set rules to shade values between R 200 and R 250, along with additional formatting for specific ranges.
Step 8
Bereken in E51, die totale bedrag ingesamel deur al die platinum lede.
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 E51, use the formula =SUMIF(E4:E49, "Platinum", N4:N49) to calculate the total amount raised by platinum members.
Step 9
Bereken die aantal lede wat aan die SEE Turtles Campaign behoort, in sel E52.
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 E52, input the formula =COUNTIF(F4:F49, "SEE Turtles") to count the members belonging to the SEE Turtles Campaign.
Step 10
Bereken die gemiddelde ouderdom van die vroulike lede in E53.
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 E53, use the formula =AVERAGEIF(D4:D49, "F", C4:C49) to calculate the average age of female members.
Step 11
Gebruik 'n funksie/benadering van funksies in sel E54.
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 E54, use the formula =COUNTBLANK(J4:J49) + COUNTBLANK(L4:L49) to count members not associated with the specified events.
Step 12
Gebruik die LOOKUP-funksie in sel B2.
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 B2, use the formula =VLOOKUP(A2, LOOKUP!$A$1:$B$95, 2, FALSE) to find the corresponding member name in the LOOKUP worksheet based on the member ID.
