FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Excel_Module_2

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) She believes that 54 minutes is her best running time.
B) The MAX function recalculates the highest value each time a new value is entered into the worksheet.
C) She believes that 54 minutes is not her best running time.
D) The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

The default view in Excel is called ____ view.

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

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

The / arithmetic operator indicates ____________________.

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

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

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?

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

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

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

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

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

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

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

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

Which of the following calculations multiplies 23 by 0.01?

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

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