Show:
Vocabulary
Formatting
Cell Referencing
Formulas
Miscallaneous
100
The placement of cell contents in relation to a cell's edges
What is alignment
100
In which group are the accounting number format and Comma Style Button located?
What is the Number group
100
Type of cell reference that does not change when copied
What is absolute cell reference
100
Formula that uses more than one arithmetic operator
What is a comlpex formula
100
Predefined worksheet formulas that enable you to perform complex calculations easily
What is a function
200
The typeface or design of a set of characters (letters, numbers, symbols, and punctuation marks).
What is font
200
A format applied to values to express numeric concepts, such as currency, date, and percentage
What is Accounting Number Format
200
Type of cell reference in which either the column or row remains constant when copied while the other changes
What is mixed cell reference
200
Formula prefix
What is =
200
List two ways to copy & move cell entries.
What is Copy & Paste buttons in clipboard groups, and drag & drop method while holding [CTRL]
300
The appearance of a cell and its contents, including font, font styles, font color, fill color, borders, and shading
What is format
300
Type of formatting used with dollar amounts but does not use a dollar sign
What is Comma Style Format
300
Type of cell reference that changes when copied
What is relative cell reference
300
This is an example of what kind of formula: =D4+D5/D6
What is a complex formula
300
What are three examples of functions?
What is MAX, MIN, and COUNT (& others…)
400
A feature that automatically adjusts the wdth of a column or the height of a row to accomodate its widest or tallest entry
What is AutoFit
400
A type of cell formatting that changes based on the cell's value or the outcome of a formula
What is condition formatting
400
Which key would you press to cucle through the different types of cell references?
What is [F4]
400
Rules that determine which operation to perform first in Excel
What is Order of Precedence
400
Formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet
What is font styles
500
Predesigned combinations of formats based on themes that can be applied to selected cells to enhance the look of a worksheet
What is Cell Styles
500
What you use to modify a conditional formatting rule
What is Rules Manager
500
This is an example of what type of cell referencing? =D$6
What is Mixed cell reference
500
List Order of precendence
What is Parentheses, Reference Operators, Exponents, Multiplication/Division, Addition/Subtraction
500
Box at the top of each column containing a letter
What is column heading