chapter 2 ITS

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

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

A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. scheme gallery theme style

theme

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

If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.

8.43

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Operations

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

To start a new line in a cell, press the ____ keys.

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 small black square located in the lower-right corner of the heavy border around the active cell.

Fill handle

Is text and graphics that print at the bottom of every page.

Footer

One of reasons Excel is such a valuable tool is that you can assign a ______ to a cell, and Excel will calculate the result.

Formula

A prewritten formula that is built into Excel.

Function

Which of the following is the path to the Comma Style button?

HOME tab/ Number Group

Which of the following is the path to the Conditional Formatting button?

HOME tab/ Styles Group

Clicking the ______ opens the Inserts Function Dialog Box.

Insert Function box in the formula bar

Function displays the highest value in a range.

MAX

The ______ function displays the highest value in a range. MIN SUM MAX AVERAGE

MAX

Determines the lowest number in a range

MIN

The ______ function determines the lowest number in a range MAX AVERAGE SUM MIN

MIN

Are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Margins

The most common error when entering a formula is to reference the wrong cell in the formula.

True

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____ colors.

Warmer

You can click the ______ button to undo an automatic correction. auto Fill options autocorrect options Paste options Trace err0r

autocorrect options

All of the following are valid Excel arithmetic operators except... a. * b. ! c. > d. %

c. >

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

A formula in a cell that contains a reference back to itself.

Circular reference

Is text and graphics that print at the top of each page.

Header

The equal sign (=) precedes a formula.

True

A company or department may standardize with a specific ______ so that all of their documents have a similar appearance.

Theme

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

(True or False) The Accounting number format assigns a floating dollar sign.

False

(True or False) You cannot format an entire column at once.

False

(True or False) Cooler colors tend to pull away from the reader.

True

(True or False) Point mode allows you to select cells for use in a formula by using your finger or the pointer.

True

(True or False) To Sum button menu allows you to enter one of five often-used functions easily into a cell.

True

(True or False) Excel has more than 400 functions that preform just about every type of calculation you can imagine.

True

(True or False) Moving from left to right, the first calculation in the order of operations is negation (-).

True

(True or False) The AVERAGE function requires that the argument be included within parenthesis following the function name.

True

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

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

When Excel follows the order of operations, the formula, 8*3+2, equals _____?

26

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

button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accounting number Format

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

Means that the width of a column will be increased or decreased so the widest entry will fit in the column.

Best Fit

Colors jump out a dark background and are easiest to see.

Bright

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

The / arithmetic operator indicates ______.

Division

You can select a range using the keyboard by pressing the ____ key and the and ARROW key F2 f4 F6 F8

F8

(True or False) Best fit means that the width of the column will be increased or decreased by a percentage you specify.

False

(True or False) The range automatically selected by Excel is always correct.

False

(True or False) An asterick (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

False

(True or False) As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.

False

Reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Indirect

The default view in Excel is called ...

Normal

view shows the worksheet divided into pages as well as the header/footer information.

Page Layout View

view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page layout view

To check which cells are referenced in the formula assigned to the active cell.

Range Finder

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 adjusted cell references in a copied and pasted formula are called ____ cell references.

Relative

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

The _______ Autocomplete list contains those functions that alphabetically match the letter you type following the equal sign. function formula equal calculate

formula

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