When using in-cell editing, to delete a character or adjacent characters you can use the mouse to drag through the character or characters and then press the DELETE key or click the Cut button on the Standard toolbar.

A character is a dot on the screen that contains a color.

Excel can display characters in only three font colors: black, red, and blue.

The AVERAGE function requires that the argument (the range) be included within parentheses before the function name.

Text entered in a cell cannot be realigned.

The ____________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.

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

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

The ____________________ Indent button decreases the indent by three spaces each time you click it.

A(n) ____________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel.

When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a(n) __________.

You __________ a worksheet to emphasize certain entries, change the font size, add color to areas, and make the worksheet easier to read and understand.

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

Formatting that appears only when the value in a cell meets specified conditions is called ____________________.

Use a(n) ____________________ chart to show the relationship or proportion of parts to a whole

Case 4
George runs a mid-size accounting practice. He has recently upgraded to Excel for some aspects of his business. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.

If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the Receptionist. Otherwise, George will just purchase the desk and chair. How should George determine this in the worksheet?_______________

a.	use a relative reference	c.	use an absolute reference
b.	use the IF function	d.	use the NOW function

Case 1
Perry has recently expanded his business from a sole proprietorship to include two new employees he has hired. As a result of this expansion, he is considering carefully how to save the workbooks that he and his employees will create, and what storage media would be the best for the workbooks.

Perry decides that he will need to have access to particular workbooks on a variety of computers in the office. As a result, which of the following storage media is a good choice for him? _____________

a.	USB flash drive	c.	Internet
b.	hard drive	d.	Web site

Case 3
Bea is the best pie baker around. She has decided to go into business and takes a survey in her town to find out what types of pies are favorites. She decides to record her data in a workbook to present to the bank when she seeks a loan for her business startup costs. Naturally, Bea wants a Pie chart in her workbook. She would like each slice to represent the different types of pies she plans to sell and show this on a 3-D Pie chart.

Bea has received a suggestion to emphasize the most favorite type of pie. From a design perspective, what should she do to emphasize the apple pie?____________

a.	not do anything to the slice because Excel does it automatically	c.	rotate the apple pie slice toward the front and explode it
b.	move the chart to the upper-left corner of the chart sheet	d.	rotate the apple pie slice toward the back and color it a pale yellow

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

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 white spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the number. To format the location of the dollar sign, which category on the Number tab in the Format Cells dialog box would he select?________________

a.	General	c.	Currency
b.	Number	d.	Accounting

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.

The formulas version verifies that you entered formulas, rather than ____, in formula-based cells.

The ____ is ideal for returning the worksheet to its original state after you have changed the values in a worksheet to answer a what-if question.

__________ are a collection of worksheets.

The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values.

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.