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 

