# Study sets matching "applications spreadsheet"

Study sets

Diagrams

Classes

Users

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…

cell reference

active cell

name box

home key

column letter and row number

currently selected cell that you can type in

says cell reference of active cell; to left of formula bar

takes you to the first cell of a row

cell reference

column letter and row number

active cell

currently selected cell that you can type in

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

approximate match lookup

argument

category values

[cell] <> [cell]

a look up where the lookup value falls within a range of numbe…

the numbers, text, or cell references used by the function to…

the groups of categories that a series values belong to

checks if the value in a given cell is not equal to the value…

approximate match lookup

a look up where the lookup value falls within a range of numbe…

argument

the numbers, text, or cell references used by the function to…

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

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…

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…

=SUM(C3:C10)

=AVERAGE(C3:C10)

bobby

formatting

SUM function in a spreadsheet

AVERAGE function in a spreadsheet

stupidity

allows a user to control the contents and appearance of a cell

=SUM(C3:C10)

SUM function in a spreadsheet

=AVERAGE(C3:C10)

AVERAGE function in a spreadsheet

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

Spreadsheet Structure

Cells

Conditional Formatting

Importing Data

A spreadsheet consists of a table of cells arranged into colum…

Cells commonly contain one of five different data types:... Bool…

Highlights worksheet data by changing the look of cells that m…

When an application is able to read a file created by another…

Spreadsheet Structure

A spreadsheet consists of a table of cells arranged into colum…

Cells

Cells commonly contain one of five different data types:... Bool…

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…

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…

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 structure

Cell Formatting

Data Validation

Templates

Contains multiple worksheets which are used to represent and m…

formatting = allows user to control the contents and appearanc…

Can control input value given to cells by use data validation…

Template = document which has been formatted using a predeterm…

Spreadsheet structure

Contains multiple worksheets which are used to represent and m…

Cell Formatting

formatting = allows user to control the contents and appearanc…

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

Active cell

AutoFill

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

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

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

Active cell

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

AutoFill

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

Active Cell

AutoFill

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…

AutoFill

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

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 return the average of all the n…

A chart with rectangular lengths proportional to the values th…

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…

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

What will be displayed if 30/3 is keyed…

What does NPER function calculate?

What type of function should be used to…

The ______ of the worksheet shows the a…

30/3

the number of periods for an investment based on periodic paym…

financial function

formulas version

What will be displayed if 30/3 is keyed…

30/3

What does NPER function calculate?

the number of periods for an investment based on periodic paym…

1. Which formula is correct for adding…

How can the order of operations in a sp…

3. The small black box you see in the c…

4. Once a formula is entered in a cell,…

=sum(L4:L8)

Use parenthesis ( ) around the operation to occur first

fill handle

AutoFiII

1. Which formula is correct for adding…

=sum(L4:L8)

How can the order of operations in a sp…

Use parenthesis ( ) around the operation to occur first

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…