Mlcak Microsoft Excel Ch 2 & 3

Excel Vocabulary Ch 2 & 3

Conditional formatting

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

visualize data

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

Conditional formatting

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

visualize data

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

Number formats

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

rule

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

general

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

function

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

Microsoft Excel

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.

arguments

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.

calculate

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

calculator

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

formulas

Excel uses cell references to create simple _.

cell references

Excel uses ____ to create simple formulas.

Flash Fill

_ is an Excel feature that looks for patterns in the data and automatically fills or formats your data in remaining cells.

automatically

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

Fill Handle

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

Source Area

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

Destination Area

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

Goal Seek

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

What-if Analysis or Sensitivity analysis

_ uses Excel to scrutinize the impact of changing values in cells that are referenced by a formula. This feature can help you experiment and answer questions with your data, even when the data is incomplete.

Find / Replace

You can easily search your workbook for specific information using the __ feature. This also allows you to modify content using the _ feature.

specific

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

mathematical

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

algebra

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

circular reference

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

left to right

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

Trace Error

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

MIN

The _____ function is used to determine the smallest value in a range.

AVERAGE

The _____ function is used to calculate the average of values in a range.

MAX

The _____ function is used to determine the largest value in a range.

Range Finder

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

Accounting number

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.

Currency style

The _ format displays a floating dollar sign that appears immediately to the left of the first digit with no spaces.

F7

You can check the spelling of your worksheet by pressing the _____ key.

Normal view

What is the default view for working in an Excel spreadsheet?

header

A(n) _____ is text and graphics that prints at the top of each page of a worksheet.

Press CTRL+` (ACCENT MARK)

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

Dollar sign ($)

What symbol is used to indicate an absolute or mixed cell reference?

absolute

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

mixed

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

relative

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

parenthesis

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

CTRL

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

Move or Copy

To move a worksheet, and click _ on shortcut menu.

Split

To split the view of a worksheet into panes, you can click the _ button (VIEW tab | Window group).