Downloaded from TVET lite
EKURHULENI WEST TVET COLLEGE
Good morning Guys,
I sincerely hope you are all well
I propose that in this, lesson 2, we move on to new work: the =LOOKUP function again.
There are two types of LOOKUP functions:
=HLOOKUP – IT MAKES USE OF A HORIZONAL REFERENCE TABLE
za
=VLOOKUP – IT MAKES USE OF A VERTICAL REFERENCE TABLE
The one thing that might not be possible is to insert the picture that is asked, although I did
Include it, it is in p
o.
I chose this question as it contains a VLOOKUP, HLOOKUP and an IF FUNCTION
I am going to give you the following documents:
1.
2.
.c
Notes on the LOOKUP function, NB SEE PAGE 2 for notes on range names
QUESTION PAPER: MAY 2019, QUESTION 9 READ IN MATERIAL
rs
3. QUESTION PAPER: MAY 2019, QUESTION 9
4. ANSWERS TO THE ABOVE
5. FORMULAS TO THE ABOVE
pe
Let us see how it works, you are most welcome to whatsup me with ideas or questions.
My e-mail should you want to mail me is: [email protected]
pa
Kind Regards, and again please stay safe
et
Robert Ehlers
tv
EWC– Germiston Campus 16 April 2020 Page 1 of 1 RH E/rh e
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
EKURHULENI WEST TVET COLLEGE
COMPUTER PRACTICE N6 NOTES:
za
= LOOKUP FUNCTION (VLOOKUP/HLOOKUP)
Notes:
o.
The lookup table headings need to be the same (in the spreadsheet, and in the Reference Table)
If the Ref Table runs from top to bottom (2 columns = VLOOKUP)
If the Ref table runs from left to right (2 rows = HLOOKUP)
.c
If Reference table needs to be given a name, highlight and (right click + define name)
Money values” Never type R 456,99, type 456.99 , then format for Currency, 2 decimal values
rs
FORMAT OF LOOKUP: = VLOOKUP(CELL ADDRESS OF FIRST COLUMN TITLE,ALL CELLS IN REF TABLE,2)
pe
pa
et
tv
EWC GERMISTON CAMPUS C.P. N6 NOTES 20 April 2020 Page 1 of 2 RH E/rh e
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
za
o.
.c
rs
pe
pa
PLEASE NOTE: RANGE NAMES:
HIGHLIGHT THE GIVEN CELLS, EXAMPLE A1 TO B5,
et
RIGHT CLICK
SELECT THE SECOND LAST CHOICE FROM THE BOTTOM: DEFINE NAME
KEY IN THE NAME (THE NAME IS ALWAYS GIVEN IN THE INSTRUCTIONS)
tv
ENTER.
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
A B C D E
1 TIME DATE SYSTOLIC DIASTOLIC HEART RATE
2
3 10:00 4/9/2018 129 99 72
4 18:00 4/9/2018 133 80 75
5 10:30 4/10/2018 142 86 70
6 19:00 4/10/2018 141 84 68
7 10:00 4/11/2018 137 84 70
8 18:30 4/11/2018 139 83 72
9 10:00 4/12/2018 140 90 78
a
10 18:00 4/12/2018 160 100 69
11
.z
12
13
14 SYSTOLIC DESCRIPTION
15 0 Coma
o
16 50 Hypotension, Fainting
17 70 Hypotension, Weak
.c
18 90 Low Normal
19 110 Normal
20 130 High Normal
21 140 Mild, Stage 1
22
23
160
180
Moderate, Stage 2
Severe, Stage 3
rs
24 210 Very Severe, Stage 4
25
pe
26 DIASTOLIC
27 STATUS
a
e tp
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
.z
. co
rs
pe
pa
et
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
.z
. co
rs
pe
pa
et
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
.z
. co
rs
pe
pa
et
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
.z
. co
rs
pe
pa
et
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
.z
. co
rs
pe
pa
et
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
.z
. co
rs
pe
pa
et
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
XAM NO Q9A
HOLISTIC HEALTH SERVICES
za
BLOOD PRESSURE TRACKER
NAME N MOYO
BIRTH DATE 23-Mar-85
DATE 4/19/2020
o.
AGE 35
DATA ENTRY
c
TIME DATE SYSTOLIC DESCRIPTION DIASTOLIC STATUS HEART RATE NOTES
s.
10:00 4/9/2018 129 Normal 99 Stage 1 72 TAKE BP MEDICATION
18:00 4/9/2018 133 High Normal 80 Satisfactory 75 TAKE BP MEDICATION
10:30 4/10/2018 142 Mild, Stage 1 86 Satisfactory 70 CALL PHYSICIAN
er
19:00 4/10/2018 141 Mild, Stage 1 84 Satisfactory 68 CALL PHYSICIAN
10:00 4/11/2018 137 High Normal 84 Satisfactory 70 TAKE BP MEDICATION
18:30 4/11/2018 139 High Normal 83 Satisfactory 72 TAKE BP MEDICATION
10:00 4/12/2018 140 Mild, Stage 1 90 Stage 1 78 CALL PHYSICIAN
18:00 4/12/2018 160 Moderate, Stage 2 100 Stage 2 69 CALL PHYSICIAN
AVERAGE SYSTOLIC
HIGHEST HEART RATE
ap 88
78
SYSTOLIC DESCRIPTION
0 Coma
tp
50 Hypotension, Fainting
70 Hypotension, Weak
90 Low Normal
110 Normal
e
130 High Normal
140 Mild, Stage 1
tv
160 Moderate, Stage 2
180 Severe, Stage 3
210 Very Severe, Stage 4
DIASTOLIC 0 90 100 110 140
STATUS Satisfactory Stage 1 Stage 2 Stage 3 Stage 4
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
XAM NO Q9B
B D F H
HOLISTIC HEALTH SERVICES
za
2
5
N MOYO
6
31129
7
=TODAY()
=(B6-B5)/365
o.
8
1 0
DATE DESCRIPTION STATUS NOTES
1 1
c
1 2
1 3
43199 =VLOOKUP(C12,SYSTOLIC,2) =HLOOKUP(E12,DIASTOLIC,2) =IF(C12>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
1 4
43199 =VLOOKUP(C13,SYSTOLIC,2) =HLOOKUP(E13,DIASTOLIC,2) =IF(C13>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
43200 =VLOOKUP(C14,SYSTOLIC,2) =HLOOKUP(E14,DIASTOLIC,2) =IF(C14>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
s.
1 5
1 6
43200 =VLOOKUP(C15,SYSTOLIC,2) =HLOOKUP(E15,DIASTOLIC,2) =IF(C15>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
1 7
43201 =VLOOKUP(C16,SYSTOLIC,2) =HLOOKUP(E16,DIASTOLIC,2) =IF(C16>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
1 8
43201 =VLOOKUP(C17,SYSTOLIC,2) =HLOOKUP(E17,DIASTOLIC,2) =IF(C17>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
43202 =VLOOKUP(C18,SYSTOLIC,2) =HLOOKUP(E18,DIASTOLIC,2) =IF(C18>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
er
1 9
43202 =VLOOKUP(C19,SYSTOLIC,2) =HLOOKUP(E19,DIASTOLIC,2) =IF(C19>=140,"CALL PHYSICIAN","TAKE BP MEDICATION")
2 0
2 1
=AVERAGE(E12:E19)
=MAX(G12:G19)
ap
e tp
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
HOLISTIC HEALTH SERVICES
BLOOD PRESSURE READINGS IN THE MORNING
SYSTOLIC DIASTOLIC HEART RATE
180
160
160
142 141 139 140
133 137
140 129
a
120
mmHg/Beats
99 100
100 86 90
80 84 84 83
.z
80 10:00, 78
10:00, 72 18:00, 75 18:30, 72
10:30, 70 19:00, 68 10:00, 70 18:00, 69
60
o
40
20
.c
0
10:00 18:00 10:30 19:00 10:00 18:30 10:00 18:00
XAM NUMBER QUESTION 9C
rs
a pe
e tp
tv
Downloaded from TVET NCV Exam Papers
Downloaded from TVET lite
a
o .z
.c
rs
a pe
tp
e
tv
Downloaded from TVET NCV Exam Papers
