Excell Review (2010 Office)
All of the following are valid Excel arithmetic operators except _____.
>
Cell references in a formula are called _____.
Assumptions.
The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
Fill handle.
_____ is a prewritten formula that is built into Excel.
Function.
The _____ is a blinking vertical line that indicates where the next typed character will appear.
Insertion Point.
In the accompanying figure, the split double arrow mouse pointer _____.
Is the result of moving the mouse pointer to the boundary between column heading A and column heading B.
By default, text is _____ in a cell.
Left-aligned.
The _____ function displays the highest value in a range.
Max.
Combining two or more selected cells into one cell is called _____ cells.
Merging.
A(n) ____ IF function is one which the action taken for the true or false case includes another IF function.
Nested.
You should use a _____ chart to show the relationship or proportion of parts to a whole.
Pie.
Which of the following cell contents is extended to Qtr2, Qtr3, & Qtr4 by dragging the fill handle?
Qtr2
_____ is/are used to add worksheet, column, and row titles on a worksheet.
Text.
When working with a large worksheet, you can split the window into _____ panes.
Two or four.
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
Theme.
To enter data in a cell, you must first select or activate the _____.
Cell.
A _____ is a separate sheet in a workbook that contains only a chart.
Chart sheet.
To remove an embedded chart, you should _____ it and press the DELETE key.
Click.
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
Colon (:)
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.
Constant.
A(n) _____ chart is drawn on the same worksheet as the data.
Embedded.
Clicking the _____ box completes an entry.
Enter.
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell.
In Excel, a number can contain the characters _____.
0123456789 : .$%Ee, +-(),/
How many chart types does Excel offer?
11
An Excel _____ allows data easily to be summarized and charted.
Worksheet.
When you enter a two-digit year that is less than 30, Excel changes the year to _____.
20xx
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.
26.
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type _____.
6E15
If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.
8.43
Which comparison operator means "not equal to"?
< >
Which of the following calculations multiplies 23 by 0.01?
=23%
Error messages begin with the _____ symbol.
#
_____ refers to cells not wide enough to display the entire entry.
#####
The path to the Format Painter button is _____.
(Home tab | Clipboard group)
The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
Accounting number format.
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
Average.
The most popular background color is _____.
Blue.
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the _____.
Destination area (or paste area).
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells _____.
Dialog Box Launcher.
_____ the Format Painter button & drag through the nonadjacent ranges to paint formats to the ranges.
Double-click.
A Pie chart with one of more slices offset is called a _____.
Exploded Pie chart.
You can select a range using the keyboard by pressing the _____ key and then an ARROW key.
F8
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.
Operations.
You can use the _____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder.
You can ensure correctness in your formulas by carefully checking them using _____.
Range Finger.
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type _____.
Range.
A _____ reference is an adjusted cell reference in a copied and pasted formula.
Relative.
The adjusted cell references in a copied and pasted formula are called _____ references.
Relative.
Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
Right parenthesis.
