Name: 

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.

When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.

The ____ button lists formatting options following an insertion of cells, row, or columns.

Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.

When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____.

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

As with column widths, when you decrease the row height to 0, the row is ____.

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

To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.

You can apply conditional formatting to ____.

Which buttons in the Spelling dialog box will not change the spelling of the word?

The arithmetic operator, ^, directs Excel to perform the division operation.

One of the least common mistakes made with Excel is to include the wrong cell reference in a formula.

To use Range Finder to verify that a formula contains the intended cell references, right-click the cell with the formula to be checked.

Excel does not allow the contents of a cell to be aligned vertically.

The Comma Style button is located on the Ribbon.

When using conditional formatting, if the condition is true, then Excel applies the formatting.

A pixel is defined as a letter, number, symbol, or punctuation mark in 10-point Arial font, the default font used by Excel.

The default row height in a blank worksheet is 12.75 points (or 17 pixels).

You can preview a worksheet using the Print Preview button on the menu bar.

When a workbook is sent as an attachment to an e-mail, the recipient can double-click the attachment to open it in Excel, or save it on disk and then open it at a later time.

Excel places a small purple triangle, called a(n) ____________________, in a cell to indicate that a smart tag is available.

A blank cell in Excel has a numerical value of ____________________.

The values used with a function are called ____________________.

The ____________________ function displays the highest value in a range.

The ____________________ function determines the lowest value in a range.

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

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

To append words to the dictionary, click the ____________________ in the Spelling dialog box shown in the accompanying figure when Excel identifies the word as not in the dictionary.

The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.

____________________ is the process of finding and correcting errors in a worksheet.

The TOTAL function sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.

A fixed dollar sign appears to the far left in the cell, often with spaces between it and the first digit; whereas a moving dollar sign appears immediately to the left of the first digit with no spaces.

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

Discuss the relationship of debugging and displaying or printing the formulas version of a worksheet. Also describe the difference between the formulas version and the values version.

Critical Thinking Questions

Case 1
Leo, owner of Leo’s Bread Company, has recently acquired Excel 2007. He would like to set up a workbook to track sales of different types of breads to determine which types are the most popular among customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo uses the Accounting Number Format with the sales numbers he enters into the cells.

The worksheets still have the default names assigned to them automatically by Excel. How would Leo rename the worksheets to Rye Bread, Onion Rolls, and Bagels?

a.	In cell A1, press ALT+ENTER keys and type the new name.	c.	Select cell A1 of the worksheet and type the new name.
b.	Double-click the worksheet tab, type the new name, and press the ENTER key.	d.	Click the top center cell on the worksheet and type the new name.