Exam 8: Formats, Functions, and Formulas

To hide gridlines,check the Gridlines box in the Show group on the ________ tab.

________ formatting allows the specification of rules that apply formatting to cells or specific controls,as determined by the rule outcome.

The presentation of text and numbers in tables is called ________ format.

If you want to see how many cells in a specified range contain numbers,you would use the ________ function.

Only one style can be applied to a cell.

The ________ function is a commonly used function or totaling cell value.

When a cell is formatted as Currency,zero values are displayed as 0 with zeroes in each decimal place.

When someone is said to be color-blind,they have trouble distinguishing between ________.

Excel stores time values as decimal portions of one ________.

Standard cell formatting is always in place unless another format is specified.

A built-in ________ is a predefined and named combination of cell-formatting and content-formatting that can be applied to a cell or range of cells.

A function is a built-in program that performs operations on data.

In a function,arguments are included inside the parentheses following the function name.

________ formatting is a way to dynamically change the visual presentation of information in a manner that adds information to the worksheet.

The ________ function runs calculations only on the data that is in the subset when a filter is applied.

All of the following are valid cell ranges EXCEPT:

In Excel,a(n)________ is a built-in program.

________ is alternating the background color of rows and/or columns to assist in visually tracking information.