Exam 20: Creating Formulas and Charting Data

A(n) embedded chart is created on the same sheet as the data used in the chart.

To create a minus sign in a formula, use the hyphen key.

= SUM tallies the number of cells with values in the specified range.

An error value appears if the cell is not wide enough to show the result.

The accompanying figure shows ____ in column F.

Rajit wants to display the data in his worksheet using graphics. Rajit decides to show snapshots of the data for each row in his worksheet. He inserts ____.

What is the difference between a function and a formula? List two types of functions available in Excel. Describe how you would use the following functions: SUM, AVERAGE, COUNT, and MIN.

The ____ error occurs when the wrong type of argument or operand is used.

Using the ____________________ feature, Excel scans the worksheet and identifies the most logical column or row of adjacent cells containing numbers to add.

The equation used to calculate values in a cell is known as a(n) function .

Which of the following is NOT true about charts?

Formulas containing more than one operator are called ____________________ formulas.

A cell reference that contains both relative and absolute references is called a(n) mixed cell reference.

A(n) ____ cell reference does not change when the formula is copied or moved.

The ____ error occurs when the contents of cells referred to by other formulas are deleted.

____ refers to the ability to connect worksheets by creating formulas that reference the same cell or range in multiple worksheets.

All Excel formulas begin with ____.

You can create multiple sparklines at the same time.