Exam 20: Creating Formulas and Charting Data

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

For help with choosing the appropriate chart for your data, use the _____ command.

The COUNT and SUM functions are interchangeable.

The ____ error occurs when the column is not wide enough or a negative date is entered.

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that the * (asterisk) character is used to represent ____.

The first step in building a chart is to decide what type of chart you want to create.

Using _____ is an easy method to apply formatting to data and convert the same data into a chart.

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

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

Rather than manually re-entering the values of a column or row, use the ____________________ feature to identify the most logical cells to add.

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.

All Excel formulas begin with ____.

A(n) ____________________ is a graphic representation of your worksheet data.

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

The ____ is a value, a cell reference, a range, or text used in a function.

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

A(n) ____________________ is a symbol that indicates the mathematical operation to perform.

Which of the following is NOT true about creating a function?

When creating formulas, there must be a closing parenthesis for every opening parenthesis.