# Shared Flashcard Set

## Details

Test Questions
18
Computer Science
09/26/2013

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
 True
Term
 ____ are predefined formulas that perform calculations
Definition
 Functions
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
 False
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
 True
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
 False
Term
 The rules programmed into the function are referred to as a function’s algorithm.
Definition
 True
Term
 The dollar sign syntax is used by Excel to indicate that a cell reference is absolute.
Definition
 True
Term
 ____ is(are) second in the order of precedence rules
Definition
 Exponentiation
Term
 Functions are predefined formulas that perform calculations.
Definition
 True
Term
 In the Format Cells dialog box, the Category box lists the available number formats.
Definition
 True
Term
 Excel stores dates as sequential numbers starting with January 1st of the year ____.
Definition
 1900
Term
 The Accounting Number Style displays values with commas and two decimal places, but no dollar signs.
Definition
 False
Term
 If a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____.
Definition
 Calculation
Term
 The function ____ determines the number of values in a list.
Definition
 COUNT
Term
 \$B1 is an example of a(n) ____ reference.
Definition
 mixed
Term
 The COUNT function recognizes both text and number cells.
Definition
 False
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
Supporting users have an ad free experience!