EXPERT USER PROFICIENCY COURSE (EUP)
FEBRUARY 2022 EXAMINATIONS SERIES
EUP 003: MS EXCEL: SPREADSHET.
Instructions
1. Write your INDEX NUMBER in the space provided on the question paper
2. Answer all questions in Section A.
3. Answer all the theory questions in the spaces provided on the question paper
4. Time allowed is: 30 minutes.
INDEX NUMBER: ___________________________________________________________________
SECTION A: THEORY - COMPULSORY (25MARKS)
QUESTION ONE (25 MKS)
a) Explain one function of the paste link feature as used in spreadsheet 2 marks
………………………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………………………
b) Distinguish between a function and a formula. 4 marks
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………
c) With an aid of example, explain absolute cell referencing as used in worksheets 4 marks
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………..
, d) Jack realized the following errors displayed in a worksheet he was working on
i. #####
ii. #N/A
Identify the possible cause for each of the errors 4 marks
…………………………………………………………………………………………………………………….……………………………..
……………………………………………………………………………………………………………………….……………………………
………………………………………………………………………………………………………………………………………….…………
e) (i) What is page orientation (2marks)
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
(ii) Name 2 types of page orientation (2 marks)
……………………………………………………………………………………………………………………………………………………
…………………………………………………………………………………………………………………………………………………..
f) Describe 2 types of charts used in a spreadsheet (2 marks)
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
FEBRUARY 2022 EXAMINATIONS SERIES
EUP 003: MS EXCEL: SPREADSHET.
Instructions
1. Write your INDEX NUMBER in the space provided on the question paper
2. Answer all questions in Section A.
3. Answer all the theory questions in the spaces provided on the question paper
4. Time allowed is: 30 minutes.
INDEX NUMBER: ___________________________________________________________________
SECTION A: THEORY - COMPULSORY (25MARKS)
QUESTION ONE (25 MKS)
a) Explain one function of the paste link feature as used in spreadsheet 2 marks
………………………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………………………
b) Distinguish between a function and a formula. 4 marks
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………
c) With an aid of example, explain absolute cell referencing as used in worksheets 4 marks
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………
………………………………………………………………………………………………………………………………………………………………..
, d) Jack realized the following errors displayed in a worksheet he was working on
i. #####
ii. #N/A
Identify the possible cause for each of the errors 4 marks
…………………………………………………………………………………………………………………….……………………………..
……………………………………………………………………………………………………………………….……………………………
………………………………………………………………………………………………………………………………………….…………
e) (i) What is page orientation (2marks)
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
(ii) Name 2 types of page orientation (2 marks)
……………………………………………………………………………………………………………………………………………………
…………………………………………………………………………………………………………………………………………………..
f) Describe 2 types of charts used in a spreadsheet (2 marks)
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
……………………………………………………………………………………………………………………………………………………
