Exam 4: Excel: Formulas, Functions, and Formatting

Which of the following is the toolbar that contains the Copy and Paste buttons?

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

The equal sign (=)precedes a formula.

Clicking the Formula Builder button in the ____ opens the Formula Builder shown in the accompanying figure.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

All of the following are automatic features that Excel displays as option buttons in a workbook while you are working on it EXCEPT ____.

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

In designing a worksheet, visual aesthetics should come first.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter button or press the RETURN key.

Statistical functions ignore blank cells.

Which of the following Option buttons gives options for filling cells following a fill operation?

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

Discuss how to determine the formulas and functions needed for a worksheet.

Leo, owner of Leo's Bread Company, recently installed Excel 2010 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?

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

The MAX function can only be entered using the Formula Builder in the formula bar.

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

Which of the following actions are provided by the Paste Options button?

Dates that include years both before and after the year 2000 should be formatted with a two-digit year.