Exam 12: Creating a Worksheet

Case 12-1 Peter is teaching his younger brother the basics of Microsoft Excel. Please answer the questions below. -Peter starts by describing that a worksheet will always consist of ____.

-In the figure above, to apply the formula =C2-C3, you would click the ____ key.

You can edit a formula after you've pressed the Enter key ____.

If the AutoSum button does not automatically select the correct cells, press the ____ key to remove the function and create the Sum function manually.

A ____ is the column and row location of a cell.

If you want to specifically enter a number as a label, you can type a(n) ____ before the Number.

Operations within ____ are completed first.

Case 12-1 Peter is teaching his younger brother the basics of Microsoft Excel. Please answer the questions below. -Peter then shows his brother how to select a ____, which is a series of cells.

A(n) ____________________ consists of a grid of columns and rows.

The Average function requires an argument consisting of a series of numbers or a series of cells.

-In the figure above, the current Sheet tab is ____.

With the Auto Fill Options button, you can fill the selection with ____.

A ____ specifies how to add, subtract, multiply, divide, or otherwise calculate the values in worksheet cells.

Formulas can include values, cell references, or both._________________________

A(n) ____________________ is a formula that references the cell in which the formula resides.

Commonly used functions, such as Sum, Average, Minimum, and Maximum, are located in the ____ category.

To start Excel, click Start, point to ____, click Microsoft Office, then click Microsoft Excel 2010.

Case 12-1 Peter is teaching his younger brother the basics of Microsoft Excel. Please answer the questions below. -Peter explains that a ____ contains one or more worksheets.

A(n) ____________________ is any text entered into a cell of the worksheet.

Excel includes many ____________________ functions such as average and normal distribution.