Excel Chapter 2

To change the order of operations in a formula, put _____ around the part of the formula to be calculated first.

To copy a formula to other cells using the Fill button, you should begin by selecting which of the following?

Which of the following characters does Excel use to represent the mathematical operator for division?

The Trace Error button displays with a(n) _____ inside a diamond.

When writing a formula by pointing at the desired cell references, end the formula by pressing the _____ key.

Use the _____ function to count the numeric values in a range.

By default, which of the following displays in the Select a function list box in the Insert Function dialog box?

In the formula =SUM(A10:A15), the beginning section, =SUM, is called a(n)

To copy data or formulas using the fill handle, first position the mouse pointer on the fill handle until it turns into

To use the Formula AutoComplete feature, click in the desired cell, type the equals sign, and then

The phrase _____ is used to describe when a value calculated by a formula is inserted in a cell.

Which of the following errorcodes will display in a cell when an argument parameter doesnt meet a functions requirements

When writing a formula, always begin it with

Use the _____ function to count the cells in a range containing any characters.

Which of the following is not one of the categories in the Function Library group on the Formulas tab?

Which of the following characters does Excel use to represent the mathematical operator for multiplication?

In the formula =SUM(A4:A17), the cell range (A4:A17) is an example of a(n)

The AVERAGE function will ignore text in cells and