# 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

Argument

AutoCalculate

Formula AutoComplete

Function

The values and other inputs that a functions uses to calculate…

A featuare that temporary preforms the fallowing calculations…

A feature that speeds up the manually entry of funtions

A predefined formula that performs a specific calculation usin…

Argument

The values and other inputs that a functions uses to calculate…

AutoCalculate

A featuare that temporary preforms the fallowing calculations…

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.

MIN

MAX

Valid Arithmetic Operators

Point mode

Function that determines the lowest number in a range.

Function that determines the highest number in a range.

- % ^ * / +

When you select cells for use in a formula by using the mouse…

MIN

Function that determines the lowest number in a range.

MAX

Function that determines the highest number in a range.

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

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

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

Print titles

Find and Replace

Excel Table

Statistical Function

Command that enables you to specify rows and columns to repeat…

Command that searches the cells in a worksheet-or selected ran…

Series of rows and columns that contains related data that is…

Used to analyze a group of measurements

Print titles

Command that enables you to specify rows and columns to repeat…

Find and Replace

Command that searches the cells in a worksheet-or selected ran…

True

False

False

True

A requirements document includes a needs statement, source of…

Worksheet titles and subtitles should be as wordy as possible

A thin red border indicates the active cell, as shown in the a…

Both the Cancel Box and the Enter Box appear on the formula ba…

True

A requirements document includes a needs statement, source of…

False

Worksheet titles and subtitles should be as wordy as possible

copy

cut

fill handle

formula bar

takes the information from one location and duplicates it

removing data from a worksheet, but it is still located on the…

a small square in the lower-right corner of a selected cell

place between ribbon and worksheet where you can make changes…

copy

takes the information from one location and duplicates it

cut

removing data from a worksheet, but it is still located on the…

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…

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…

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,…

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,…

accounting number format

Addition

arguments

arithmetic operators

With the dollar sign to the left, inserts a comma every three…

Arithmetic operator that adds contents of cells: indicated usi…

The values that are used with a function

addition, subtraction, multiplication and division

accounting number format

With the dollar sign to the left, inserts a comma every three…

Addition

Arithmetic operator that adds contents of cells: indicated usi…

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

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

Conditional Formatting

Formulas Version

Accounting Number Format

Comma Style Format

Excel lets you apply formatting that appears only when the val…

Shows the actual formulas you have entered, rather than the re…

Has a dollar sign to the left of the number, inserts a comma e…

Can be assigned to a range of cells by clicking the Comma Styl…

Conditional Formatting

Excel lets you apply formatting that appears only when the val…

Formulas Version

Shows the actual formulas you have entered, rather than the re…

Argument

AutoCalculate

Formula AutoComplete

Functions

The values and other unputs that a function uses to calculate…

A feature that temporarily performs the following calculations…

A feature that speeds up the manual entry of functions.

a predefind formula that performs a specific calculation using…

Argument

The values and other unputs that a function uses to calculate…

AutoCalculate

A feature that temporarily performs the following calculations…

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

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 is the sam…

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…

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

...

argument

function

nest

4. structured references

a value used by a function to calculate a result; Example: in…

a predefined formula that calculates using your inputs (e.g.,…

to use a function as an argument within another function.

using the table name or table column header in a formula to re…

argument

a value used by a function to calculate a result; Example: in…

function

a predefined formula that calculates using your inputs (e.g.,…

The adjusted cell references in a copie…

The default view in Excel is called ___…

To print a range of cells in the active…

The ____ AutoComplete list contains tho…

relative

Normal

Print Selection

Formula

The adjusted cell references in a copie…

relative

The default view in Excel is called ___…

Normal