Exam 8: Excel_Module_1

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

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

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

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

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.

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

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

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.

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

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

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

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

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

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

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

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

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

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

Press ____ to select the entire worksheet.