NEW
Font size
WorksheetsSpreadsheet Formulas,Charts,Formatting
Total questions: 40
Worksheet time: 1hrs 20mins
1. Which of the following charts uses vertical bars to display data?
a. Bar
b. Pie
c. Area
d. Column
Which of the following charts uses horizontal bars to display data?
a. Bar
b. Pie
c. Area
d. Column
4. Which of the following charts is used to compare a single category of values as parts of a whole?
a. Bar
b. Pie
c. Scatter
d. Column
5. A chart ________________ identifies which data series each color represents.
a. legend
b. vertical axis
c. title
d. horizontal axis
What information appears most commonly on the horizontal axis?
a. Quantities
b. Time frames
c. Data series color definitions
d. Titles
What information appears on the vertical axis?
Data series headings or time frames
Data series color definitions
Even counts of all the values in your data series
TITLES
3. A ___________________ is a graphical representation of data.
a. spreadsheet
b. border
c. chart
d. table
9. Which type of chart assigns a color to each data point instead of series?
a. Column
b. Area
c. Pie
d. Scatter
Which two chart types are the most interchangeable?
a. Pie and Area
b. Bar and Column
c. Line and Scatter
d. Pie and Bar
11. What command enables you to change the location of your chart?
a. Cut
b. Copy
c. Move
d. Delete
13. To delete a chart, click once on the chart to select it and then ____________.
a. click the X in the top of the window.
b. press the X key on the keyboard.
c. click and drag the chart off the spreadsheet.
d. press the DELETE key on the keyboard.
12. Which of the following charts is used to represent a trend over time?
a. Column
b. Area
c. Pie
d. Line
When could you use a right vertical axis on a chart?
When you have too much data for one axis.
When you have more than 10 data points.
When you have more than 5 categories.
When you are measuring two different sets of data.
What information is contained in a data label?
Category names
Data point values
Data series names
Axis values
Click on ___________ to add a chart to your spreadsheet
File
Format
Design
Insert
What symbol does a formula have to start with in order for it to work?
#
$
=
@
What symbol does a formula have to start with in order for it to work?
#
$
=
@
Which is NOT a type of chart?
pie
column
bar
axis
What does autosum do?
subtracts totals
adds totals
multiplies totals
divides totals
Which chart would I use to show how Team Teachers beat Team Students in the bowling tournament?
column
xy scatter
pie
line
Which type of chart would you create to compare groups of data?
pie
line
bar
column
Why are charts/graphs used in spreadsheets?
to show a visual of the data in a spreadsheet
to make the spreadsheet look cool
to backup the data you input into the spreadsheet
all of these are reasons
Which is NOT a formula?
b2+b3+b4
=b1+b2+b3
=b4*c4
=b5/b7
Which type of chart is best used to represent trend over time?
bar
combination
line
pie
Google Sheets is what sort of program?
A document program
A spreadsheet program
A presentation program
A television program
What does a formula do in Google Sheets?
It automates a process
It creates a chemical
It answers a question
It finds mistakes
What does the =COUNTIF formula do?
Counts things
Counts how often something occurs
Counts how many different things are there
Counts how many things are in a list
Sum, average, maximum value, and minimum value are examples of what?
a. Exponents
b. Calculations
c. Functions
d. Spreadsheet data
The signs used for addition, subtraction, multiplication, division, and exponents are called:
a. Operators
b. Conditional formatting
c. Calculations
d. Spreadsheet data
Which of the following is an example of a relative cell reference?
a. A5
b. $C$7
c. D$2
d. B2:F6
What character is used to change a cell reference from relative to absolute?
a. $
b. %
c. *
d. ^
When a formula contains several operations, which of the following operations would be performed first?
a. Subtraction
b. Addition
c. Division
d. Multiplication
