wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets Quiz

Total questions: 12

Worksheet time: 12mins

Name
Class
Date
1.

Spreadsheets are organized by _____________

a)

cells and rows

b)

columns and rows

c)

columns and rolls

d)

cells and columns

2.

These rectangular areas are called _____.

a)

cells

b)

seals

c)

columns

d)

rows

e)

sheets

3.

Every cell has its own, unique address. How does a cell get its name?

a)

by its row and sheet

b)

by its column and cell

c)

by its column and row

d)

by its row and formula

4.

Which one is NOT a correct formula to total the cells?

a)

=sum(b2--b5)

b)

=sum(b2:b5)

c)

=b2+b3+b4+b5

d)

=sum(b2+b3+b4+b5)

5.

When we refer to a cell "address" rather than the value IN the cell, it is called ____.

a)

value referencing

b)

value naming

c)

cell recalling

d)

cell referencing

6.

What is the advantage of using "cell referencing" rather than the value IN the cell?

4 lines
7.

What is the correct formula for figuring the PRICE of gas?

a)

MPG / Total miles * Price of gas

b)

Price of gas / Total miles * MPG

c)

Total miles / MPG * Price of gas

d)

Total miles * MPG / Price of gas

8.

When I want to combine several cells into ONE, larger cell, it is called ____.

a)

mirroring

b)

merging

c)

combining

d)

connecting

9.

If I wanted to merge cells, I would highlight them and then click ____.

a)

File

b)

Edit

c)

View

d)

Insert

e)

Format

10.

What should I tap to "finish" a formula?

a)

Enter

b)

Finish

c)

Done

d)

Space

11.

What is the correct way to link two cells on different sheets?

a)

=cellnamesheetname!

b)

=sheetnamecellname

c)

=sheetname!cellname

d)

=sheetnamecellname!

12.

Which class does Mrs. McDonald love teaching the most???

a)

yearbook

b)

TECH :) :)

c)

theology