A
B
C
D
E
100
Accounting Number Format
What is excel displays the dollar sign to the left of the number, inserts comma's every three positions to the left of the decimal point, and rounds numbers to the nearest cent.
100
Order of Operations
What is moving from left to right in a formula
100
Gridlines
What is horizontal and vertical lines on the worksheet
100
Average Function
What is the sum of the numbers in the range of specified numbers
100
Cell Reference
What is the cell referred by its unique address
200
Live Preview
What is a feature that allows you to point to a gallery choice and see its effect in the worksheet without actually selecting the choice
200
Range finder
What is used to check which cells are referenced in the formula assigned to the active cell
200
Spell Checker
What is used to check the spreadsheet for spelling errors
200
Theme
What is predefined set of colors, fonts, chart styles, cell styles and fill effects.
200
Formula
What is followed by a = and is a valuable tool to calculate results in a spreadsheet.
300
Fixed Dollar Sign
What is the dollar sign displayed at the far left in the cell with spaces between it and the first digit
300
Accounting Number Format
What is the dollar sign to the left of the number, comma's every three positions to the left of the decimal, and numbers rounded to the nearest cent.
300
Portrait Orientation
What is printed along the width of the page
300
Conditional formatting
What is formatting that applies conditions to a cell, range of cells, entire worksheet or workbook
300
Pixel
What is a dot on the screen that contains a color
400
Formula Version
What is the view of the actual formulas entered on the spreadsheet
400
Debugging
What is the process of finding and correcting errors in the worksheet
400
Floating Dollar Sign
What is the dollar sign that appears immediately to the left of the first digit with no spaces
400
MIN function
What is the lowest number in a range
400
Comma Style format
What instructs Excel to display numbers with commas and no dollar signs
500
Web Query
What is imported external data from a web site using a query
500
Best Fit
What is the width of the column increased or decreased so the widest entry will fit the column
500
Landscape Orientation
What is printed along the length of the page
500
MAX Fuction
What displays the highest value in a range
500
Spell Checker
What is used to check for spelling errors