wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets

Total questions: 46

Worksheet time: 22mins

Name
Class
Date
1.

What is this a picture of? You are looking at the whole picture.

a)

cell

b)

table

c)

spreadsheet

2.

What is this a picture of? Look at what is selected.

a)

table

b)

cell

c)

column

3.

What is the cell address in this picture?

a)

D9

b)

D

c)

9

d)

DD

4.

What is this a picture of? Now you are looking where the data is.

a)

rows

b)

table

c)

column

5.

What is in this picture?

a)

row

b)

cell

c)

heading

6.

What is highlighted in this picture?

a)

formula bar

b)

column

c)

table

7.

What do we call horizontal line is in this picture?

a)

column

b)

cell

c)

row

8.

What is this a picture of?

a)

fx

b)

numbers

c)

money

d)

formula bar

9.

What row is in this picture?

a)

1

b)

2

c)

7

d)

B7

10.

What column is in this picture?

a)

A

b)

B

c)

C

d)

D

11.

What symbol do all formula start with in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

12.

What symbol do you use to add two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

13.

What symbol do you use to divide two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

14.

What symbol do you use to times two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

15.

What symbol do you use to subtract two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

16.

What is the value of the active cell?

a)

Y

b)

N

c)

Batman

d)

Superman

17.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

18.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

19.

True or False: all formula starts with =SUM

a)

True

b)

False

20.

What does the function =SUM() do?

a)

Adds up Cells

b)

Sells Cells

c)

Multiplies Cells

d)

Divides Cells

21.

What does the function =MAX() do?

a)

Finds the smallest number

b)

Finds the biggest number

c)

Finds the right number

d)

Finds the left number

22.

What does the function =MIN() do?

a)

Finds the biggest number

b)

Finds the smallest number

c)

Finds the correct number

d)

Finds the wrong number

23.

What kind of referencing uses $ to keep the cell the same?

a)

Relative

b)

Absolute

c)

Magic

d)

Heart

24.

What feature of a spreadsheet allows text to fill a cell up?

a)

Wrapped Text

b)

Format Text

c)

Merged Text

d)

Trapped Text

25.

What type of graph is this?

a)

Bar

b)

Line

c)

Pie

d)

Scatter

26.
Columns are identified using _______?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
27.
Rows are identified using ________?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
28.
In Excel, what do all formula begin with?
a)
!
b)
-
c)
+
d)
=
29.
Which formula is the correct for adding a column of values?
a)
SUM(E4:E10)
b)
=SUM(E4:E10)
c)
=AVG(E4:E10)
d)
=MAX(E4:E10)
30.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
31.
What do you call the box where a row and column intersect?
a)
Jail
b)
Gaol
c)
Cell
d)
Box
32.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
33.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
34.

What symbol should be used to perform an adding calculation?

a)

+

b)

-

c)

*

d)

/

35.

What symbol should be used to perform a subtraction calculation?

a)

-

b)

*

c)

+

d)

/

36.

What symbol should be used to perform a multiplying calculation?

a)

+

b)

-

c)

*

d)

/

37.

What symbol should be used to perform a division calculation?

a)

/

b)

-

c)

*

d)

+

38.

What software do we use to create spreadsheets?

a)

Word

b)

PowerPoint

c)

Sway

d)

Publisher

e)

Excel

39.

What are spreadsheets used for?

a)

To perform powerful calculations

b)

Make graphs and charts

c)

Analyse patterns in the data

d)

To store information and data

40.

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

a)

True

b)

False

41.

Worksheets appear as tabs at the bottom of the spreadsheet.

a)

True

b)

False

42.

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

a)

Cell

b)

Box

c)

Rectangle

43.

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

a)

Row

b)

Column

c)

Field

d)

Record

44.

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

a)

Cell

b)

Row

c)

Field

d)

Record

e)

Column

45.

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

a)

True

b)

False

46.

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

a)

Letter then Number

b)

Number then Letter

Similar Resources on Wayground

Movies

44 questions

Movies

quiz

Worksheet

•

2nd Grade - Professio...

ms excel 2010

50 questions

ms excel 2010

quiz

Worksheet

•

7th Grade

Y7 - Flowol & Flowcharts - EOU

50 questions

Y7 - Flowol & Flowcharts - EOU

quiz

Worksheet

•

7th Grade

St Michael's - Year 7 - Computer Usage

45 questions

St Michael's - Year 7 - Computer Usage

quiz

Worksheet

•

7th Grade

IT ja Rakenduste loomise full quiz

46 questions

IT ja Rakenduste loomise full quiz

quiz

Worksheet

•

7th - 9th Grade

POSTEST TCC-GC 2 - SGSI

50 questions

POSTEST TCC-GC 2 - SGSI

quiz

Worksheet

•

1st Grade - Professio...

MS Access class 3

50 questions

MS Access class 3

quiz

Worksheet

•

6th Grade

Introduction to Typing

45 questions

Introduction to Typing

quiz

Worksheet

•

7th - 12th Grade