Similar to charts, conditional formatting provides another way to _______________ and make worksheets easier to understand.

___________________ tell your spreadsheet exactly what type of data you're using, like percentages (%), currency ($), accounting, times, dates, and so on.

To apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value, you'll need to create a ____________________________.

The default number format for cells in a spreadsheet is _________________.

A ___________________ is a predefined formula that performs calculations using specific values in a particular order.

______________ includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

In order to use functions correctly, you'll need to understand the different parts of a function and how to create ______________________ to calculate values and cell references.

One of the most powerful features in Excel is the ability to ________________ numerical information using formulas.

Just like a _____________________, Excel spreadsheets can add, subtract, multiply, and divide.

Excel uses cell references to create simple _______________________.

Excel uses __________________ to create simple formulas.

_____________________ automatically fills your data when it senses a pattern.

Flash Fill can enter data ____________________into your worksheet, saving you time and effort.

Just like the _________________, Flash Fill can guess what type of information you're entering into your worksheet.

The cell whose content is being copied is the _________________ area.

The cell or range of cells into which the content is pasted is the ______________________ area.

This feature can help you experiment and answer questions with your data, even when the data is incomplete.

Whenever you create a formula or function in Excel, you put various parts together to calculate a result. _________________ works in the opposite way: It lets you start with the desired result, and it calculates the input value that will give you that result.

You can easily search your workbook for specific information using the __________ feature. , which also allows you to modify content using the _______________ feature.

When working with a lot of data in Excel, it can be difficult and time consuming to locate _______________ information.

Excel includes many powerful tools to perform complex ______________________ calculations, including what-if analysis tools such as Goal Seek.

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of operations that you use in _____.

Excel reads a formula from _____ and performs each calculation following a strict order of operations.

The _____ option button selection lists error-checking options following the assignment of an invalid formula to a cell.

You can use _____ to verify the cell references contained in a formula.

The _____ format displays numbers with a fixed dollar sign to the far left of the number with spaces between the dollar sign and the first digit in the cell.

To assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, apply the _____ format.

How do you use the keyboard to toggle between the values version and the formulas version of a worksheet?

To select nonadjacent ranges, you should use the _____ key.

In accounting, negative numbers often are shown with _____ around the negative value.

A(n) _____ is created by a formula that contains a reference to the cell that contains the formula.

The formula argument (E9-F9) contains a(n) _____ references.

The formula argument (C$8/D8) contains a(n) _____ reference in the first value.

The formula argument ($B$4 *D4) contains a(n) _____ reference in the first value.