Exam 12: Creating a Worksheet

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

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

Excel calculates results using the standard mathematical order of operations, referred to as mathematical priority .

The active cell is the cell you can currently edit or modify, and it is marked with a(n) black outline.

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

Case-Based Critical Thinking Questions Case 12-1 Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions. Ethan then shows James how to select a(n) _____, which is a series of cells.

Case-Based Critical Thinking Questions Case 12-1 Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions. Ethan explains that a _____ contains one or more worksheets.

Values and labels can be entered automatically using the fill handle and a technique called _____.

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

It is important to distinguish between a value and a label when entering information into an Excel worksheet. Please describe both a label and a value.

Cell references used in formulas can lead to unexpected results when you copy or move the formulas.

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

If the cell references should not be modified when moved to a new location, you should use a(n) relative reference.

Referring to the accompanying figure, the active cell is cell _____.

The active cell is marked with a _____ outline.