Exam 7: Creating and Enhancing a Worksheet

The AVERAGE function is so common it has its own button on the HOME tab

A group of selected cells that share boundaries is called a cell range

In the accompanying figure, item 1 points to the ____.

When you type something in a cell and then press Enter, the cell pointer moves to the first cell of the next row

Click the ____________________ button on the PAGE LAYOUT tab to add a consistent look to all of the elements in your workbook.

In the accompanying figure, item 2 points to the ____.

In addition to themes, you can add ______________ to individual cells to improve their appearance.

To insert a column, click the column heading to the right of where you want the new one, and then click the Insert button in the ____ group.

In Excel, the asterisk is the symbol for ____.

Every cell in a worksheet has it own unique cell pointer.

A(n) ____ can consist of values, cell references, and cell ranges.

Describe how to enter data in an Excel worksheet.

The active cell is always highlighted in yellow.

The Enter button, which is a check mark icon, is on the ____.

In the accompanying figure, item 5 points to the ____.

In a worksheet, the boxes on the left containing numbers are known as ____ headings.

Double-clicking a column boundary automatically widens the column to fit the longest entry in the column using a feature called AutoComplete

All formulas must begin with a(n) ____.

A function needs information to make a calculation.This information is known as a(n) ____.

E44 is an example of a cell pointer , also called a cell address.