#### Study sets matching "applications spreadsheet"

#### Study sets matching "applications spreadsheet"

Sort

SUM function

Importing Data

Text File

The process of arranging records by the value of one or more…

Totals the values in two or more cells and displays the resul…

Process of inserting external data created or stored in anoth…

A data file containing characters such as letter, numbers, an…

Sort

The process of arranging records by the value of one or more…

SUM function

Totals the values in two or more cells and displays the resul…

Cell

Formula

Centered align

Absolute cell reference

A cell is the intersection of a column and a row on a workshe…

a simple math equation, used to calculate spreadsheet values

All text lined up equally (in the middle)

the contents of the cell does not change when copied when or…

Cell

A cell is the intersection of a column and a row on a workshe…

Formula

a simple math equation, used to calculate spreadsheet values

100% stack column chart

Axis title

Bar chart

Category values

A column chart that places the data series values within comb…

Descriptive text that appears next to an axis

A column chart turned on its side so that the length of each…

The groups or categories that a series values belong to

100% stack column chart

A column chart that places the data series values within comb…

Axis title

Descriptive text that appears next to an axis

Sort

SUM function

Importing Data

Text File

The process of arranging records by the value of one or more…

Totals the values in two or more cells and displays the resul…

Process of inserting external data created or stored in anoth…

A data file containing characters such as letter, numbers, an…

Sort

The process of arranging records by the value of one or more…

SUM function

Totals the values in two or more cells and displays the resul…

Cell

Formula

Centered align

Absolute cell reference

A cell is the intersection of a column and a row on a workshe…

a simple math equation, used to calculate spreadsheet values

All text lined up equally (in the middle)

the contents of the cell does not change when copied when or…

Cell

A cell is the intersection of a column and a row on a workshe…

Formula

a simple math equation, used to calculate spreadsheet values

100% stack column chart

Axis title

Bar chart

Category values

A column chart that places the data series values within comb…

Descriptive text that appears next to an axis

A column chart turned on its side so that the length of each…

The groups or categories that a series values belong to

100% stack column chart

A column chart that places the data series values within comb…

Axis title

Descriptive text that appears next to an axis

Active cell

Auto Fill

Average function formula

Bar Chart

Refers to the currently selected cell in a spreadsheet

A computer software that lets you enter a series of numbers o…

Receives a range of cells, and returns the average of all the…

A chart with rectangular bars and lengths proportional to the…

Active cell

Refers to the currently selected cell in a spreadsheet

Auto Fill

A computer software that lets you enter a series of numbers o…

Active cell-

Auto fill-

Average function

Bar chart

The selected cell in which data is entered when you begin typ…

automatically fills in cells with common series ( numbers mon…

formula receives a range of cells and returns the average of…

- a chart with rectangular bars with lengths proportional to…

Active cell-

The selected cell in which data is entered when you begin typ…

Auto fill-

automatically fills in cells with common series ( numbers mon…

Active Cell

Auto Fill

Average function formula

Bar chart

The selected cell in which data is entered when you begin typ…

Automatically fills in cells with common series (numbers, mon…

Receives a range of cells, and returns the average of all the…

A chart with rectangular bars with lengths proportional to th…

Active Cell

The selected cell in which data is entered when you begin typ…

Auto Fill

Automatically fills in cells with common series (numbers, mon…

Activate

Active cell

Active sheet

Argument

to make a chart sheet or worksheet the active, or selected, s…

the selected cell in which data is entered when you begin typ…

the sheet that you're working on in a workbook. The name on t…

the values that a function uses to perform operations or calc…

Activate

to make a chart sheet or worksheet the active, or selected, s…

Active cell

the selected cell in which data is entered when you begin typ…

Active Cell

AutoFill

Average function formula

Bar chart

The selected cell in which data is entered when you begin typ…

Automatically fill in cells with common series (numbers, moth…

Receives a range of cells, and returns the average of all the…

A chart with rectangular bar with lengths proportional to the…

Active Cell

The selected cell in which data is entered when you begin typ…

AutoFill

Automatically fill in cells with common series (numbers, moth…

NPER

VLookup

HLookup

Shift

Get the number of periods for an investment.... =NPER (rate, pm…

=VLOOKUP(Value you want to look up, range where you want to l…

=HLOOKUP(lookup_value, table_array, row_index_num, [range_loo…

Shift press and hold ____ and drag Obj. to keep proportions

NPER

Get the number of periods for an investment.... =NPER (rate, pm…

VLookup

=VLOOKUP(Value you want to look up, range where you want to l…

Spreadsheet

Spreadsheet Function

SUM Function

Worksheet

A software program that allows you to perform various calcula…

A built in formula in a spreadsheet.

A built in spreadsheet formula that adds a range of cells.

A spreadsheet form that enables you to input data and formulas.

Spreadsheet

A software program that allows you to perform various calcula…

Spreadsheet Function

A built in formula in a spreadsheet.

NPER

VLookup

HLookup

Shift

Get the number of periods for an investment.... =NPER (rate, pm…

=VLOOKUP(Value you want to look up, range where you want to l…

=HLOOKUP(lookup_value, table_array, row_index_num, [range_loo…

Shift press and hold ____ and drag Obj. to keep proportions

NPER

Get the number of periods for an investment.... =NPER (rate, pm…

VLookup

=VLOOKUP(Value you want to look up, range where you want to l…

auto fill

average function formula

bar chart

cell

automatically fills in cells with common series

receives a range of cells, and returns the average of all the…

a chart with rectangular bars with lengths proportional to th…

a box formed by the intersection of a row and column in a wor…

auto fill

automatically fills in cells with common series

average function formula

receives a range of cells, and returns the average of all the…

Active Cell

AutoFill

Average function formula

Bar chart

The selected cell in which data is entered when you begin typ…

Automatically fill in cells with common series (numbers, moth…

Receives a range of cells, and returns the average of all the…

A chart with rectangular bar with lengths proportional to the…

Active Cell

The selected cell in which data is entered when you begin typ…

AutoFill

Automatically fill in cells with common series (numbers, moth…

Active cell

Auto fill

Average function formula

Bar chart

The selected cell in which data is entered when you begin typ…

Automatically fills in cells with common series (numbers, mon…

Receives a range of cells, and returns the average of all the…

A chart with rectangular bars with lengths proportional to th…

Active cell

The selected cell in which data is entered when you begin typ…

Auto fill

Automatically fills in cells with common series (numbers, mon…

One way to ensure that correct data is…

The following are Excel-supported erro…

Comments like those in the accompanyin…

Case-Based Critical Thinking Questions…

validation

Stop, Warning, and Information

All of the above

the workbook was sent to him without links

One way to ensure that correct data is…

validation

The following are Excel-supported erro…

Stop, Warning, and Information

Active Cell

Auto Fill

Average Function Formula

Bar Chart

The selected cell in which data is entered when you begin typ…

Automatically fills in cells with common series (Numbers, mon…

Receives a range of cells, and returns the average of all the…

A chart with rectangular bars with lengths proportional to th…

Active Cell

The selected cell in which data is entered when you begin typ…

Auto Fill

Automatically fills in cells with common series (Numbers, mon…

ACTIVE CELL

AUTO FILL

AVERAGE FUNCTION FORMULA

BAR CHART

The selected cell in which data is entered when you begin typ…

Automatically fills in cells with common series (numbers, mon…

Receives a range of cells and returns the average of all the…

A chart with rectangular bars with lengths proportional to th…

ACTIVE CELL

The selected cell in which data is entered when you begin typ…

AUTO FILL

Automatically fills in cells with common series (numbers, mon…

Active cell

AutoFill

Average function formula

Bar chart

Active cell refers to the currently selected cell in a spread…

Is a function in some computer applications or programs, typi…

Formulas are what helped make spreadsheets so popular.

A graphic representation of data.

Active cell

Active cell refers to the currently selected cell in a spread…

AutoFill

Is a function in some computer applications or programs, typi…

Active Cell

Auto Fill

Average Function Formula

Bar Chart

the selected cell in which data is entered when you begin typ…

automatically fills in cells with common series (numbers, mon…

receives a range of cells, and returns the average of all the…

a chart with rectangular bars with lengths proportional to th…

Active Cell

the selected cell in which data is entered when you begin typ…

Auto Fill

automatically fills in cells with common series (numbers, mon…