VRAAG 3: SIGBLAD
LET WEL:
- Gebruik formules en/of funksies vir ALLE berekeningen in die sigblad - NSC Computer Application Technology - Question 3 - 2018 - Paper 1
Question 3
VRAAG 3: SIGBLAD
LET WEL:
- Gebruik formules en/of funksies vir ALLE berekeningen in die sigblad.
- Gebruik absolute selverwysings SLEGS waar nodig om te verseker d... show full transcript
Worked Solution & Example Answer:VRAAG 3: SIGBLAD
LET WEL:
- Gebruik formules en/of funksies vir ALLE berekeningen in die sigblad - NSC Computer Application Technology - Question 3 - 2018 - Paper 1
Step 1
3.1 Verander die vertikale instelling van ry 1 na sentreer.
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
Rechterklik op die ry 1 kop, kies 'Format Cells'. Gaan na die 'Alignment' tab en verander die 'Vertical' instelling na 'Center'.
Step 2
3.2 Voeg 'n funsie in sel K3 in die gemiddelde verkoopsprys van al die kunswerke se verkope (kolom G) te bereken.
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
Gebruik die AVERAGE-funksie in sel K3: =AVERAGE(G3:G43).
Step 3
3.3 Voeg 'n COUNTIFS-funksie in sel K4 in om die detail kunswerke binne 30 dae of minder (kolom E) en groter as R2000 (kolom G) te tel.
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
Gebruik die COUNTIFS-funksie in sel K4: =COUNTIFS(E3:E43,"<=30",G3:G43,">2000").
Step 4
3.4 Voeg 'n SUMIF-funksie in sel K5 in om die totale verkope vir die kunswerke (kolom G) wat verkoop is aan 'n koper (kolom F) in te sluit.
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
Gebruik die SUMIF-funksie in sel K5: =SUMIF(F3:F43,"*",G3:G43).
Step 5
3.5 Voeg 'n formule in sel H3 in om die gunstelinge van die kunswerke se prys (kolom B) te bereken.
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
Gebruik die formule in sel H3: =B3&LEFT(A3,2)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9).
Step 6
3.6 Verander die grafiek in die werkblad om te lyk soos hieronder getoon.
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
Voeg datanotaties toe deur op die grafiek te klik, dan 'Add Data Labels' te kies. Verwyder die legende deur dit te selekteer en die delete-knoppie te druk. Stel die 'Major Units' op 10 000 in die grafiek opsies.
