wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Unit Review

Total questions: 120

Worksheet time: 1hrs 23mins

Name
Class
Date
1.

What is a spreadsheet?

a)

a box in which you can enter a single piece of data.

b)

vertical series of cells in a chart, table, or spreadsheet. They go up and down on the spreadsheet.

c)

an electronic document in which data is arranged in the rows and columns

2.

What is a box that you enter in data on a spreadsheet called?

a)

row

b)

cell

c)

column

3.

What is the formula bar?

a)

The cells that go up and down on a spreadsheet.

b)

The cells that go left to right on a spreadsheet.

c)

The tool that lets you do math with the data on the spreadsheet.

4.

What are rows on a spreadsheet?

a)

cells that go left to right on a spreadsheet.

b)

cells that go up and down on a spreadsheet.

c)

names of the data on a spreadsheet.

5.

What are columns on a spreadsheet?

a)

series of rows and columns in a spreadsheet that contains related data.

b)

cells that go up and down on a spreadsheet.

c)

cells that don't go anywhere.

6.

What is a table on a spreadsheet?

a)

cells that go left to right.

b)

The names of the types of data that is typed in the column or spreadsheet.

c)

series of rows and columns in a spreadsheet that contains related data.

7.

What is the name of this cell?

a)

D

b)

9

c)

D9

8.

What is the name of this row?

a)

Row A

b)

Row 5

c)

Row A5

9.

What are the names of the selected columns?

a)

C, D, E, F

b)

A,B,C,D

c)

ABC123

d)

A,B,C,D,E,F,G,H

10.

How do you name a cell from a spreadsheet?

a)

Column first, then row

b)

Row first, then column

c)

By reading it.

11.
The Google application used to enter data, create and calculate formulas and charts.
a)
Google Docs
b)
Google Forms
c)
Google Slides
d)
Google Sheets
12.
_________________ are horizontal and identified by a number.
a)
Cell
b)
Column
c)
Row
d)
Border
13.
______________ are vertical and identified by a letter.
a)
Cell
b)
Column
c)
Row
d)
Border
14.
The intersection of a column and a row is called:
a)
Cell
b)
Column 
c)
Row
d)
Border
15.

The three types of horizontal alignments are: left, center and

a)

Up

b)

Down

c)

Middle

d)

Right

16.
The same formatting styles like Bold, Italic and Underline can also be found in Google sheets as it was in Google Docs.
a)
True
b)
False
17.

This cursor symbol in the picture represents _________________________.

a)

Autocomplete

b)

Widening a column

c)

Autofill

d)

Merge

18.

The toolbar icon in this picture represents:

a)

Autofill

b)

Merge

c)

Text Wrapping

d)

Text Direction

19.

The toolbar icon in this picture represents:

a)

Text Wrap

b)

Merge

c)

Text direction

d)

Autofill

20.

Sum, Average, Max, Min and Count are called ______________ formulas.

a)

Function

b)

Logical

c)

Statistical

d)

Financial

21.
To start a formula you need to use what symbol?
a)
Plus sign
b)
Percent sign
c)
Equal sign
d)
Just type the formula
22.
The menu option to add an image is called?
a)
File
b)
View
c)
Insert
d)
Tools
23.
A to Z sort is called:
a)
Ascending order
b)
Descending order
24.
Z to A sort is called?
a)
Ascending Order
b)
Descending order
25.

This picture represents this type of cell reference?

a)

Absolute

b)

Relative

26.

The toolbar icon that this picture represents is:

a)

Increase and decrease decimals

b)

Increase and decrease indents

c)

Increase and decrease margins

d)

None are correct.

27.
This picture represents:
a)
Increase and decrease width
b)
Increase and decrease height
c)
Increase and decrease margins
d)
Undo and Redo
28.
To add a column between existing columns you will need to click on:
a)
File Menu
b)
Insert Menu
c)
Edit Menu
d)
Data menu
29.

The cells B2 through B45 would be classified as:

a)

Row

b)

Column

c)

Entry

d)

Cell Address

30.

To find the total of a cell range, which function would you use?

a)

SUM

b)

Average

c)

MIN

d)

MAX

31.

Which term refers to the column letter and row number in a spreadsheet?

a)

Cell Address

b)

Cell Content

c)

Formula Bar

d)

Chart Title

32.

Which formula will give you the lowest number in a cell range?

a)

SUM

b)

MIN

c)

MAX

d)

AVG

33.

The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?

a)

=MAX(A1:A6)

b)

=MIN(A1:A6)

c)

=AVERAGE(A1:A6)

d)

=SUM(A1:A6)

34.

Which of the following is the correct way to write a function in a spreadsheet?

a)

=SUM(A1-A5)

b)

=SUM A1+A5

c)

SUM (A1:A5)=

d)

=SUM(A1:A5)

35.

All of the information in the cell range A4 through K4 would be displayed in what?

a)

Row

b)

Column

c)

Entry

d)

Cell Address

36.

The name for more than one spreadsheet in the same file is a....

a)

doc

b)

paper

c)

workbook

d)

tablet

37.
A corporation lists all of its sales information for one product in a cell range of A1 to L1. Where is this information?
a)
column
b)
row
c)
cell address
d)
entry
38.
Which function should be used to find the highest value in a range of cells?
a)
max
b)
sum
c)
min
d)
avg
39.
Which is an example of a cell reference?
a)
A1
b)
CD
c)
7D
d)
77
40.
Columns can be...
a)
inserted
b)
copied
c)
deleted
d)
all of the choices
41.
Which chart will best represent a percentage of expenses for a company's total budget?
a)
pie
b)
column
c)
scatter
d)
line
42.

Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?
a)
X axis
b)
Y axis 
c)
Legend
d)
Chart Title
43.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
44.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
45.
A graphical representation of numeric data.
a)
chart
b)
function
c)
average
d)
legend
46.
An application or file that organizes data in rows and columns and enables complex mathematical calculations is called a(n) ________________.
a)
form
b)
document
c)
spreadsheet
d)
drawing
47.
A group of continuous cells in a spreadsheet.
a)
formula
b)
range
c)
graph 
d)
function
48.
A mathematical equation.
a)
formula
b)
function
c)
chart
d)
axis
49.

Which TWO software programs are used for making spreadsheets?

a)

Microsoft Excel

b)

Google Docs

c)

Google Sheets

d)

Microsoft Power Point

e)

Google Slides

50.

The letters A, B, and C represent...

a)

Columns in the table

b)

Rows in the table

51.

The numbers 1, 2, 3 represent...

a)

Columns in the table

b)

Rows in the table

52.

When you sort data...

a)

You change the values of the cells.

b)

You choose how the data will be displayed.

c)

You remove values that don't fit in your data set.

53.

How are cells named in a spreadsheet?

a)

Row Column ex. 7F

b)

Column Row ex. F7

c)

Row-Column ex. 7-F

d)

Column-Row ex. F-7

54.

Which icon is used to merge cells?

a)
b)
c)
d)
55.

Which icon is used to choose how the text is displayed (text wrap)?

a)
b)
c)
d)
56.

What is cell referencing?

a)

Referring to cells in a formula

b)

Adding titles to cells

c)

Naming a group of cells

57.
Which one of the following does NOT describe columns?
a)
vertically in spreadsheet
b)
labeled by numbers
c)
up and down in spreadsheet 
d)
labeled by letters
58.
A formula in a spreadsheet ... 
a)
always begins with an =
b)
does a calculation
c)
shows up in the formula bar
d)
all of these
59.

Which one below is NOT one of the five most-common Functions from the AutoSum Command?

a)

SUM

b)

IF

c)

MIN

d)

MAX

e)

AVERAGE

60.
A ______________ is an advanced/sophisticated formula.
a)
row
b)
range
c)
function
d)
column
61.
If B3:J8 is given, what is it referring to?
a)
only cells B3 and J8
b)
only cell J8
c)
range of cells B3 through J8
d)
only cell B3
62.
A function in a spreadsheet ... 
a)
can SUM cells
b)
can find the MAX in a range of cells
c)
can be used by clicking on the AutoSum (looks like E)
d)
all of these
63.
At the bottom of the worksheet window which displays the name of the worksheet.
a)
row
b)
cell
c)
sheet tab
d)
worksheet
64.
The location of the equation that calculates a new value from values currently in a worksheet. 
a)
name box 
b)
formula bar 
c)
workbook
d)
worksheet
65.

How do you change the color of a worksheet tab?

a)

on the FORMAT menu tab, select colors in the Themes group.

b)

Right-click (two finger click) the tab and select Tab Color.

c)

Click the paint can.

d)

You cannot change the color of a worksheet tab.

66.

The cell that the user is currently working in is identified with a thick dark border around it. It can also be green or blue.

a)

True

b)

False

67.

If you need to add just two cells together is it better to use a formula or function?

a)

function

b)

formula

68.

Which would be the correct way to write a function to add the numbers in cells a2, a3, a4, a5, b1, b2, b3, b4, and b5?

a)

=a2+a3+a4+a5+b1+b2+b3+b4+b5

b)

=sum(a2+a3+a4+a5+b1+b2+b3+b4+b5

c)

=SUM(a2:b5)

69.
Which of the following would be used to find the highest number in a range?
a)
max
b)
min
c)
sum
d)
average
70.

What are the gray lines called that intersect to form a cell?

a)

borders

b)

shading

c)

lines

d)

gridlines

71.
The fx bar at the top of the spreadsheet screen shows what information?
a)
information from the entire spreadsheet
b)
the formulas on the whole spreadsheet
c)
the information that you are typing into the active cell. 
72.

I need to copy a formula down a column what do I do?

a)

click in the middle of the cell and drag down

b)

click between the row numbers and drag down

c)

click on the little square (fill handle) in the bottom right corner of the active cell and drag down

d)

copy and paste

73.
If a formula or function is used correctly, total numbers in a spreadsheet will automatically be updated if something is changed. 
a)
True
b)
False
74.

When a function is copied to multiple cells, the cell address changes in each cell the function is added to. This is called a/an ____________________ reference.

a)

Relative

b)

Formula

c)

Absolute

d)

Function

75.
The ONLY way to center information over a whole row of cells is to:
a)
wrap text
b)
increase the font size of the text
c)
Merge and Center
76.

If a cell address changes when the formula is copied is it?

a)

an absolute cell reference

b)

relative cell reference

77.

=SUM(A1:A15) is an example of what

a)

math problem

b)

formula

c)

function

d)

I have no idea

78.

A function is a shortcut formula

a)

true

b)

false

79.
A formula that automatically adds up a column of numbers is called __________.
a)
cell
b)
auto sum
c)
graph
d)
value
80.
Numbers identified in spreadsheets that are used in calculations are called _____.
a)
gridlines
b)
selecting
c)
values
d)
graph
81.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
82.
Text used in a spreadsheet and usually creates titles is a called a _____.
a)
range
b)
auto sum
c)
row
d)
label
83.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
84.
Highlighting items within a spreadsheet is called selecting.
a)
True
b)
False
85.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
86.
 Which chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company’s budget?   
a)
  Column
b)
 Line
c)
  Pie
d)
.  Scatter
87.
If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he use?  
a)
   Column 
b)
  Line
c)
  Pie
d)
 Scatter
88.
Which chart will best represent a comparison of the average family income for the states, with emphasis on the states?    
a)
  Column
b)
  Line
c)
  Pie
d)
  Scatter
89.
Hal has used four different colors to show the different products that his company sells. What will Hal use to explain the different product colors?   
a)
  X-axis
b)
 Y-axis
c)
  Legend
d)
 Chart title
90.

Which type of chart is best used to represent trend over time?

a)

bar

b)

combination

c)

line

d)

pie

91.

Which one is the secondary axis?

a)

A

b)

B

c)

C

92.
The Rough Riders stacked bar chart above was created to represent the total sales of each employee over a four month period. Which feature will make the plot easier to read?
a)
Axis title
b)
Chart title 
c)
Data series 
d)
Gridlines
93.
The figure above is a chart that represents the effect of irrigation on plant height. Which feature should be added to the chart that will explain the chart's purpose?
a)
Axis title
b)
Chart title
c)
Data label
d)
Legend
94.
Which chart will BEST represents the decline of sales for a music company over the past five years? 
a)
Column 
b)
Line
c)
Pie
d)
XY scatter
95.

A ________________is a visual representation of data.

a)

table

b)

chart

c)

border

d)

spreadsheet

96.

Which two chart types are the most interchangeable?

a)

bar and column

b)

pie and area

c)

pie and bar

d)

line and scatter

97.

Which of the following charts is used to compare a single category of values as parts of a whole?

a)

pie

b)

scatter

c)

column

d)

bar

98.

When could you use a right vertical axis on a chart?

a)

When you have more than 10 data points.

b)

When you have more than 5 categories.

c)

When you are measuring two different sets of data.

d)

When you have too much data for one axis.

99.

Which icon should you click on to change the vertical alignment?

a)
b)
c)
d)
100.

What title is on the horizontal or x-axis?

a)

Favorite Movie Genres

b)

Movie Genres

c)

Number of Votes

d)

Action Adventure

101.

What title appears on the vertival or y-axis?

a)

Favorite Movie Genres

b)

Number of Votes

c)

Movie Genres

d)

80

102.

After highlighting the text in a cell, which icon should you click to change the text color?

a)
b)
c)
d)
103.

The major gridlines on this graph are counting by.....

a)

5

b)

10

c)

20

d)

40

104.

This graphic representation of data is in a....

a)

bar graph

b)

pie chart

c)

line graph

d)

pivot table

105.

The minor gridlines on this graph are counting by......

a)

5

b)

10

c)

20

d)

2

106.

The list of labels on the right is called a ........

a)

value

b)

legend

c)

color

d)

pie

107.

The number inside of the pie slice is called the ........

a)

value

b)

vote

c)

percentage

d)

label

108.

This symbol is called a/an _______________.

a)

alpha

b)

beta

c)

gamma

d)

sigma

109.

By clicking on this icon, you can do all of the following EXCEPT____________________________.

a)

change the border style of cells

b)

make the text bold

c)

add borders to cells

d)

remove borders from cells

110.

What is the correct order of operations when calculating a formula?

a)

parentheses, exponents, multiplication, addition, division, subtraction

b)

parentheses, exponents, addition, subtraction, multiplication, division

c)

addition, subtraction, multiplication, division, parentheses, exponents

d)

parentheses, exponents, multiplication, division, addition, subtraction

111.

The process of arranging data in a certain sequence or order according to specific rules.

a)

sorting

b)

filtering

c)

labeling

d)

inserting

112.

If you need to represent your data in alphabetical order, which option would you use?

a)

filter

b)

merge

c)

sort

d)

arrange

113.

What is the difference in votes between Comedy and Horror?

a)

24

b)

112

c)

16

d)

64

114.

What is the SUM of the formula =6/2+4*2-1?

a)

13

b)

1

c)

7

d)

10

115.

What is the SUM of calculating the formula =6-2*8+7+4 ?

a)

43

b)

-32

c)

1

d)

-21

116.

What is the most efficient way to add alternating row colors?

a)

Select row - Paint Can

b)

Select range - Format - Alternating Colors

c)

Select column - Format - Alternating Colors

d)

Select range - Insert - Alternating Colors

117.

What is the SUM of calculating the formula =-6+(60/5+8)-11?

a)

3

b)

7.8

c)

9

d)

15

118.

What is the SUM of calculating the formula =8+9*(10-2)/4 ?

a)

34

b)

26

c)

18

d)

6.25

119.

What is the SUM of calculating the formula =2+6-9*11-9 ?

a)

-20

b)

1

c)

-100

d)

10

120.

What is the SUM of calculating the formula =2+10*3*5-6 ?

a)

174

b)

-28

c)

92

d)

146

Similar Resources on Wayground

Systemy operacyjne całe półrocze

123 questions

Systemy operacyjne całe półrocze

quiz

Worksheet

•

1st - 6th Grade

HTML Tags (119 Tags)

119 questions

HTML Tags (119 Tags)

quiz

Worksheet

•

6th - 8th Grade

Bedir Grade 4 Exercise

121 questions

Bedir Grade 4 Exercise

quiz

Worksheet

•

4th - 6th Grade

ICT 6 Revision 2

120 questions

ICT 6 Revision 2

quiz

Worksheet

•

6th Grade