Mlcak Microsoft EXCEL Ch 2 & Ch 3

___________________ allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value.

• Conditional formatting

• Number formats

• arguments

• Flash Fill

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

• visualize data

• Number formats

• calculate data

• Flash Fill

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

• visualize data

• Number formats

• calculate data

• Flash Fill

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 ____________________________.

• What if Analysis

• function

• conditional formatting rule

• Find / Replace

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

• General

• Percent

• Mathematical

• Currency

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

• What if Analysis

• function

• conditional formatting rule

• Find / Replace

______________ 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.

• Microsoft Word

• Microsoft Excel

• Microsoft PowerPoint

• Microsoft Access

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.

• Conditional formatting

• Number formats

• arguments

• Flash Fill

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

• visualize

• format

• calculate

• Flash Fill

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

• table

• calculator

• chart

• textbook