Exam 13: Excel: Formulas, Functions, and Formatting

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 are valid formulas?

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

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

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

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

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

You cannot format an entire column at once.

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?

Cooler colors tend to pull away from the reader._________________________

Using the Excel spell checker,you can ____.

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

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

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.

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

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

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.

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

-Typing =av in a cell displays the ____________________,as shown in the accompanying figure.

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