WorksheetsExcel Formulas and Charts
Total questions: 16
Worksheet time: 7mins
Identify this chart.
Pie
Line
Bar
Column
Identify this chart.
Line
Bar
Column
Pie
Identify this chart.
Column
Bar
Line
Pie
Tells you what each part of the chart represents.
Legend
Vertical axis
Horizontal axis
Chart title
This part of the chart is usually vertical and contains data.
Y axis
X axis
Legend
Chart title
This part of the chart is usually horizontal and contains categories.
X axis
Y axis
Legend
Chart title
If you want to select two columns that are NOT next to each other to create a chart, hold down the ____ key on your keyboard.
Ctrl (Control)
Alt (Alternate)
Shift
Fn (Function)
According to this chart, which type of pork do people prefer most?
Bacon
Ribs
Ham
Other
According to this chart, in which month are produce sales the highest?
June
March
November
May
According to this chart, which band sold the most albums?
Doug and the Slugs
Gails and the Snails
Sherm and the Worms
Marva and the Larva
=C4+C5
What is the result?
32
12
17
15
What's the Operation?
/
Subtraction
Multiplication
Addition
Division
What's the Operation?
-
Subtraction
Multiplication
Addition
Division
What's the Operation?
+
Subtraction
Multiplication
Addition
Division
What's the Operation?
*
Subtraction
Multiplication
Addition
Division
What is the symbol that lets Excel know that we are entering a formula into a cell?
-
=
_
(
