Exam 10: Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Excel facilitates taking tabular data and converting that data into graphical format.

If a formula references cell A1 and is copied down one row and to the right one column,the new formula will reflect B2 if the cell reference is a(n)________ reference.

Information organized into rows and columns is said to be in ________ format.

The function that allows users to determine how many numerical values exist in a range is the ________()function.

Values should be hard-coded wherever possible.

A(n)________ allows users to perform basic mathematical calculations.

The ________()function is essentially the same as dividing the sum of a range of cells by the count of those cells.

Not all formulas start with the equal sign (=).

A value in a cell referenced by a formula or function is a(n)________.

A cell has exactly three alignments: left-aligned,centered,and right-aligned.

MIN is an example of an AutoSum function.

Predefined set of formatting properties that determine the appearance of a table are known as table ________.

A cell with contents centered in that cell is said to have a centered cell ________ .

A chart is an example of information presented in tabular format.

The following is an example of a built-in function: =J4+J2

The plus sign (+)and the minus sign (-)are examples of ________ used in formulas.

The term fill color refers to the color of the border of a cell.

A table with alternating colored rows is said to have ________.

If you would like values between 25 and 50 in a range of cells to appear in yellow,use conditional formatting.