FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Excel: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Copy and Paste
B) Editing
C) Standard
D) Clipboard

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

Statistical functions ignore blank cells.

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

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

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

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

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?

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

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

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

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

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

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

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

The equal sign (=)precedes a formula.

In designing a worksheet, visual aesthetics should come first.

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

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

Identify the letter of the choice that best matches the phrase or definition.

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