Exam 9: Excel_Module_2

The default view in Excel is called ____ view.

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

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

A(n) ____________________ is a dot on the screen that contains a color.

Clicking the Create Function box opens the Function Arguments dialog box.

The / arithmetic operator indicates ____________________.

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

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

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

You can click the ____ button to undo an automatic correction.

Case 2-1 Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format. -Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to accomplish this?

Which of the following calculations multiplies 23 by 0.01?

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

When you decrease the row height to ____, the row is hidden.

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

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

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

You can click the Page Layout button on the status bar to switch to ____________________ view.

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?

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