NEW
Font size
WorksheetsExcel Lesson 1 & 2 Review
Total questions: 30
Worksheet time: 15mins
Chart that use vertical bars
Bar
Pie
Column
Area
Chart that uses horizontal bars
Bar
Pie
Column
Scatter
Visual representation of data
Table
Spreadsheet
Chart
Picture
Chart used to compare a single category of value as parts of a whole
Column
Scatter
Pie
Area
Identifies the data series each color represents
Vertical Axis
Horizontal Axis
Legend
Title
What information appears most commonly on the horizontal axis
Quanities
Titles
Data series headings or time frames
Data series color definitions
Information that appears on the vertical axis
Data series
Titles
Data series headings or time frames
Even counts of all the values in your data series
Which chart is used to identify the type of relationship between categories and/or variables
Scatter
Pie
Column
Area
series of points that are plotted on a chart or graph
Line
Data series
Bar
Data markers
Used to show a common attribute or trend among your data points
Data table
Trendline
Scatter diagram
Legeng
Information that is contained in a data label
Data series names
Data point values
Category names
Axis values
Show margin of error for each data point
Trendlines
Error bars
Gridlines
Vertical axis
Identifies the information being displayed in the chart
Legend
Title
Horizontal axis
Vertical axis
Type of chart that assigns a color to each data point instead of series
Column
Area
Scatter
Pie
When could you use a right vertical axis on a chart
When you have too much data for one axis
When you are measuring two different sets of data
When you have more than 5 categories
When you have more than 10 data points
2 chart types that are the most interchangeable
Pie and area
Bar and column
Scatter and line
Pie and bar
How can you quickly change the appearance of a data series in you chart
Double-click on a series
Ctrl + single click on a series
Click and drag the series
Click the format painter
What allows you to change the location of your chart
Cut
Copy
Move
Delete
Similar to a line chart, comparing 2 or more quantities
Area
Column
Pie
Scatter
To delete a chart, you should do what after you select the chart
Click the X in the top of the window
Press the X key on the keyboard
Click and drag the chart off the spreadsheet
Press the delete key on the keyboard
How does a spreadsheet program store data
Database
Letter and numbers
A text document
Rows and Columns
Rows are identified with
Letters
Numbers
Colors
Cells
Cell Reference
Number 1
B4
=Average
Column C
I only want to see specific data
Sort
Filter
Align
Cut
What does the autofill handle do in Excel
Copy cell content and/or populate cells with series of content
Overwrite copied content
Populate cells with series of content
Copy cells content
Best way to "fit" data
Click on the cell
Right click on the cell
Click on the heading
Double click between the headings
Cell range
S6
A4;A7
F2:F6
K2-K1
Move to cell A1
Ctrl + home
Shift + A
Alt + Home
Tab + A
Put in a specific order
Cut
Sort
Filter
Copy
What does $22.89 represent
Time
General
Number
Currency
