Exam 19: Creating Formulas and Charting Data

A ____ is used to separate cell references that are not adjacent.

____ are computer programs that are so necessary or desirable that they prove the core value of some larger technology, and as a result, they substantially increase the sales of the platform that they run on.

A(n) ____________________ cell reference does not change when the formula is copied or moved to a new location.

The 3-D reference enables you to access data from three different dimensions in the workbook: length, width, and ____________________.

____ are often used in summary worksheets to condense and total data from other worksheets.

Which of the following chart types does not have a horizontal and a vertical axis?

When a chart is created on the same sheet as the data used in the chart, it is embedded .

You can change the order of evaluation by using ____________________.

By default, when you create formulas, the cell references are formatted as ____.

Give an example of a mathematical and a statistical function. Explain the difference between mathematical and statistical functions.

All Excel formulas begin with ____.

To resize a chart proportionally, drag a ____ handle.

Mathematical functions perform calculations that you could perform using a scientific calculator.

FIGURE 19-1 What is the arrow pointing to in Figure 19-1 above?

____ is a mathematical function.

Formulas containing more than one operator are called ____.

Computers evaluate and assess worksheet values.

Generally, values are used in formulas rather than cell references.

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 wants to use only part of the data in a column chart. What should he do first?