How can we help?

You can also find more resources in our Help Center.

Study sets matching "applications spreadsheet"

Study sets
Classes
Users

Study sets matching "applications spreadsheet"

16 terms
Spreadsheet Applications
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…
100 terms
Spreadsheet Applications
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
35 terms
Spreadsheet applications
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…
82 terms
Spreadsheet applications
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
Spreadsheet Applications
If a value of w is stored in cell C5,…
This is a small black dot in the right…
Assume number of laps is in a column A…
This data tool would be ideal to use i…
D
B
A
A
If a value of w is stored in cell C5,…
D
This is a small black dot in the right…
B
17 terms
Spreadsheet Applications
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…
35 terms
Spreadsheet Applications
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…
80 terms
Unit 08 - Spreadsheet Applications
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…
35 terms
Unit 4- Spreadsheet Applications
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…
35 terms
Unit 4 Spreadsheet Applications
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…
26 terms
Spreadsheet Vocabulary for Tech Applications
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.
25 terms
FBLA Spreadsheet Applications Functions
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…
84 terms
125 Spreadsheet Applications Final Exam
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
35 terms
Unit 4 - Spreadsheet Applications
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…
35 terms
Unit 4- Spreadsheet Applications
Active Cell
AutoFill
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…
AutoFill
Automatically fills in cells with common series (Numbers, mon…
35 terms
Unit 4- SPREADSHEET APPLICATIONS
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…
29 terms
Unit 4- Spreadsheet Applications
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…
Unit 4- Spreadsheet Applications
Active Cell-
Auto Fill-
Bar Chart-
Cell-
the selected cell in which data is entered when you begin typ…
automatically fills in cells with common series (numbers, mon…
a chart with rectangular bars with lengths proportional to th…
a box formed by the intersection of a row and column in a wor…
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…
35 terms
spreadsheet applications vocab.
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…
23 terms
Unit 4 Spreadsheet Applications
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…
35 terms
Unit 4 Spreadsheet Applications
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…
35 terms
Unit 4- Spreadsheet Applications
Active Cell
AutoFill
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…
Receive 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…
AutoFill
Automatically fills in cells with common series (numbers, mon…
35 terms
Unit 4 Spreadsheet Applications
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…
35 terms
Unit 4- Spreadsheet applications
Active Cell
AutoFill
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 bags with lengths proportional to th…
Active Cell
The selected cell in which data is entered when you begin typ…
AutoFill
Automatically fills in cells with common series( numbers, mon…
36 terms
Unit IV: Spreadsheet Applications
Active Cell
AutoFill
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…
AutoFill
Automatically fills in cells with common series (Numbers, mon…
35 terms
Unit 4- Spreadsheet Applications
Active Cell
AutoFill
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 sells, 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…
AutoFill
Automatically fills in cells with common series (numbers, mon…
35 terms
Unit 4- Spreadsheet Applications
Active Cell
AutoFill
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…
AutoFill
Automatically fills in cells with common series (numbers, mon…
35 terms
Unit 4 Spreadsheet Applications
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, mot…
receives a range of cells, and returns the average of all the…
a c hart with rectangular bars with lengths proportional to t…
Active cell
The selected cell in which data is entered when you begin typ…
Auto Fill
automatically fills in cells with common series (numbers, mot…
35 terms
unit 4- spreadsheet applications
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…
35 terms
Unit 4- Spreadsheet Applications
Active Cell
Autofill
Average Function Formula
Bar Chart
The selected cell in which data in 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 t the…
Active Cell
The selected cell in which data in entered when you begin typ…
Autofill
Automatically fills in cells with common series (numbers, mon…
35 terms
Unit 4 Spreadsheet Applications
Active Cell
Auto Fill
Average Function Formula`
Bar Chart
The selected cell in which data is entered when you begin typ…
Automatically fills in cell 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…
Active Cell
The selected cell in which data is entered when you begin typ…
Auto Fill
Automatically fills in cell with common series
20 terms
Unit 4 spreadsheet applications
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…
The sum of all the cells divided by the number of cells
A vertical bar chart is sometimes called a column bar chart.
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…
10 terms
Office Productivity Applications Spreadsheet 3
Cell Range
Cell Value
Formula Bar
Label
a block of cells selected to implement a formula in a worksheet
the actual numeric value of the data in a cell
used to enter or modify data in a worksheet
a text entry that is used to identify the type of information…
Cell Range
a block of cells selected to implement a formula in a worksheet
Cell Value
the actual numeric value of the data in a cell
Computer Applications Spreadsheet
active sell
cell reference box
columns
formula bar
highlighted with a thick border; stores information that is e…
identifies the active cell by the letter of the column and th…
identified by letters that run horizontally.
displays the contents of the active cell and is used to creat…
active sell
highlighted with a thick border; stores information that is e…
cell reference box
identifies the active cell by the letter of the column and th…
9 terms
Spreadsheet and Database Applications
Name Box
x
check sign
fx
An element located below the Ribbon and displays the address…
is cancel a data entry or edit and revert back to previous da…
Enter . when you enter or edit data, click enter to accept da…
insert function. (search and insert function to insert)
Name Box
An element located below the Ribbon and displays the address…
x
is cancel a data entry or edit and revert back to previous da…
12 terms
Office Productivity Applications Spreadsheet 2
If Statements
Date Functions
Lookup Function
List Function
conditional operators
Calculate a period of time
compare a cell value to an ARRAY of cells
Assist in organizing spreadsheets, create user friendly sprea…
If Statements
conditional operators
Date Functions
Calculate a period of time
35 terms
Spreadsheet Applications Tutorial 3 Terms
absolute reference
approximate match lookup
argument
AutoFill
A cell reference that remains fixed when the cell formula is…
A lookup where the lookup value falls within a range of numbe…
The numbers, text, or cell references used by the function to…
A feature that copies content (text, values, or formulas) and…
absolute reference
A cell reference that remains fixed when the cell formula is…
approximate match lookup
A lookup where the lookup value falls within a range of numbe…
48 terms
Spreadsheet Applications Tutorial 4 Terms
100% stacked 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. (EX 219)
A column chart turned on its side so that the length of each…
The groups or categories that a series values belong to. (EX…
100% stacked column chart
A column chart that places the data series values within comb…
axis title
Descriptive text that appears next to an axis. (EX 219)
37 terms
Spreadsheet Applications Tutorial 2 Terms
Accounting format
automatic page break
Average function
cell highlighting
The number format that places a currency symbol at the left e…
A page break Excel sets automatically when the page of the pr…
An Excel function that calculates the average value from a co…
A conditional format that changes a cell's font color or fill…
Accounting format
The number format that places a currency symbol at the left e…
automatic page break
A page break Excel sets automatically when the page of the pr…
69 terms
Spreadsheet Applications Tutorial 1 terms
active cell
active sheet
arithmetic operator
AutoComplete
The cell currently selected in the active worksheet. (EX 2)
The sheet currently displayed in the workbook window. (EX 2)
An operator that performs addition, subtraction, multiplicati…
The feature that displays text that begins with the same lett…
active cell
The cell currently selected in the active worksheet. (EX 2)
active sheet
The sheet currently displayed in the workbook window. (EX 2)
35 terms
Unit 4-Spreadsheet application
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, mont…
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, mont…
35 terms
Unit 4 Spreadsheet application
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, mont…
Receives a range of cells, and returns the average of all the…
A chart with rectangle bars with lengths proportional to the…
active cell
The selected cell in which data is entered when you begin typ…
auto fill
Automatically fills in cells with common series(numbers, mont…
35 terms
Unit 4 Spreadsheet Application
active cell
autofill
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, mont…
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…
autofill
Automatically fills in cells with common series numbers, mont…
34 terms
unit 4 spreadsheet Application
active cell
autofill
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,month…
receives the range of cells, and returns the average of all t…
a chart with rectangular bars with lengths proportional to th…
active cell
the selected cell in which data is entered when you begin typ…
autofill
automatically fills in cells with common series(numbers,month…
35 terms
unit 4 spreadsheets applications
active cell
autofill
average function formula
bar chart
the cell in which data is entered when you begin typing only…
Automatically fills in cells with the common series
Received a range of cells and returns the average of all the…
A chart with bars of lengths proportional to values that they…
active cell
the cell in which data is entered when you begin typing only…
autofill
Automatically fills in cells with the common series
35 terms
Spreadsheet Vocabulary Computer Applications 8
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 (i…
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
35 terms
Unit 4 Vocab- Spreadsheet Applications
Active Cell
AutoFill
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…
AutoFill
automatically fills in cells with common series (numbers, mon…
35 terms
Unit 4 Spreadsheet Applications Vocabulary
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…
35 terms
Unit 4 Vocabulary Spreadsheet Applications
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…
20 terms
Spreadsheet Applications Chapter 2 (VOCAB)
Syntax
TODAY Function
Absolute Cell Reference
Circular Reference
A set of rules that governs the structure and components for…
Displays the current date.
Indicates a cell's specific location; the cell reference does…
Occurs when a formula directly or indirectly refers to itself.
Syntax
A set of rules that governs the structure and components for…
TODAY Function
Displays the current date.
1 of 10