To access Excel’s powerful data analysis tools you have to go to the Microsoft Web site and download various add-ins.

When you create worksheets that contain many calculations, you rarely need to create formulas that contain more than one mathematical operator.

When a formula contains multiple operators, Excel uses standard algebraic rules to determine which calculation to perform first.

In a formula, addition and subtraction are performed before multiplication and division.

Functions save time and help ensure accuracy, and they are available for both simple calculations and extremely complex ones.

Because the SUM function is so commonly used, it has its own button on both the Formulas tab and the Home tab.

Statistical functions are available in the Statistical category of the Function Library on the Formulas tab of the Ribbon.

Microsoft lets you access several preformatted Excel templates on the Web for dozens of common office forms, such as billing statements, invoices, and purchase orders.

When a worksheet contains a large amount of information, you might want to highlight certain cells that contain significant data points.

____ formulas perform more than one calculation at a time.

____ are prewritten formulas.

You can automatically ____ table data to display only the type of data you specify.

In a formula, calculations ____ are always evaluated first.

There are four parts to every function: ____.

____ are information a function needs to perform a task and can consist of values, cell references, or range references.

Anytime you type an equal sign followed by a letter, ____ produces a list of valid functions and names beginning with that letter.

The category of common worksheet functions that is used for simple and complex mathematical calculations is ____.

The category of common worksheet functions that is used for finding values in lists or tables or finding cell references is ____.

The category of common worksheet functions that is used for calculations that display a value if a condition is met is ____.

A ____ is a number in a sequential series of numbers.

The most popular statistical functions are ____.

____ is formatting that Excel automatically applies to cells when specified criteria are met.

____ are shading patterns that use two or three colors to show the relative values of a range of cells.

In the accompanying figure, item 1 points to the ____ button.

In the accompanying figure, item 2 points to the ____ Color Scales option.

In the accompanying figure, item 3 points to the ____ option.

Excel lets you analyze a separate range of worksheet data called a(n) ____, or rows and columns of data with a similar structure.

Excel table columns are often called ____.

If your Excel table contains a large amount of data, you might want to ____ it to display only the data you need.

When you tell Excel which pieces of information you want to see, you are specifying the ____ for your filter.