FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Excel : Creating a Worksheet and an Embedded Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

What effect does the Comma Style format have on the selected cells?

A) Converts decimals to commas within a cell
B) Converts decimals to commas within merged cells
C) Displays cell contents with two decimal places and commas as thousands separators
D) Allows for substitution of selected characters

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

The cell into which data is being entered is referred to as the _________________________ cell.

_____ is/are used to add worksheet, column, and row titles on a worksheet.

An Excel _____ allows data easily to be summarized and charted.

A single point is about 1/32 of one inch in height.

_________________________ indicates how text characters are emphasized.

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

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

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

Which of the following keys toggles between Insert mode and Overtype mode?

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

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab | Charts group).

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

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

You can insert a function in a cell by _____.

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

The automatically adjusted cell reference in a pasted formula is called a(n)_________________________.

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