False A _ is a prewritten formula that is built into Excel. Range Finder To use Range Finder to verify that a formula contains the intended cell references, click or tap the cell with the formula you want to check. False You can use the _ to check which cells are referenced in the formula assigned to the active cell. False The arithmetic operator, ^, directs Excel to perform the division operation. True As in algebra, yo can use brackets to override the order of operations Excel follows to perform formula calculations. (see worksheet) select cells for use in a formula using the mouse pointer The Sum button menu allows you to enter one of fie often-used functions easily into a cell. False Point mode allows you to _, as shown in the accompanying figure. False Which of the following calculations multiples 23 by 0.01? =23% In designing a worksheet, visual aesthetics should come first. MAX The range automatically selected by Excel is always correct. False The _ function displays the highest value in a range.

False An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. True While holding down the ALT key, you can select nonadjacent ranges and cells. footer You can choose from 12 categories or formulas in the Format Cells dialog box. True A _ is text and graphics that print at the bottom of every page. False The most common error when entering a formula is o reference the wrong cell in the formula. True Best fit means that the width of the column will be increased or decreased by a percentage you specify. Page Layout The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent. CTRL +V _ view allows you to create or modify a worksheet while viewing how it will look in printed format. Insert To paste copied cel contents, you can press the _keys. The _Option button lists formatting options following an insertion of cells, rows, or columns.

Dialog box launcher excel