A ________ is a prewritten formula that is built into Excel. |
function |
To start a new line in a cell, press the ____ keys |
ALT+ENTER |
When you enter a two digit year that is less than 30, Excel changes the year to______ |
20xx |
All of the following are valid Excel arithmetic operators except______ |
> |
Which of the following calculations multiplies 23 by 0.01? |
=23% |
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra. |
operations |
When excel follows the order of operations the formul, 8*3+2 equals_______ |
26 |
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 |
Point mode allows you to _____ select cells for use in a formula using the mouse pointeredit cell contents directly in the cell |
select cells for use in a formula using the mouse pointer |
The adjusted cell references in a copid and pasted formula are called _____ references. |
relative |
Which of the following is the path to the Copy and Paste buttons? |
(home tab/ Clipboard group) |
You can click the ______ button to undo an automatic correction. |
autocorrect options |
Which of the following Option buttons fives options for filling cells following a fill operation? |
Auto Fill Options |
The ______ options button lists error checkingoptions following the assignment of an invalid formula to a cell. |
trace error |
You can select a range using the keyboard by pressing the ____ key and the and ARROW key |
F8 |
The ____ option button lists formatting options following an insertion of cells, row, or columns |
insert |
A ____ cell in Excel has numerical value of zero. |
blank |
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 _______ Autocomplete list contains those functions that alphabetically match the letter you type following the equal sign. |
formula |
Excel automatically appends the _______ to complete the AVERAGE function when you click the Enter box or press the ENTER key. |
right parenthesis |
Which of the following is the path to the Sum button? |
hometab/editing group |
You should _____ a function name in the Formula AutoComplete list to select the function. |
double click |
The ______ function displays the highest value in a range. |
MAX |
clicking the _____ opends the Insert Function dialog box shown int eh accompanying figure. |
insert function box on the formula bar |
The ______ function determines the lowest number in a range |
MIN |
To copy cell contents you can select teh cell and then press the _____ keys. |
CTRL+C |
To paste copied cell contents you can press the _____ keys. |
CTRL+V |
you can use the ____ to check which cells are referenced int he formula assigned to the active cell. |
Range finder |
A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. |
theme |
You can open the Format Cells dialog box by pressing the ______ keys. |
CTRL+1 |
The most popular background color is_____ |
blue |
The ________ displays numbers with a fixed dollar sing 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 |
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign. |
fixed |
Which of the following is the path to the Comma style button? |
hometab/ number group |
Which of the following is the path to the Conditional Formatting button? |
hometab/ styles group |
If you do not assign a format to a cell or cells in a column, the column width will remain ______ characters. |
8.43 |
When you decrease the row height to ______ the row is hidden. |
0 |
Which of the following is the path to the Spelling button? |
review tab/ proofing group |
_____ allows you to create or modigy a worksheet while viewing how it will look in printed format. |
page layout |
To pring a range of cells in teh actinve worksheet, click _______ in the Settings area in the Print gallery, as shown in the accompanying figure. |
print selection |
Excel chapter 2 Multiple choice
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price