wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets

Total questions: 60

Worksheet time: 1hrs 12mins

Name
Class
Date
1.

What do all formulae or functions start with?

a)

=

b)

(

c)

-

d)

\

2.

What symbol should be used to perform an adding calculation?

a)

+

b)

-

c)

*

d)

/

3.

What symbol should be used to perform a subtraction calculation?

a)

-

b)

*

c)

+

d)

/

4.

What symbol should be used to perform a multiplying calculation?

a)

+

b)

-

c)

*

d)

/

5.

What symbol should be used to perform a division calculation?

a)

/

b)

-

c)

*

d)

+

6.

What software do we use to create spreadsheets?

a)

Slides

b)

Docs

c)

Jamboard

d)

Sheets

7.

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

a)

True

b)

False

8.

Worksheets appear as tabs at the bottom of the spreadsheet.

a)

True

b)

False

9.

What is the name of each "box" on a spreadsheet?

a)

Cell

b)

Box

c)

Rectangle

10.

What is the name for a line of cells that go across the spreadsheet?

a)

Row

b)

Column

c)

Field

d)

Record

11.

What is the name for a line of cells that go down the spreadsheet?

a)

Cell

b)

Row

c)

Field

d)

Record

e)

Column

12.

A cell reference is the specific location of the active cell (E.g. A1).

a)

True

b)

False

13.

What is the correct order for the parts that make up a Cell Reference?

a)

Letter then Number

b)

Number then Letter

14.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
15.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
16.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
17.
What is this icon?
a)
sheets
b)
docs
c)
classroom
d)
youtube
18.
What is this icon?
a)
classroom
b)
docs
c)
slides
d)
mail
19.
What is this icon?
a)
slides
b)
chrome
c)
drive
d)
classroom
20.
What is this icon?
a)
drive
b)
slides
c)
sheets
d)
classroom
21.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
22.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
23.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
24.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
25.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
26.

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

a)

format cell

b)

conditional formatting

c)

fill color

d)

magic cell

27.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
28.
A(n) _________ is a prewritten formula that is built into EXCEL. 
a)
function
b)
problem
c)
equation
d)
equal sign
29.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
30.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
31.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
32.

If we want a cell reference to stay the same when we copy it to other cells we need to use an (a)   cell reference.

33.

What is this typical Christmas sweet?

a)

Lollipop

b)

Gingerbread

c)

Nougat

d)

Pudding

34.

What is this vehicle that Santa Claus uses?

a)

Wagon

b)

Chariot

c)

Cart

d)

Sleigh

35.

Which of Santa's reindeer has a red nose?

a)

Comet

b)

Cupid

c)

Rudolph

d)

Blitzen

36.

Which of these is not one of Santa's reindeers?

a)

Dancer

b)

Zippy

c)

Rudolph

d)

Blitzen

37.

Complete this Christmas Carol "O Little Town of _____"

a)

Galilee

b)

Nazareth

c)

Bethlehem

d)

Athens

38.

In "How the Grinch Stole Christmas", what was the name of the Grinch's dog?

a)

Ray

b)

Grinchy

c)

Mike

d)

Max

39.

How do you say "Merry Christmas" in Brazil?

a)

Buon natale

b)

Felices pasquas

c)

Feliz navidad

d)

Boas festas

40.

Who is this?

a)

Santa

b)

Grinch

c)

Frosty Snowman

41.

What is this?

a)

Stocking

b)

Elf

c)

Christmas Tree

42.

What is this?

a)

Christmas Tree

b)

Bell

c)

Stocking

43.

Who is this?

a)

Santa

b)

Grinch

c)

Elf

44.
Christmas is a 
a)
month
b)
holiday
c)
year
45.
Christmas is in the month of 
a)
September
b)
June
c)
December
46.
To celebrate Chritmas, many people ____________ a Christmas tree.
a)
decorate
b)
dress
c)
wear
d)
put on
47.
How do you say Merry Christmas in Spanish?
a)
Noel
b)
Feliz Navidad
c)
Buenos Dias 
d)
Hola
48.
What is another name for Santa Claus?
a)
Kris Kringle
b)
Old Saint Nick
c)
Father Christmas
d)
All of these
49.
Things you do every year to celebrate Christmas are called...
a)
traditions
b)
chores
c)
games
50.
What are the socks called that children hang hoping to receive gifts?
a)
shoes
b)
stockings
c)
tights
51.
Where does Santa leave gifts?
a)
on the porch
b)
in the car
c)
under the Christmas tree
52.
Where does Santa live?
a)
North Pole
b)
Angier
c)
England
53.
Who delivers presents on Christmas Eve?
a)
Spongebob
b)
Santa Claus
c)
Pete the Cat
54.
Which of these names does NOT belong to one of Santa’s reindeer?
a)
Comet
b)
Prancer
c)
Blitzer
d)
Klaxon
55.

The day after Christmas is called:

a)

Good Friday

b)

Boxing Day

c)

Wise Man Day

d)

Christmas Monday

56.
What's the name of the period leading up to Christmas?
a)
Advent
b)
Shrovetide
c)
Lent
d)
Carnival
57.
How many reindeer does Santa have
a)
7
b)
8
c)
9
d)
10
58.
How many times does Santa check his 'naughty and nice' list?
a)
once
b)
twice
c)
three times
d)
ten times
59.
What is hung outside on the door?
a)
wreath
b)
laurel
c)
holly
d)
misetloe
60.
What plant with red berries is used for decorations?
a)
mistletoe
b)
wreath
c)
laurel
d)
holly