Exam 2: Creating a Worksheet and a Chart

Critical Thinking Questions Case 1-2 Anita is new to Microsoft Excel 2013. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. -Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Live preview is available on a touch screen.

The person or persons requesting the worksheet should supply their requirements in a ____ document.

-A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

What effect does the Accounting Number Format have on the selected cells?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the Find dialog box.

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

A thin red border indicates the active cell.

Worksheet ____________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

____ is an electronic image format, sometimes called a fixed format.

-A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the accompanying figure.

Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time.

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Combining two or more selected cells into one cell is called ____ cells.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Pressing the ____ key to complete an entry activates the adjacent cell to the right.