wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets and Formula

Total questions: 17

Worksheet time: 14mins

Name
Class
Date
1.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
2.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
3.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
4.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

5.

Mr. Esker is looking over his quiz data again in his spreadsheet. He wanted to know how many students received an 80% on his latest quiz. In his spreadsheet he would use the ___________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

6.

Mr. Esker wanted to see how the class did as a whole on the most recent test. Using spreadsheets he used the ______________ function to calculate the classes score as a whole.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

7.

Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

8.
The COUNT function is used to?
a)
Add a range
b)
Return the number of cells in a range.
c)
Sum a Column
d)
Choose the List
9.
COUNTA returns the number of cells in a range that contain?
a)
the date
b)
the name
c)
any value/label
d)
the month
10.
COUNTIF returns the number of cells that meet a condition set forth in a ________________.
a)
Condition
b)
Criteria
c)
Formula
d)
Date
11.

A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________

a)

COLUMN

b)

ROW

c)

RANGE

d)

FORMULA

12.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
13.

A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.

a)

FUNCTION

b)

FORMULA

c)

CELL

d)

ROW

14.
  Which function will result in the total number of entries in the cell range B5 to B14?   
a)
  Count 
b)
 Max
c)
  Min
d)
  Sum
15.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
16.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
17.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific