Overview
Visualizing your Data
Formulas
100
What is each square called in an Excel worksheet?
A Cell
100
Under which tab can you find conditional formatting options?
The HOME tab
100
Which night-time crime fighter believes in your function-writing skills?
Batman
200
Columns are identified by ____ and rows are identified by ____.
Columns:Letters Rows: Numbers
200
Under which tab can you find graphing options?
The INSERT tab
200
What is a formula?
Any kind of mathematical equation written into a cell
300
What is a cell identifier?
The column letter and row number that a cell is in
300
Name 3 different chart types
Pie, line, column, bar, stacked, radar
300
What is a function?
A predefined formula in Excel
400
What is each page of a workbook known as?
A sheet
400
What does conditional formatting do?
It changes some visual aspect of a cell if it meets chosen specifications
400
How can you copy a formula across multiple cells?
Click and drag the green square
500
Name any of the 2 tabs in the top bar of Excel.
File, Home, Insert, Page Layout, Formulas, Data, Review, View
500
Briefly describe how to create a graph with your data in Excel
Select your data/ headers, click the insert tab, choose a graph style
500
How can you find out if Excel has a function that you'd like to use?
Search in Excel's function library or search Google
M
e
n
u