The _______________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
What is equal sign.
100
A blank cell in Excel has a numerical value of _____
What is zero.
100
The ______________function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
What is Average function.
100
The __________function displays the highest value in a range.
What is Max
100
The ______function determines the lowest value in a range.
What is Min.
200
The ______________________inserts a comma every 3 positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
What is Comma style format.
200
A(n) ________________is a dollar sign that appears immediately to the left of the first digit in a cell with no spaces.
What is floating dollar sign.
200
Formatting that appears only when the value in a cell meets specified conditions is called________________.
What is conditional formatting.
200
A(n) ________________is defined as a letter, number, symbol, or punctuation mark is the default font used by Excel.
What is character.
200
A(n) _____________ is a dot on the screen that contains a color.
What is pixel
300
___________________means that the width of a column will be increased or decreased so the widest entry will fit in the column.
What is Best fit.
300
The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.
What is formulas version.
300
Used for importing into Excel data that is stored on a Web site.
What is Web Query.
300
When more that one arithmetic operator in involved in a formula, Excel follow an order form left to right in a formula calculation.
What is order of operations.
300
To start a anew line in a cell press ________________after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.
What is ALT + ENTER
400
Every time you enter a value into a cell in the worksheet, Excel automatically _____________formulas.
What is recalculates all.
400
Using the ___________button on the Ribbon instructs Excel to display additional decimal places in a cell.
What is increase decimal.
400
____________means that the width of the column will be increased or decreased so the widest entry will fit in the column.
What is best fit.
400
The ___________of the worksheet shows the actual formulas you have entered, rather than the resulting values.
What is formulas version.
400
The process of finding and correcting errors in a worksheet is called _____________________.
What is debugging.
500
To import data stored on a Web site use a _____________.
What is Web Query
500
True or False
Regardless of the length and complexity of a formula, using Point Mode to enter formulas always is slower and less accurate than using the keyboard.
What is False.
500
True of False
The comma style button is located on the ribbon.
What is True.
500
True or False
A character is a dot on the screen that contains a color.
What is False.
500
A predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.