Excel Creating Dashboards

Which of the following offers simple overviews of data reports, so you don’t have to go through large volumes of data?

How can you quickly select an entire range of data in a column?

Using named ranges in formulas, _______.

To search a function in the Insert Function dialog box, you can _____________________.

Which function should you use to calculate the average (arithmetic mean) of numbers in a range that meet given criteria?

Which statistical function will count the number of cells that match criteria?

Use data validation to ________________ the type of data that users can enter into a cell.

Which of the following allows users to pick an item from a list that you create?

Which of the following offers an easy way to add, find, change, or delete rows in a range or table?

Use ___________________ when you want to find things in a table or a range by row.

When using nested functions, the outer function is preceded with _____________________ if it is the beginning of the formula.

All the following are guidelines for making effective charts except for which of the following?

Linear, Exponential, and Polynomial are all types of what feature?

Which of the following best describes a sparkline?

A pivot table is useful when ________________, as it lets users apply specific criteria to summarize, organize and reorganize data tables, and create reports.

Finite entries have _______________________of possible values.

What can you use to filter data in a Table or PivotTable?