Exam 2: Formatting, functions, and Formulas

________ color is the background color of a cell.

When a number format is applied to a cell,its contents are ________ aligned in the cell.

How many options are there for aligning the contents within a cell?

is the ________ button.

To apply the COUNT function to a selected range of cells containing numbers,you begin by clicking the ________ arrow.

The Top 10 Items option is displayed by selecting the ________ Rules from the Conditional Formatting menu.

Following Excel's order of operations,the result of the formula =2*4-2^3 is ________.

Only visible data is a table is used by the SUBTOTAL function in calculating results.

To find the smallest numerical value in a range of cells,you would use the MIN function.

^ is the symbol used in Excel to indicate multiplication.

Adding a total row to a table only allows you to sum the columns.

To find the greatest numerical value in a range of cells,you would use the ________ function.

The values inside a function's parentheses are called ________.

When using the Accounting number format,negative numbers are indicated by ________.

When cell D4 containing the formula =A4*B5 is copied to cell E2,the formula in cell E2 is ________.

Following Excel's order of operations,the result of the formula =2^3-6/2 is 1.

To hide or show gridlines in a worksheet,you click Gridlines in the ________.

When using the Currency number format,zero values are displayed as a long dash (-)at the decimal position.

A(n)________ is a program that perform an operation on data.