The ______ Fill tool recognizes patterns of data in other cells of the worksheet and suggests how to refill the data in proper format in the current cells

	Formulas
	Function
	Flash
	Formatting

This type of chart shows frequencies within a distribution; each column of the chart is called a bin and can be changed to supplement data

	Surface
	Waterfall
	Histogram
	Sunburst

The portion of the structured reference enclosed in square brackets following the table name is the ________ specifier

	Column
	Table
	Outline
	Data

This type of chart displays a running total of financial data as values are added or subtracted; columns are color coded so you can quickly tell positive from negative numbers

	Treemap
	Sunburst
	Histogram
	Waterfall

This type of chart compares values from categories; it is similar to line chart except that the areas under the lines contain fill colors

	Line
	Bar
	Area
	Column

This type of Excel chart compares values from different categories with values identified by the height of the line; it is used to show trends and change over time

	Line
	Bar
	Area
	Column

In the ______ tab, you will find the Tables button. Once you create your Table, Table tools will be available to use to apply styles, and variety of other table options.

	Home
	Insert
	Data
	Review

The _____ row inserts a new row the bottom of a table that adds the column values

	Total
	Banded
	Header
	Filter

Excel provides many _______ ______organized into categories

	built-in charts
	small charts
	organized charts
	beautiful charts