# Study sets matching "computer chapter 2 excel"

Study sets

Diagrams

Classes

Users

Columns

Rows

Relative Cell Reference

Absolute Cell Reference

Go up and down; labeled with letters starting at A from the le…

Go sideways; labeled with numbers starting at 1 from the top

Use when important to preserve relationship to the formula loc…

Use to preserve the exact cell address in the formula; should…

Columns

Go up and down; labeled with letters starting at A from the le…

Rows

Go sideways; labeled with numbers starting at 1 from the top

Columns

Rows

Relative Cell Reference

Absolute Cell Reference

Go up and down; labeled with letters starting at A from the le…

Go sideways; labeled with numbers starting at 1 from the top

Use when important to preserve relationship to the formula loc…

Use to preserve the exact cell address in the formula; should…

Columns

Go up and down; labeled with letters starting at A from the le…

Rows

Go sideways; labeled with numbers starting at 1 from the top

Scaling

Panes

Top/bottom rules

Criterion

Reducing or enlarging worksheet information to fit on a specia…

Sections or areas in a window that enable you to see different…

Conditional formatting rules that format the highest or lowest…

A value, some text, or an expression that defines the type of…

Scaling

Reducing or enlarging worksheet information to fit on a specia…

Panes

Sections or areas in a window that enable you to see different…

Fixed Dollar Sign

Arugments

Average Function

Comma Style

Dollar sign is as far left of cell with space between the sign…

Values used with a function.

Sum of a range of numbers divided by number of cells in the ra…

Inserts a comma every three positions. Rounds to the nearest h…

Fixed Dollar Sign

Dollar sign is as far left of cell with space between the sign…

Arugments

Values used with a function.

Function

Formula

Order of operations

Point mode

A pre-written formula that is built into Excel

A mathematical expression that Excel uses to calculate a result

Formulas are read from left to right in this order: (1) negati…

Allows you to select cells for use in a formula by using the m…

Function

A pre-written formula that is built into Excel

Formula

A mathematical expression that Excel uses to calculate a result

A ____ is a prewritten formula that is…

To start a new line in a cell, press th…

When you enter a two-digit year that is…

A(n) ____ circular reference occurs whe…

function

ALT+ENTER

20xx

indirect

A ____ is a prewritten formula that is…

function

To start a new line in a cell, press th…

ALT+ENTER

When you cut and paste a cell containin…

Which paste option pastes formulas and…

To split a cell into two cells _____.... a…

To apply the Double Accounting underlin…

a) updates the cell reference to the new location

d) Formulas & Number Formatting

d) you cannot split a cell into two cell; you can only unmerge…

b) in the Font dialog, on the Font tab, expand the underline l…

When you cut and paste a cell containin…

a) updates the cell reference to the new location

Which paste option pastes formulas and…

d) Formulas & Number Formatting

A ____ is a prewritten formula that is…

To start a new line in a cell, press th…

When you enter a two-digit year that is…

A(n) ____ circular reference occurs whe…

function

ALT+ENTER

20xx

indirect

A ____ is a prewritten formula that is…

function

To start a new line in a cell, press th…

ALT+ENTER

Copy

Paste

Formula bar

Selecting text

Takes information from one location and duplicates it

Put the information from copy to another location

Make changes directly in the cell or edit the contents of a ce…

You hughlight the text that is to be changed

Copy

Takes information from one location and duplicates it

Paste

Put the information from copy to another location

Clipboard

Ctrl + E

dotted lines

#

The ? is the temporary storage location for cell contents copi…

What is the keyboard shortcut for flash fill?

When formatting a worksheet to be printed, ? show where page b…

Which symbols does Excel use to indicate that a cell is not wi…

Clipboard

The ? is the temporary storage location for cell contents copi…

Ctrl + E

What is the keyboard shortcut for flash fill?

true

false

false

true

Because the most common error when entering a formula is to re…

In the formula =4*6-8, the subtraction (-) operation is comple…

The order of Operations is from the right to left.

When a error occurs in a formula cell, Excel displays the Trac…

true

Because the most common error when entering a formula is to re…

false

In the formula =4*6-8, the subtraction (-) operation is comple…

Function formula

sum(sum), minimum(min), maximum(max), a…

341 function formulas

range

formula containing a word to perform predetermined calculation…

examples of function formulas

Excel has how many functions built into the program?

function formulas generally contain a what of cells?

Function formula

formula containing a word to perform predetermined calculation…

sum(sum), minimum(min), maximum(max), a…

examples of function formulas

A command with which you can display te…

A cell reference that refers to a cell…

Rules that specify the way numbers shou…

The Default value applied to numbers

Text Wrap

Absolute Cell Reference

Number Format

General Format

A command with which you can display te…

Text Wrap

A cell reference that refers to a cell…

Absolute Cell Reference

AVERAGE Function

Arguments

Comparison Operators

Conditional format

An Excel function that adds a group of values, and then divide…

The values that an Excel function uses to perform calculations…

Symbols that evaluate each value to determine if it is the sam…

A format that changes the appearance of a cell - for example,…

AVERAGE Function

An Excel function that adds a group of values, and then divide…

Arguments

The values that an Excel function uses to perform calculations…

AVERAGE Function

Conditional format

COUNT

COUNTIF Function

An Excel function that adds a group of values, and then divide…

A format that changes the appearance of a cell - for example,…

A statistical function that counts the number of cells in a ra…

A statistical function that counts the number of cells within…

AVERAGE Function

An Excel function that adds a group of values, and then divide…

Conditional format

A format that changes the appearance of a cell - for example,…

USB

Cooling Fan

Hard Drive

Optical Disk Drive

The most popular external connection

keeps computer cool

Allows you to store information and applications directly to y…

Digital versatile disk, compact disk, rewritable disk... A periph…

USB

The most popular external connection

Cooling Fan

keeps computer cool

arguments

AVERAGE function

comparison operators

conditional format

the values that an excel function uses to perform calculations…

an excel function that adds a group of values, and then divide…

symbols that evaluate each value to determine if it's the same…

a format that changes the appearance of a cell- for example, b…

arguments

the values that an excel function uses to perform calculations…

AVERAGE function

an excel function that adds a group of values, and then divide…

flashfill

circular reference

direct circular reference

indirect circular reference

is an excel feature that looks for patterns in the data and au…

A formula in a cell that contains a reference back to itself.

occurs when a formula refers to the same cell in which it is e…

occurs when a formula in a cell refers to another cell or cell…

flashfill

is an excel feature that looks for patterns in the data and au…

circular reference

A formula in a cell that contains a reference back to itself.

AVERAGE Function

Conditional format

COUNT

COUNTIF Function

An Excel function that adds a group of values, and then divide…

A format that changes the appearance of a cell - for example,…

A statistical function that counts the number of cells in a ra…

A statistical function that counts the number of cells within…

AVERAGE Function

An Excel function that adds a group of values, and then divide…

Conditional format

A format that changes the appearance of a cell - for example,…

Source Range

Destination Range

Flash Fill

Formula

Term used to refer to a range being used as a source.

Term used to refer to a range being used as a destination.

Excel feature that looks for patterns in the data and automati…

Cell references, numbers, and arithmetic operators that instru…

Source Range

Term used to refer to a range being used as a source.

Destination Range

Term used to refer to a range being used as a destination.

Auto Fill

Auto Complete

Copy

Copy Pointer

An Excel feature that automatically fill cells with data, form…

An Excel feature that automatically enters the remaining chara…

To duplicate data from a worksheet to the Clipboard.

A mouse pointer, resembling an arrow with a plus sign, that al…

Auto Fill

An Excel feature that automatically fill cells with data, form…

Auto Complete

An Excel feature that automatically enters the remaining chara…

Auto fill

Auto complete

Copy

Copy pointer

Options that automatically fill cells with data and/or formatt…

...

Takes the information from one location and duplicates it.

Arrow with a plus that you can drag the cell or range of cells…

Auto fill

Options that automatically fill cells with data and/or formatt…

Auto complete

...

absolute location

autofit

argument

chart

cell locations that do not change when copied in a formula

change column width to match entries

the values that a function uses

representation of numeric data in graphic form

absolute location

cell locations that do not change when copied in a formula

autofit

change column width to match entries

Formula Bar

Status Bar

Name Box

Workbook

Appears directly below the toolbar in the worksheet; displays…

displays information about the current document

displays the active cell address

an excel file with one or more worksheets

Formula Bar

Appears directly below the toolbar in the worksheet; displays…

Status Bar

displays information about the current document