Vocabulary
Column Formatting Commands
Formulas & Functions
Cell References
Other
100
Examples of this type of formatting are: color scales, icon sets, and data bars
Conditional Formatting
100
Sets the width to a specific number of characters
What is Column Width
100
The types of formulas you can use in a worksheet
What are simple and complex
100
Allows you to cycle through the different combinations of cell references
What is [F4]
100
The default column width.
What is 8.43 characters
200
Centers text across columns, and combines two or more selected adjacent cells into one cell
What is the Merge & Center Button
200
Resets column to worksheets default column width
What is Default Width
200
You can insert these by clicking the Sum list arrow
What is a Function
200
Used when you want to preserve the exact cell address in a formula.
What is Absolute Cell Reference
200
When you cut or copy text without the drag-&drop methods, it is moved here from the document.
What is the clipboard
300
Pre-designed combinations of formats
What are Cell Styles
300
Fits to the widest entry in a colunm
What is AutoFit Column Width
300
The function that displays how many cells there are in a range.
What is COUNT
300
Is used when you want to preserve the relationship to the formula location
What is relative cell reference
300
Formats that you can apply to effect the way text and numbers look in a worksheet
What are font affects
400
Determines the physical appearance of labels and values
What is Format
400
Hides or displays hidden column(s)
What is Hide & Unhide
400
Uses more than one arithmetic operator.
What is a complex formula.
400
Examples are $Z10 and Z$10
What are mixed cell references
400
The box at the top of each column containing a letter
What is the column heading
500
What format adds dollar signs and two decimal places to the data?
What is Accounting Number Format
500
What button do you click on to make these commands available?
What is format button
500
Rules used to determine which operation to perform first
What is Order of Precedence
500
It is important to make sure that formulas refer to the correct ____ _______ when you reference them.
What is a Cell Address
500
Right click cell--> insert-->
What is inserting cells
M
e
n
u