Grade 9 Information Technology Mock EOT Exam

The purpose of a spreadsheet is:

• To create financial plan

• To store formula only

• To store function Only

• To store formula and function Only

A cell is____________

• The smallest structural and functional unit of an organism

• Currently selected cell in a spreadsheet

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

• The intersection between a row and a column

A function is____________:

• A predefined methods use to perform a specific task

• An application package.

• Used to perform operations on values in a spreadsheet

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

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

• Active cells

• Range

• Formula

• functions

__________ are a group of cells beside each other.

• Functions

• Formulae

• Range

• Parenthesis

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

• =MAX (first cell: Last cell)

• =MIN (first cell: Last cell)

• =SUM (first cell: Last cell)

• =MAX (last cell: first cell)

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

• =SUM (first cell: last cell)

• =MIN (last cell: first cell)

• =MIN (first cell: last cell)

• =MAX (first cell: last cell)

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

• =B2 + B3

• B2: B3

• =B2* B3

• =B2*B3

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

•        =COUNTA(G3:G10)

• =COUNT (G3: G10)

• =SUM (G3:G10)

• =COUNTS(3G: 10G)

Which of the following is a correct cell address?

• 2B

• B2

• B

•   2