PART A: MULTIPLE CHOICE QUESTIONS QUESTION 1 TO 30

For each question, choose the correct answer and write A, B, C or D in the space provided on the
ANSWER SHEET

Question 1:
If a user wanted to consolidate data from cell A2 in worksheets Sales, HR and Marketing, and have the data
consolidated in cell A3 of the worksheet Consolidation, what would the user have to type?

A. = SUM (Sales + Marketing:A2) B. = SUM(Sales + Marking.A2)

C. = SUM (Sales + Marking!A2) D. = SUM(Sales!Marking!A2)

Question 2:
In order to type the symbol $(dollar sign), which of this key will you press?

A. Ctrl + S B. Alt + 4 C. Ctrl +  D. Shift + 4

Question 3:
The term used in Microsoft Office to refer to a combination of colors, fonts and effects that project a certain feel
or tone in a document is

A. theme B. style C. one D. impression

Question 4:
The intersection of a row and a column in a Microsoft Excel document can be defined as a/an

A. Field B. Entry C. Cell D. Entity

Question 5:

1|Page
The Microsoft Excel interface contains a variety of components to accomplish specific tasks.
Figure 2 below depicts one of the components used by Microsoft Excel.

What is the name of the Microsoft Excel component depicted on the figure above?

A. Cell Dialog Box B. Cell Name Box C. Formula bar D. Active

Cell

Question 6:
The Microsoft Excel interface contains a variety of components to accomplish specific tasks. The diagram
below depicts one of the components used by Microsoft Excel.

What is the purpose of the Microsoft Excel component circled

on the figure shown?

A. Minimize the Excel application B. Minimize the current file.

C. Close the Excel application D. Close the current file.

Question 7:
Excel worksheets consist of rows and columns that are labeled with
A. Alphabets and numbers B. Numbers and alphabets
C. Numbers and numbers D. Alphabets and alphabets

Question 8:

2|Page
In a workbook, Excel creates ____________________ sheets by default.

A. 1 B. 2 C. 3 D. 4

Question 9:
Which of the following is not applicable in desktop publishing?
A. Report Writing B. Book Keeping
C. Presentation D. Creating Information Leaflets

Question 10:
Which of the following is an Excel file?

A. Trees.xlsx B. Banana.docx C. Fanta.accdb D. Fruits.pptx

Question 11:
The Formula =sum(A1:A5) is used to calculate

A. Percentage B. Average C. Total D. Maximum

Question 12:
Macro recorded in spreadsheet software is

A. Random bits of information B. Order set of instruction

C. Unknown computer language D. Set of function

Question 13:

Which of the following represent a range of data in an Excel database?

A. C2_C12 B. C2.C12 C. C;C12 D. C2:C12

Question 14:
Which of the following alternative below is an example of search engine?

3|Page
A. Amazon B. bip C. WhatsApp D. Twitter

Question 15:
What does the letter X represent as shown in this MS Excel function? =CountIF(X, Y)
A. Criteria B. Value C. Output D. Range

Question 16:
How do you save two version of the same file?

A. Save and Save in B. Save in and Save as C. Save and Save as D. None of the
above

Question 17:
What would be an appropriate description of template in a word processor?
A. Pre designed page layout B. Blank forms of word processing

C. Original letterhead design D. Blank pages for typing

Question 18:
Digital data or computer reads data as Binary which is represented by
A. ABCD B. Tens and Thousands C. Greek letters D. Zeros and Ones

Question 19:
Which of the following objects can be found in a database?
A. Tables, Reports, Queries and Forms B. Forms, Queries, Field, Data type

C. Title Bar, Status Bar, Forms Queries D. Table, Data type, Forms, Field

Question 20:
Which of the following is the correct use of formula in MS excel?
A. A1+B1 B. =1A+1B C. A+B D. =A1+B1

Question 21:
What does the acronym HTML mean?

4|Page
A. Higher Text Marking Language B. Hypertext Markup Language

C. High text making Language D. Hypertext markup linking

Question 22:
Below is a set of data in a MS excel worksheet

Gr. 9B wants to calculate the total weight by using the information

above. They add weight of potatoes, onion and then multiplied by 2.

Which of the following formula would give them the correct result?

A. =C2+C4 x 2 B. =C4+C2*2 C. =(C2+C4)*2 D.

=(C2:C4)*2

Question 23:
Which of the following icons is used to clear the formatting styles of the text?

A. B. C. D.

Question 24:
Which of the following icons below is used to make your text appear in superscript?

A. B. C. D.

Question 25:
Which of the icons below is used for pasting?

A. B. C. D.

Question 26:
A red wavy lines displayed on the text when you have a

5|Page
A. Spelling error B. Grammatical error C. Typing error D. Systematic error

Question 27:
Which keyboard key allows you to start a new line?

A. Enter B.  C. Tab D. Ctrl 

Question 28:
Which of the following is not applicable in desktop publishing?
A. Report Writing B. Book Keeping
C. Presentation D. Creating Information Leaflets

Question 29:
When the text is cut or copied, it is stored in the ___________.

A. recycle bin B. clip board C. clip art D. rubbish bin

Question 30:
Which statement below best describes a backup file?
A. A copy of that file stored on another disk

B. File that is left for processing

C. Short cut file that is deleted on another disk

D. Folder used for input processing

PART B: SHORT ANSWERS QUESTIONS 31 TO QUESTION 60

6|Page
For each question, work out the answer and write the answer in the space provided on the ANSWER
SHEET.

Question 31:
What is the general name given to the diagram below?

_____________________________ (1 mark)

Question 32:
What is the correct name of the bolded rectangle in the excel table below? (1 mark)
____________________________________

Question 33:
The figure on the right represents _______________________________ (2 marks)

Question 34:
Give one example of an excel file. ___________________________________ (1 mark)

Question 35:
The formula =sum(A1:A5) is used to calculate _________________________ (2 mark)

Question 36:
Write down the steps for printing a document. (2 mark)
_________________________________________________________________________________________
Question 37:
The intersection of a row and column in a spreadsheet is referred to as __________________________ (2
marks)

7|Page
Question 38:
The process of combining static information in a publication together with variable information in a data source
to create one merged publication is called ___________________________ (1 mark)

Question 39:
The Icon labeled X in figure below can be found at the bottom of MS Excel worksheet window

What does this icon allow you to do? ________________________________________________ (2 marks)

Question 40:
You are asked to insert the kina sign “K” against a column of values containing kina amount in new Microsoft
word spreadsheet. The cell format category that you will use to set up is _________________________ (2
marks)

Question 41:
Give one valid example of IF Function in Microsoft excel.

____________________________________________ (2 marks)

Question 42:
What is the name of the bar indicated by the arrow on the figure below?

______________________________ (1 mark)

Question 43:
When entering formulas in Microsoft Excel worksheet, what symbol will we always start with ________(2
marks?)
8|Page
Question 44:
The diagram below is a table style. Under what command will you locate this diagram? (2 marks)

____________________

Question 45:
The diagram is representing a _________________________ (2 marks)

Question 46:
Under Enumeration, there are 5 different types of cases. Name only three. (3
marks)

1: ___________________________________ 2: _______________________ 3. ______________________

Question 47:
What are the four (4) most usable punctuations in workbook or worksheets? (4
marks)

A. _________________ B. _______________ C.___________________ D. __________________

Question 48: (2
marks)
Using Range name to write the simplified/obscure formula and descriptive name for the information given
below

D1. Latest Sales. 5020 D3. Reserve.564

9|Page
For Question 49, 50 and 51 refer to the diagram below

Question 49:
What is the title of the spreadsheet shown above? _____________________________________ (2 marks)

Question 50:
In Ms Excel diagram above, what are the names given to the Vertical lines and Horizontal Lines? (2 marks)

(A)Vertical lines.______________________________ (B) Horizontal lines

_______________________________

Question 51:
In a spreadsheet, a student entered a value of 200 in cell A6 and 100 in cell A7. The two cells were formatted to
currency.
What would be the result if the function =sum(A6:A7) in written? ____________________________ (2 marks)

Question 52:
The following table shows data in an MS Excel database (2 marks)
Write the formula to calculate the total between
Januarys to April for North (Use cell reference
only)

______________________________________

10 | P a g e
For questions 53, 54 and 55 refer to the diagram below

Question 53:
In cell F4, the school inspector enters a formula using the cell reference as =sum(B4:E4) to calculate the total
enrollments of a particular school.
What is the name of the school? _______________________________________ (2 mark)

Question 54:
Write down a simple formula to calculate the total enrollment for Upper secondary (Grade 11 and Grade 12) for
Gerehu School. (Use cell reference) _______________________________________ (2 marks)

Question 55:
The school inspector enter the formula =C8 in cell F8 to bring up the enrollment data of particular grade in
Tokorara school.
For what grade, the school inspector is calculating the enrollment data? _________________________ (2
marks)

Question 56:
Write the name for the following icons (2 marks)

1. 2.

11 | P a g e
Question 57:
Below is an image of the most frequently used command. What is the correct name? (2
marks)

________________________________________________________

Question 58:
What keyboard key or name the keyboard key did we used to delete words or letters that we type? _____ (2
mark)

Question 59:
Mouse has left, right and scroll buttons. To cut, copy or paste, which side should you click? ___________ (2
mark)

For Question 60 refer to the information below

Question 60:

Identify which command should be used to complete the task below

CUT COPY PASTE DELETE

1. Create the same text in another document typing the text again. ___________________________ (2 marks)

2. Command that is used together with Cut and Copy. ____________________________________ (2 marks)

END OF EXAMINATION

12 | P a g e