FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Excel: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

You cannot format an entire column at once.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) placement
B) operations
C) positioning
D) selections

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Using the Excel spell checker,you can ____.

You can use the arrow keys to complete an entry in Point mode.

Identify the letter of the choice that best matches the phrase or definition. -Copies a formula.

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?

The function,or ____________________,of a worksheet is to provide a user with direct ways to accomplish tasks.

Which of the following are valid formulas?

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

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

In the order of operations,the last operation Excel performs is ____________________.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

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.

Identify the letter of the choice that best matches the phrase or definition. -Wraps text in a cell.

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

Cooler colors tend to pull away from the reader._________________________

Identify the letter of the choice that best matches the phrase or definition. -Spell-checking a worksheet.

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

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