Exam 12: Creating a Worksheet

It is possible to edit a label inside a cell, but to activate it first _____ the cell.

Functions can have _____ argument(s).

The default workbook contains a worksheet, titled Worksheet1 .

Referring to the accompanying figure, the _____ group contains the button used to paste a formula into a new cell.

A(n) range is a series of cells.

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

Any numerical data you do not intend to use in a calculation should be entered as a(n) label .

Microsoft Excel is text and data processing software and is not suited for working with formulas.

When using the standard mathematical order of operations _____ is/are performed last.

The Excel workspace is a grid of rows and columns.

The columns are typically labeled with _____.

All of the following are arithmetic operators used in Excel, except _____.

Using formulas is a basic part of Microsoft Excel. Please describe a formula and a cell reference and how they interact.

In addition to writing your own formulas, you can use predefined formulas called ____________________.

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied to cell C7, the relative references in the formula change to _____.

A collection of worksheets is called a(n) ____________________.

After you have pressed the Enter key, you cannot edit the value entered into the cell.

Labels are used only for worksheet or column titles.

Excel includes more than 250 functions from which you can choose.

A cell reference that changes when a formula is copied or moved is called a(n) ____________________ reference.