Term
| Some of the most common formatting options available in the Format Cells dialog box are also available on the Home tab and on the Mini toolbar. |
|
Definition
|
|
Term
| ____ are predefined formulas that perform calculations |
|
Definition
|
|
Term
| To use a “general” formula over and over again, but with a different set of numbers, use a feature called absolute cell referencing. |
|
Definition
|
|
Term
| ____ is (are) first in the order of precedence rules |
|
Definition
| Operations in parentheses |
|
|
Term
| The COUNT function ignores blank cells and cells with text. |
|
Definition
|
|
Term
| Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet. |
|
Definition
|
|
Term
| The rules programmed into the function are referred to as a function’s algorithm. |
|
Definition
|
|
Term
| The dollar sign syntax is used by Excel to indicate that a cell reference is absolute. |
|
Definition
|
|
Term
| ____ is(are) second in the order of precedence rules |
|
Definition
|
|
Term
| Functions are predefined formulas that perform calculations. |
|
Definition
|
|
Term
| In the Format Cells dialog box, the Category box lists the available number formats. |
|
Definition
|
|
Term
| Excel stores dates as sequential numbers starting with January 1st of the year ____. |
|
Definition
|
|
Term
| The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. |
|
Definition
|
|
Term
| If a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____. |
|
Definition
|
|
Term
| The function ____ determines the number of values in a list. |
|
Definition
|
|
Term
| $B1 is an example of a(n) ____ reference. |
|
Definition
|
|
Term
| The COUNT function recognizes both text and number cells. |
|
Definition
|
|
Term
| After clicking the AutoSum button and choosing the function you want, Excel presents a suggested range to include in the calculation, based on ____. |
|
Definition
| rows or columns of numbers next to the current cel |
|
|
