FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) range
B) bunch
C) nearby cell
D) neighbor

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

A thin red border indicates the active cell.

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.

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

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

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

Live preview is available on a touch screen.

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

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

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?

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

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

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

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

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

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

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