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

In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________.

Combining two or more cells together is called __________ cells.

Figure 1-3 In the accompanying figure, a requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

The horizontal and vertical lines on the worksheet are called __________ and make it easier to see and identify each cell.

In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________.

When using in-cell editing, to delete a character or adjacent characters you can use the mouse to drag through the character or characters and then press the DELETE key or click the Cut button on the Standard toolbar.

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

All commands on the Mini toolbar also exist on the Ribbon.

On the Ribbon each __________ surrounds a collection of groups.

Figure 1-2 In the accompanying figure, mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel.

Excel's __________ feature is used to correct common mistakes made during text entry.

The cell into which data is being enter is referred to as the __________ cell.

To use the Name box to select any cell, click the Name box and enter the cell reference of the cell you want to select.

You __________ a worksheet to emphasize certain entries, change the font size, add color to areas, and make the worksheet easier to read and understand.

Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers .

Saving the workbook frequently is important for the following reason: __________

Excel positions text right-aligned in a cell, meaning the entry displays to the far left in the cell.

__________ are a collection of worksheets.

When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a(n)__________.