Exam 8: Excel: Formulas, Functions, and Formatting

Which of the following is the path to the Sum arrow?

The ____ function determines the lowest number in a range.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Displays the worksheet with formulas.

Which of the following is a method of entering functions?

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -A function that displays the highest value in a range.

To copy cell contents,you can select the cell and then press the ____ keys.

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.

You can open the Format Cells dialog box by pressing the ____ keys.

A ____ is text and graphics that print at the top of each page.

-Typing =av in a cell displays the ____________________,as shown in the accompanying figure.

The AVERAGE function requires that the argument be included within parentheses following the function name.

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

When Excel recognizes that you entered a date in mm/dd/yy format,it automatically formats the date as ____________________.

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

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 sign.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

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