Exam 5: Creating a Worksheet

The default workbook contains a worksheet, titled Worksheet1 .

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

After you click a cell for a formula, a rectangle of _____ called a marquee appears around that cell.

A cell located in the third row and forth column is named _____.

Which of the following functions calculates the total of a column or row of cells?

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

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

Which of the following buttons on the formula bar should you click to complete your entry?

The Function Arguments dialog box contains a link, _____, that you should click to get help with the arguments.

Which of the following refers to Column B, Row 2 on the worksheet called Sheet2?

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When it is copied and pasted into cell C8, why do the hash marks appear?

If the label is too long to fit in the current cell and the cells on the right are not empty, _____.

Which of the following is a correct name for the function that calculates an average of values?

To create an absolute reference, insert a pound sign (#) before the column reference and another pound sign before the row reference.

A worksheet ____________________ is the rectangle formed by the intersection of a column and row.

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

The default workbook contains _____ worksheets.

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

The ____________________ cell is the cell you can currently edit or modify.

To edit a label after the Enter key has been pressed, you should first click the cell, then click in the _____, type your correction, then press the Enter key to complete your entry.