Excel Lessons 4-8 Review

You can include cell references in a formula more quickly by using the point and click method.

Some mathematical operations such as addition, subtraction, multiplication, and division, do not require functions.

Each formula begins with a quotation mark.

The formula =B5+C5 is an example of a____ operation.

_ are predesigned workbook files that you can use as the basis for new workbooks.

A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a __________________

When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is __.

_ graphics enhance worksheets by providing a visual representation of information and ideas.

Formulas can include more than one operator.

The formula = E6/4 is an example of a(n) _____ operation.

Embedded charts are useful when you want to print a chart next to the data the chart illustrate

You can switch between showing a formula and showing the formula result by using what keys?

When you no longer need a shape in a worksheet, you can delete it. First, click the object to select it. The press the

SmartArt graphics are often used for organizational charts, flowcharts, and decision trees.

The results of the calculation appear in the cell in which the formula is entered.

The sequence used to calculate the value of a formula.

A ___ is a reference in a worksheet that opens a file or page when you click it

When formulas with mixed cell references are copied, the row references preceded by a question mark do not change.

If a function contains more than one argument, semicolons separatethe arguments.

You can create hyperlinks to _.

Selecting data source for a chart, you should also include the text you want to use as labels

A pie chart shows the relationship of a part to a whole.

Three types of cell references is relative, absolute, and mixed.

Hiding permanently removed a row or column from view.

The SUM function that adds the numbers in the range D5:D17 is _________.

You can rename a chart sheet like any other worksheet. Right click its sheet tab, and then click ____________