Exam 13: Excel: Formulas, Functions, and Formatting

A(n)____ circular 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.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

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

Which of the following calculations multiplies 23 by 0.01?

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

When designing a worksheet,which steps should be taken to ensure that functional considerations supersede visual aesthetics?

Which of the following actions are provided by the Paste Options button?

A ____ is text and graphics that print at the bottom of every page.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

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

The / arithmetic operator indicates ____________________.

When you click the Decrease Font Size button,Excel assigns the next highest font size in the Font Size gallery.

The default font for the Basis theme is different than the default font for the Office theme.

As in algebra,you can use brackets to override the order of operations Excel follows to perform formula calculations.

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

-Point mode allows you to ____,as shown in the accompanying figure.

You should ____ a function name in the Formula AutoComplete list to select the function.

A formula in a cell that contains a reference back to itself is called a(n)____________________.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Case 2-2 Anna is a competitive runner.She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance.Her worksheet contains the following data: start and end time,total time,and distance. -Now Anna wants to know the longest total time she has run.By looking at the total time values,she finds the longest total time to be 54 minutes.Instead of manually entering that value in a cell below the total time data,Anna decides to use the MAX function to determine the longest total time.Why did Anna prefer to use the MAX function?