FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Excel 2 Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

Critical Thinking Questions 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. After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the value. To specify a floating dollar sign, which of the following formats should Leo apply?

A) Comma style
B) Percent style
C) Currency style
D) General number

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

The range automatically selected by Excel is always correct.

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

The / arithmetic operator indicates ____________________.

You can press the ____________________ key to quit Range Finder.

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

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

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

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

The default view in Excel is called ____ view.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

The ____ function displays the highest value in a range.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Critical Thinking Questions 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?

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

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

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

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

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

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