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.

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