wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

Which of the following is used for a multiplication sign?

a)

X

b)

=

c)

#

d)

*

2.

Which of the following would be a reason you could use a spreadsheet?

a)

To make a presentation

b)

To organize a list of students

c)

To write an essay

d)

To type an email

3.

Which of the following would be a reason you could use a spreadsheet?

a)

To update your operating system.

b)

To average your grade in a class.

c)

To build a resume'

d)

To write a research paper.

4.

How do you select the entire spreadsheet?

a)

click on CTRL + A

b)

type "choose all"

c)

click the blank box between the rows and columns

d)

You cannot select the entire spreadsheet.

5.

What is the function that allows you to put data alphabetically?

a)

sort function

b)

junction function

c)

summation function

d)

sheet function

6.

Why do people use spreadsheets?

a)

To make presentations.

b)

To build a resume'.

c)

To write an essay.

d)

To sort information and calculate numbers.

7.

A (a)   is a vertical set of cells named by using a letter.

8.

To expand a column, you must ________.

a)

Double click between the column letters.

b)

Double click between the row number.

c)

Use a 'count if' formula

d)

Put in a command.

9.

A (a)   is a horizontal set of cells named using numbers.

10.

Which of the following do you use to begin a formula?

a)

=

b)

X

c)

*

d)

+

11.

How do you select an entire row?

a)

Press on the letter and number of the cell together.

b)

Click your mouse on the row number only.

c)

Click the cursor on your cell and drag it to the last cell.

d)

Double click your mouse on the cell.

12.

Which of the following is NOT a file extension for a spreadsheet?

a)

.doc

b)

.xls

c)

.numbers

d)

.csv

13.

Which of the following would be an accurate Average function?

a)

=average(B3:B5)

b)

average(B3:B5)

c)

=average(B3-B5)

d)

=average(B3,B4,B5)

14.

A combination of a column letter and a row number is called the ________.

a)

cell address

b)

column indicator

c)

spreadhsheet

d)

new sheet

15.

What is the difference between a formula and a function?

a)

A formula you create, a function is already created.

b)

A formula is already created, a function you create.

c)

They are the same thing.