FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel_Module_1

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

The opposite of merging cells is splitting a merged cell. _________________________

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

The range of cells receiving copied content is called the ____ area.

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Press ____ to select the entire worksheet.

To enter data in a cell, you must first select the ____.

In a worksheet, columns typically contain information that is similar to a list. _________________________

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

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

____ is/are used to place worksheet, column, and row titles on a worksheet.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

____________________ cells involves creating a single cell by combining two or more selected cells.

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

A character with a point size of 10 is about 10/72 of one inch in height.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

Case 1-1 Perry has recently expanded his business and hired two employees. As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks. -Perry also decides that he should approve ____ of any proposed worksheet.

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