Exam 19: Creating Formulas and Charting Data

Case 19-2 Pablo works as an assistant at a local art gallery. He is completing a worksheet that shows sales for the previous year. Now he wants to create a chart to represent the data. Pablo decides a bar chart would illustrate the data more effectively. Which button will enable him to choose a new chart?

Excel has more than 300 built-in formulas for performing calculations.

Which type of cell reference adjusts automatically when copied to another cell?

The sequence used to calculate the value of a formula is called the ____.

The equation used to calculate values in a cell is known as a ____________________.

Which formula will produce a result of 48?

FIGURE 19-2 Which part of the function formula shown in Figure 19-2 above is the argument?

The operator is a number or cell reference.

A + (plus sign) is an example of an operator.

Many parts of a chart are positioned on the chart in a text box.

If you input an incorrect formula, or if you input invalid data, the formula produces a false result--often referred to as ____.

Case 19-1 Macy is the treasurer for a professional organization, and she is compiling the financial data to present to the board members at the next meeting. Macy sees the error #NULL! in a cell of her worksheet. What is likely the problem?

To create an absolute cell reference, you insert an equal sign (=) before the column letter and/or row number of the cell reference you want to stay the same.

A formula consists of two components: an operand and an operator.

In business, upper-level management relies on charts to look for trends and oddities.

A(n) ____ is a special formula that names a function instead of using operators to calculate a result.

Case 19-1 Macy is the treasurer for a professional organization, and she is compiling the financial data to present to the board members at the next meeting. Macy wants to show the organization's total dollar amount of dues collected in the cells B2 to B40. Which is the correct formula?

A shortcut for entering cell references is to ____.

The ____________________ is a value, a cell reference, a range, or text that acts as an operand in a function formula, and it is enclosed in parentheses after the function name.

When you edit the data in a worksheet, you must edit the data in the chart as well.