Exam 12: Creating a Worksheet

The argument for the Sum function is typically a range or a series of adjacent cells._________________________

A(n) ____________________ consists of values or cell references used to calculate the result of the function.

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

If you don't use parentheses, Excel calculates the result using the standard mathematical order of operations with ____ first.

If a label is too long to fit in the current cell, it extends into the cells to the left if they are empty.

Excel worksheets are saved in a(n) ____________________.

You can use ____ for a worksheet title, to describe the numbers you've entered in other cells, and for text data, such as the names of people or cities.

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

The inactive cell is the cell you can currently edit or modify, and it is marked with a black outline._________________________

AutoSum works best if every cell in the row or column of cells contains a ____.

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

When you complete the Average function, the result is calculated as an average of the values in the ____.

For the PMT function, you have to divide the annual interest rate by ____ if you're using monthly payments.

To edit a label after you've pressed the Enter key, click the cell, then click in the task bar._________________________

A(n) loop is a series of cells._________________________

Use the ____ button to quickly create a function to calculate the total of a column or row of cells.

Microsoft Word is the component of the Microsoft Office suite best suited for working with numbers and formulas.

Excel includes many ____________________ functions such as payments and net present value, and mathematical and trigonometric functions such as absolute value and arctangent.

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

The easiest way to create a formula is to use the ____ method.