wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

5th Six Weeks Game

Total questions: 25

Worksheet time: 14mins

Name
Class
Date
1.

Which of the following is a function?

a)

=Average

b)

(C4:C10)

c)

=

d)

()

2.

Which function gives the lowest number?

a)

Max

b)

Min

c)

Median

d)

Average

3.

Which function counts the cells containing numbers in a range of cells?

a)

=average

b)

=max

c)

=count

d)

=counta

4.

Which function removes extra spaces in a cell?

a)

Concatenate

b)

Trim

c)

Lower

d)

Right

5.

An identifying label assigned to a group of cells.

a)

Name Box

b)

Range Name

c)

Function

d)

Cell

6.

Sorting is when arrange data in order by column headings.

a)

True

b)

False

7.

A command that displays the formulas in a worksheet so you can check them.

a)

Scale

b)

Show Formulas

c)

Orientation

d)

Filter

8.

To hide non-matching rows in a table or list of data according to criteria you specify.

a)

Sort

b)

Filter

c)

Scale

d)

Show Formulas

9.

Total rows are placed below the table.

a)

True

b)

False

10.

The fill handle is used to select cells not to copy.

a)

True

b)

False

11.

To center a label across several columns, use the Merge & Center command.

a)

True

b)

False

12.

You CANNOT scale a page to print only on one page.

a)

True

b)

False

13.

Select ALL the ones you need to create a sum formula.

a)

=

b)

(A6:A12)

c)

add

d)

sum

e)

+

14.

Which formula subtracts two cells?

a)

=C4=D4

b)

C4-D4

c)

=C4-D4

d)

=C4/D4

15.

Which function capitalizes all the letter in the cell?

a)

Trim

b)

Upper

c)

Concatenate

d)

Lower

16.

Which function finds the middle number?

a)

Max

b)

Min

c)

Mid

d)

Average

17.

What is a document with more than one worksheet called?

a)

Worksheets

b)

Workbook

c)

Spreadsheet

d)

Workbooks

18.

There is only one way to autofit a column.

a)

True

b)

False

19.

What is missing in this formula?

Sum(D4:D10)

(a)  

20.

Spaces are allowed in formulas.

a)

True

b)

False

21.

Which is the operator to multiply?

a)

*

b)

/

c)

+

d)

-

22.

What function do you use to merge information from different cells? (John D Joe)

a)

Trim

b)

Concatenate

c)

Lower

d)

Left

23.

How much typing time should you have at the end of a normal school week?

(a)  

24.

What type of document are we working on?

a)

Word Processing

b)

Spreadsheet

c)

Database

d)

Presentation

25.

What program are we using to create a spreadsheet?

a)

Excel

b)

Word

c)

PowerPoint

d)

Access