Free Printable Grade 9 Information Technology Mock EOT Exam

1.

The purpose of a spreadsheet is:

a)

To create financial plan

b)

To store formula only

c)

To store function Only

d)

To store formula and function Only

2.

A cell is____________

a)

The smallest structural and functional unit of an organism

b)

Currently selected cell in a spreadsheet

c)

a small room in which a prisoner is locked up or in which a monk

d)

The intersection between a row and a column

3.

A function is____________:

a)

A predefined methods use to perform a specific task

b)

An application package.

c)

Used to perform operations on values in a spreadsheet

d)

A method uses to enter, view and print information/data

4.

___________is a method used to perform operations on values in a spreadsheet.

a)

Active cells

b)

Range

c)

Formula

d)

functions

5.

__________ are a group of cells beside each other.

a)

Functions

b)

Formulae

c)

Range

d)

Parenthesis

6.

To find the highest value in a series or range, we use ……….

a)

=MAX (first cell: Last cell)

b)

=MIN (first cell: Last cell)

c)

=SUM (first cell: Last cell)

d)

=MAX (last cell: first cell)

7.

To find the lowest value in a series or range, we use………

a)

=SUM (first cell: last cell)

b)

=MIN (last cell: first cell)

c)

=MIN (first cell: last cell)

d)

=MAX (first cell: last cell)

8.

Which option is NOT an example of a formula is…….

a)

=B2 + B3

b)

B2: B3

c)

=B2* B3

d)

=B2*B3

9.

Which of the options below is NOT an example of a function ______

a)

=COUNTA(G3:G10)

b)

=COUNT (G3: G10)

c)

=SUM (G3:G10)

d)

=COUNTS(3G: 10G)

10.

Which of the following is a correct cell address?

a)

2B

b)

B2

c)

B

d)

2

11.

Rows are identified by_______________

a)

Letters

b)

Numbers

c)

Letters and number

d)

None of the above

12.

Columns are identified by____________

a)

Letters

b)

Numbers

c)

Letters and number

d)

None of the above

13.

Range is a____________

a)

Group of Letters on a spreadsheet

b)

Numbers on a spreadsheet

c)

Letters and number on a spreadsheet

d)

Group of cells beside each other

14.

Use this table to answer the questions that follows:

With the use of the spreadsheet, identify a column from the options below:

a)

Blue

b)

Green

c)

Black

d)

All the above

15.

With the use of the spreadsheet, from the options below identify a row:

a)

Blue

b)

Green

c)

Black

d)

All the above

16.

Which formula below is the correct answer to the total for Marvin Reid?

a)

=SUM (B2+C2)

b)

SUM (B4+C2)

c)

=(B2+C2)

d)

B2+C2

17.

Which function below is the correct answer to the total for Othniel Ankle?

a)

=SUM (B4:C4)

b)

SUM (B4+C2)

c)

=(B4+C4)

d)

B2+C2

18.

___________ is an example of value based on the spreadsheet above:

a)

B2

b)

Marvin Reid

c)

70

d)

All the above

19.

Identify the cell address for Celine Richards from the option below:

a)

B3

b)

2B

c)

A3

d)

3A

20.

Write the name of the section in the space below:

4 lines

21.

Use formula to:

Calculate the “Total Price” column for each item in the spreadsheet on the lines below

4 lines

22.

With the use of the spreadsheet, use appropriate formula to:

Calculate the total for “Total Price” column ____________________

4 lines

23.

With the use of the spreadsheet, use appropriate functions to find the following below using the “TOTAL PRICE” column:

Highest values____________________

4 lines

24.

With the use of the spreadsheet, write the function to calculate the lowest value using the QUANTITY column

4 lines

25.

With the use of the spreadsheet, write the function to calculate the Average using the TOTAL PRICE column

4 lines

26.

With the use of the spreadsheet, write the function to calculate the number of items in the spreadsheet

4 lines

27.

With the use of the spreadsheet, Identify and state the cell address containing the quantity

4 lines

28.

With the use of the spreadsheet, Identify and state the range for price per items and total price

4 lines

29.

With the use of the spreadsheet, Identify the shaded section in the spreadsheet

4 lines

30.

With the use of the spreadsheet, Identify and state two columns headings in the spreadsheet

4 lines

31.

With the use of the spreadsheet, Identify and state two columns headings in the spreadsheet

4 lines

32.

A spreadsheet is defined as......

a)

Currently selected cell in a spreadsheet

b)

Used to perform operations on values in a spreadsheet

c)

The intersection between a row and a column

d)

An application package that enables you to carry out numerical work for financials

Grade 9 Information Technology Mock EOT Exam

Total questions: 32

Worksheet time: 17mins

Similar Resources on Wayground