wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

M1 Final Test 2nd Term 2024

Total questions: 21

Worksheet time: 33mins

Name
Class
Date
1.

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

a)

=

b)

#

c)

$

d)

*

2.

In a worksheet, the vertical spaces with the headings A, B, C and so on is called?

a)

Cell

b)

Column

c)

Letters

d)

Data

3.

In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on is called?

a)

Column

b)

Label

c)

Row

d)

Cell Address

4.

The function that lets you add up a range of cells or values

a)

AVERAGE

b)

MIN

c)

MAX

d)

SUM

5.

The function COUNT is specific for _________________

a)

Counting Numbers

b)

Counting Text

c)

Counting Cells

d)

Counting Tables

6.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

formula bar

c)

help bar

d)

window bar

7.

Which function in Excel checks whether a condition is true or not ?

a)

SUM

b)

COUNT

c)

IF

d)

AVERAGE

8.

In Excel, Columns are labelled as ___

a)

A1, A2, A3, etc

b)

1,2,3, etc

c)

B1, B2, B3, etc

d)

A, B, C, etc

9.

In Excel, which one denoted a call range from B1 through E5.

a)

B1:E5

b)

B1,E5

c)

B1;E5

d)

B1/E5

10.

Formula in Excel start with......

a)

#

b)

=

c)

%

d)

$

11.

This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.

a)

COUNTBLANK

b)

COUNTA

c)

COUNT

d)

COUNTIF

12.

This function tests a condition.

If the condition is met it is considered to be TRUE.

If the condition is not met it is considered as FALSE.

Depending upon the result, one of two actions will be carried out.

a)

COUNTIF

b)

SUMIF

c)

DATEIF

d)

IF

13.

A program using a table comprising of rows, columns and cells.

a)

MS Excel

b)

MS PowerPoint

c)

MS Word

d)

MS Outlook

14.

The first cell in a worksheet is what?

a)

B1

b)

A1

c)

1A

d)

1B

15.

What is the name of the cell that is colored blue?

a)

A

b)

B

c)

B2

d)

2B

16.

In Excel, rows are identified by this

a)

Letters

b)

Alphanumeric

c)

Question Mark

d)

Numbers

17.

Absolute cells reference looks like this....

a)

$A$1

b)

1$A$

c)

A#1#

d)

A$$1$$

18.

Which symbol is being added for a relative cell to become an absolute cell?

a)

-

b)

=

c)

#

d)

$

19.

Which of the following is not an arithmetic operator?

a)

+

b)

-

c)

]

d)

*

20.

What button on your keyboard will you press to change a regular cell into an Absolute Cell?

a)

F1

b)

F2

c)

F3

d)

F4

21.

Please write what will be the formula on cell B4 and the answer when you copy A4 which is an absolute formula.

4 lines