Dashboard & Workbook
Basics
Functions
Formulas
PivotTables & Charts
100

A visual summary of data.

What is a dashboard?

100

This function adds a range of numbers.

What is SUM?

100

This symbol must be entered before your formula.

What is the equal (=) sign?

100

This chart shows trends over time.

What is Line chart?

200

To maneuver around your workbook, these 3 options available.

What is Enter, Tab or manually selecting a cell?

200

This function returns the average.

What is AVERAGE?

200

_____ are instructions that tell Excel how to calculate something.

What is Formula?

200

This feature allows you to spotlight the trend of your data.

What is Trendline feature?

300

To create a new workbook, you must select a ______ workbook.

What is Blank?

300

This function counts only the cells in a range that contain numbers.

What is COUNT?

300

This is known as a calculation or function.

What is FORMULA?

300

This table summarizes large datasets.

What is PivotTable?

M
e
n
u