Excel 5-7 Review

What is the name of the MTV show that catches people making false identities online?

What is the name of Batman's butler?

Rows or Columns that print on every page are called?

To hide more than one row, select the rows, then ____ to show the short-cut menu.

The Highlight Cells Rules format cells based on their rank.

Some mathematical operations do not require functions.

____ are predesigned workbook files that you can use as the basis or model for new workbooks.

___ determines the best width for a column or the best height for a row, based on its contents 

In a PMT function, the argument indicated by nper refers to ____.

Hiding permanently removes a row or column from view.

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

To center cell content across several columns, select the cells, then click the ____ button. 

Formatting that is applied to cells containing data the meets a certain criteria is called?

# of header sections + # of footer sections * X = 12.  What is X?

You can use the SUM function to total values stored in up to 255 non-adjacent cells or ranges.

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

A predefined set of colors, fonts, and effects that can be applied to an entire workbook.

Which function will return the largest number in a selected range?

The ____ function returns the current date and time of the computer’s date and time settings.

The Conditional Formatting button is found in the ____ group on the Home tab.

The Transpose command pastes a row of cells into a column, or a column of cells into a row.

Number of original american colonies + temp(F) at which water boils - youngest age of POTUS

You can find function category buttons in the ____ group on the Formulas tab of the Ribbon.

The SUM function that adds the numbers in the range D5:D17 is ____.

A ____ is a reference in a worksheet that opens another file or page when you click it.

Pasting replaces any content already in the cell.

The function that returns the number of cells in a range of cells that contain data is ____.

What is the name of Snoopy's best friend?

Which of these systems is the oldest?

____ enables you to resize a worksheet to print on a specific number of pages.