Excel chapter 2 Multiple choice
The _______ Autocomplete list contains those functions that alphabetically match the letter you type following the equal sign. function formula equal calculate
formula
Which of the following is the path to the Comma style button? Hometab/ Alignment tab Hometab/ Fontgroup Hometab/ Cells group Hometab/ number group
hometab/ number group
The ______ options button lists error checkingoptions following the assignment of an invalid formula to a cell. find error explain error fix error trace error
trace error
All of the following are valid Excel arithmetic operators except______ A. ^ B. * C. % D. >
>
To start a new line in a cell, press the ____ keys A. CTRL+ENTER B. TAB+ENTER C. ALT+ENTER D. SHIFT + ENTER
ALT+ENTER
Which of the following Option buttons fives options for filling cells following a fill operation? Autofill options Auto Correct options Insert Options Paste Options
Auto Fill Options
The ______ function displays the highest value in a range. MIN SUM MAX AVERAGE
MAX
The ______ function determines the lowest number in a range MAX AVERAGE SUM MIN
MIN
You can click the ______ button to undo an automatic correction. auto Fill options autocorrect options Paste options Trace err0r
autocorrect options
The ____ option button lists formatting options following an insertion of cells, row, or columns autocorrect insert auto fill paste
insert
clicking the _____ opends the Insert Function dialog box shown int eh accompanying figure. Insert function box on the formula bar function dialog box launcher Function button Functions and formulas button on the status bar
insert function box on the formula bar
To paste copied cell contents you can press the _____ keys. CTRL+C CTRL+P CTRL+V CTRL+X
CTRL+V
Which of the following happens when you enter the formula =G15 into a cell? Excel recalculates all formuals in the worksheet Excel assigns the sum of the values in the previous 15 cells to the active cell Excel assigns the value in cell G15 to the active cell Nothing, =G15 is an invalid formula
Excel assigns the value in cell G15 to the active cell
When you decrease the row height to ______ the row is hidden. 0 1 2 3
0
When you enter a two digit year that is less than 30, Excel changes the year to______ A. 20xx B. 30xx C. 18xx D. 19xx
20xx
A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. scheme gallery theme style
theme
A ________ is a prewritten formula that is built into Excel. A. function B.feature C. task D. calculation
function
Which of the following is the path to the Conditional Formatting button? Hometab/Editinggroup Stylestab/Formattinggroup Formatting group/ Styles group Hometab/ styles group
hometab/ styles group
Which of the following is the path to the Sum button? editing tab/home group home tab/Editing group Hometab/ Clipboard group Calculation tab/ editing group
hometab/editing group
When excel follows the order of operations the formul, 8*3+2 equals_______ 40 26 48 13
26
If you do not assign a format to a cell or cells in a column, the column width will remain ______ characters. 8.43 7.52 11.65 9.43
8.43
Which of the following calculations multiplies 23 by 0.01? =23% =23 =23+.01 =24-.01
=23%
Which of the following is the path to the Copy and Paste buttons? (home tab/ Copy group) (home tab/ paste group) (home tab/ Clipboard group) (home tab/Formulas group)
(home tab/ Clipboard group)
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. MIN SUM AVERAGE MAX
AVERAGE
You can open the Format Cells dialog box by pressing the ______ keys. SHIFT+TAB CTRL+1 ALT+1 SHIFT+F1
CTRL+1
To copy cell contents you can select teh cell and then press the _____ keys. CTRL+V CTRL+X CTRL+B CTRL+C
CTRL+C
You can select a range using the keyboard by pressing the ____ key and the and ARROW key F2 f4 F6 F8
F8
you can use the ____ to check which cells are referenced int he formula assigned to the active cell. formula finder range finder calculation finder function finder
Range finder
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. comma style accounting number percent style currnecy style
accounting
A ____ cell in Excel has numerical value of zero. blank formatted copied filled
blank
The most popular background color is_____ blue white red yellow
blue
You should _____ a function name in the Formula AutoComplete list to select the function. doubleclick click right click none of the above
double click
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign. fixed formatted floating none of the above
fixed
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra. placement positioning operations selections
operations
_____ allows you to create or modigy a worksheet while viewing how it will look in printed format. normal page layout page break preview full screen
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 active sheets print selection print entire workbook none of the above
print selection
The adjusted cell references in a copid and pasted formula are called _____ references. related relative pasted alternative
relative
Which of the following is the path to the Spelling button? Hometab/ Progging group Proofing tab/ spelling group Review tab/ Proofing group Reiveiw tab/ checking group
review tab/ proofing group
Excel automatically appends the _______ to complete the AVERAGE function when you click the Enter box or press the ENTER key. left parentesis right bracket right parenthesis left bracket
right parenthesis
Point mode allows you to _____ select cells for use in a formula using the keyboard select a function from the Sum button list 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