A continuous range of cells from A1 through A5

A single cell created by merging A1 and A5

To lock both the column and row of a reference so it stays the same when the formula is copied

To automatically update a reference to point to the next cell down

To reference the last cell used in the worksheet

It gives a cell or range a memorable name that can be used in formulas instead of its cell address

It automatically sorts a range in alphabetical order

It merges several worksheets into a single sheet

It searches the leftmost column of a table and returns a value from a specified column in that same row

It searches the top row of a table and returns a value from a specified row below it

It totals every numeric value found anywhere in a table

The number of cells in a range that meet one specified condition

The total of all values in a range that meet one specified condition

The number of cells in a range that meet two or more conditions

The current date, updated automatically whenever the workbook recalculates

A fixed date that never changes once entered

The column header text turns bold automatically

The drop-down arrow in the header changes to a funnel-shaped icon

It stays exactly as it was first applied and never changes again

It re-evaluates automatically and updates to match the new value

The rule is automatically deleted from the cell

To describe what the values along each axis represent

To automatically sort the underlying data

To change the chart's overall color scheme

Excel Quiz