# Study sets matching "computer applications spreadsheet"

Study sets

Diagrams

Classes

Users

Cell

Column

Row

Spreadsheet

the intersection between a row and a column on a spreadsheet

the vertical series of cells on a spreadsheet

the horizontal series of cells on a spreadsheet

an electronic file made from rows and columns that contain for…

Cell

the intersection between a row and a column on a spreadsheet

Column

the vertical series of cells on a spreadsheet

Active cell

Alignment

AutoFormat Handle

Average

Selected worksheet cell that is ready for data entry

the way text is positioned between margins

dot at bottom right of each cell; used to copy information (in…

function that adds the values of cells in a range and divides…

Active cell

Selected worksheet cell that is ready for data entry

Alignment

the way text is positioned between margins

Sort

SUM function

Importing Data

Text File

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

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

Process of inserting external data created or stored in anothe…

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

Sort

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

SUM function

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

Absolute Cell Reference

Active Cell

Alignment

Argument

Cell reference that does not adjust to the new cell location w…

A selected worksheet cell that is ready for data entry

The position of data within a cell

Value, cell reference, range, or text that acts as an operand…

Absolute Cell Reference

Cell reference that does not adjust to the new cell location w…

Active Cell

A selected worksheet cell that is ready for data entry

Cell

Formula

Centered align

Absolute cell reference

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

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

Cell

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

Formula

a simple math equation, used to calculate spreadsheet values

Sumif (range of cells, criteria)

Countif (range of cells, criteria)

If Function

Vlookup

This function adds numbers that have the same value

Counts the number of cells that share the same criteria

=(condition, if true, if false)

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

Sumif (range of cells, criteria)

This function adds numbers that have the same value

Countif (range of cells, criteria)

Counts the number of cells that share the same criteria

Sort

SUM function

Importing Data

Text File

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

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

Process of inserting external data created or stored in anothe…

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

Sort

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

SUM function

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

Active cell-

Auto fill-

Average function

Bar chart

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

automatically fills in cells with common series ( numbers mont…

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

- a chart with rectangular bars with lengths proportional to t…

Active cell-

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

Auto fill-

automatically fills in cells with common series ( numbers mont…

Spreadsheet

Worksheets

Work book

Row

A tool used to •organize and analyze info•; a row and column a…

In Excel, you work with worksheets which consists of •rows and…

Excel spreadsheet which, by default, •contains three worksheet…

• A horizontal group of cells• in a worksheet or spreadsheet... a…

Spreadsheet

A tool used to •organize and analyze info•; a row and column a…

Worksheets

In Excel, you work with worksheets which consists of •rows and…

Cell

Formula

Centered align

Absolute cell reference

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

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

Cell

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

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

Descriptive text that appears next to an axis

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

The groups or categories that a series values belong to

100% stack column chart

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

Axis title

Descriptive text that appears next to an axis

Tool used to organize and analyze infor…

Consist of rows and columns that can in…

Spreadsheet which by default, contains…

Horizontal group of cells (1048 of thes…

Spreadsheet

Worksheet

Workbook

Rows

Tool used to organize and analyze infor…

Spreadsheet

Consist of rows and columns that can in…

Worksheet

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

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

Active Cell

Auto Fill

Average function formula

Bar chart

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

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

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

A chart with rectangular bars with lengths proportional to the…

Active Cell

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

Auto Fill

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

button (el boton)

wireless (inalambrico)

window (la ventana)

website (plural los webs)

microswitch on a computer mouse which can be pressed to select…

broadcasting, computer networking, or other communication usin…

in computing, a window is a visual area containing some kind o…

a site that the owner positions as an entrance to other sites…

button (el boton)

microswitch on a computer mouse which can be pressed to select…

wireless (inalambrico)

broadcasting, computer networking, or other communication usin…

Activate

Active cell

Active sheet

Argument

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

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

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

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

Activate

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

Active cell

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

Active Cell

AutoFill

Average function formula

Bar chart

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

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

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

AutoFill

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

NPER

VLookup

HLookup

Shift

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

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

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

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

NPER

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

VLookup

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

Excel

Ribbon

Workbook

Quick Access Toolbar

a spreadsheet program that allows you to store, organize, and…

Contains multiple Tabs, each with several groups of commands

Each workbook holds one or more worksheets (also known as spre…

located above the Ribbon and it lets you access common command…

Excel

a spreadsheet program that allows you to store, organize, and…

Ribbon

Contains multiple Tabs, each with several groups of commands

Spreadsheet

Microsoft Excel

Workbook

Labels

is a computer software that helps you organize and process mat…

one of the most popular spreadsheet.

an excel document. is a collection of one or more worksheets.

what words are called in spreadsheets

Spreadsheet

is a computer software that helps you organize and process mat…

Microsoft Excel

one of the most popular spreadsheet.

Active cell

Auto fill

Average function formula

Bar chart

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

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

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

A chart with rectangular bars with lengths proportional to the…

Active cell

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

Auto fill

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