Exam 8: Excel_Module_1

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

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

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

Excel can display characters in only three font colors: black, red, and blue.

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

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

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

The ____ button allows you to erase recent cell entries.

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

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

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

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. _________________________

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

____________________ indicates how characters are emphasized.

Clicking the ____ box completes an entry.

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

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

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.