How can we help?

You can also find more resources in our Help Center.

Study sets matching "computer applications spreadsheet"

Study sets
Classes
Users

Study sets matching "computer applications spreadsheet"

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…
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
38 terms
Computer Business Applications: Unit 3 Spreadsheets
Absolute Cell Reference
Active Cell
Alignment
Argument
Cell reference that does not adjust to the new cell location…
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…
Active Cell
A selected worksheet cell that is ready for data entry
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…
19 terms
Computer Applications- Unit 1 & 2 Spreadsheets
Absolute Reference
Argument
Average Function
Fill
cell address that does not change when copied in a formula
values or cell references that a function needs to complete i…
built in math function that determines the average of a block…
a feature that allows the user to copy fill data in cells adj…
Absolute Reference
cell address that does not change when copied in a formula
Argument
values or cell references that a function needs to complete i…
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…
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
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
39 terms
Computer Applications
button (el boton)
wireless (inalambrico)
window (la ventana)
website (plural los webs)
microswitch on a computer mouse which can be pressed to selec…
broadcasting, computer networking, or other communication usi…
in computing, a window is a visual area containing some kind…
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 selec…
wireless (inalambrico)
broadcasting, computer networking, or other communication usi…
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…
5 terms
Computer applications b: guided notes on software spreadsheet
Active cell
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
Splays the contents of the active cell and is used to create…
Active cell
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…
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…
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…
12 terms
Computer Applications
monitor
keyboard
CPU
mouse
Display screen
row of keys on a computer
Central Processing Unit
a pointing device that you use to click on icons or buttons.
monitor
Display screen
keyboard
row of keys on a computer
32 terms
Computer Applications
By pushing the arrows on the keypad
Triple-click any word in the paragraph
Layout
Styles allows you to format text in mu…
In addition to using the track pad or scroll bar, how can you…
How can you quickly select an entire paragraph of text at one…
Which tab on the ribbon would you use to change the margins i…
Why is it beneficial to use the "Styles" function in Microsof…
By pushing the arrows on the keypad
In addition to using the track pad or scroll bar, how can you…
Triple-click any word in the paragraph
How can you quickly select an entire paragraph of text at one…
18 terms
Computer Applications
Hardware
Software
CPU
Hard drive
Parts that you can see and touch
instructions that tell the hardware to operate
Brain of the computer
hold all your progress
Hardware
Parts that you can see and touch
Software
instructions that tell the hardware to operate
11 terms
Computer applications
Themes
thumbnails
template
layout
A scheme of complementing colors
small picture of a slide
predesigned presentation
predefined arrangement o placeholders for text or objects
Themes
A scheme of complementing colors
thumbnails
small picture of a slide
12 terms
Computer; Spreadsheet
Spreadsheet
Microsoft Excel
Workbook
Labels
is a computer software that helps you organize and process ma…
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 ma…
Microsoft Excel
one of the most popular spreadsheet.
30 terms
Computer Applications
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 spr…
located above the Ribbon and it lets you access common comman…
Excel
a spreadsheet program that allows you to store, organize, and…
Ribbon
Contains multiple Tabs, each with several groups of commands
12 terms
Computer Skills: Computer Applications
document ... a piece of writing you make…
type ... to write with a keyboard
presentation ... giving information to a…
slide ... a page in an electronic presen…
Remember to save your document.
Sandra types her name.
Amanda uses PowerPoint for her presentation.
The first slide has my name on it.
document ... a piece of writing you make…
Remember to save your document.
type ... to write with a keyboard
Sandra types her name.
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…
16 terms
Computer Applications
Internet
Moniter
Hard Drive
USB Port
A worldwide system of computers and networks linked together.
Internet
A worldwide system of computers and networks linked together.
Moniter
10 terms
Computer Applications
Describe
Discuss
Explain
Identify
Give an account in words of (someone or something), including…
Talk about (something) with another person or group of people
Talk about (something) with another person or group of people
Establish or indicate who or what (someone or something) is.…
Describe
Give an account in words of (someone or something), including…
Discuss
Talk about (something) with another person or group of people
14 terms
computer applications
audio input
audio output device
bar code
biometrics
to enter any sound,such as speech,music,and sound effects, in…
output device that produces,music,speech,or other sounds,such…
optical reader that uses laser beams to read var codes.
technology of authenticating a person's identity by verifying…
audio input
to enter any sound,such as speech,music,and sound effects, in…
audio output device
output device that produces,music,speech,or other sounds,such…
14 terms
Computer Applications B: "Spreadsheet Skills," Vocabulary Terms 2nd Quarter, Fall 2015
active cell:
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 cell:
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…
15 terms
Computer Applications
Access
Outlook
Excel
Maximize
Microsoft application used to generate reports from stored data
Microsoft e-mail client
Microsoft application used to chart data
Clicked to expand the window
Access
Microsoft application used to generate reports from stored data
Outlook
Microsoft e-mail client
12 terms
Computer Applications
active cell
animation
animation schemes
ascending order
a selected cell
special visuals or sound effects added to text or an object o…
predesigned sets of visual effects added to text on PowerPoin…
sorts alphabetically from A to Z and numerically from the low…
active cell
a selected cell
animation
special visuals or sound effects added to text or an object o…
8 terms
Computer Applications
Spreadsheet
Presentation Software
Utility Software
Word Processing
An application software that is used to do calculations, grap…
Software that is used to create, edit, and print presentation…
A program that performs a very specific task, usually related…
Using a computer to create, edit, and print documents.
Spreadsheet
An application software that is used to do calculations, grap…
Presentation Software
Software that is used to create, edit, and print presentation…
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…
computer applications
data
website
email
online
computer data is information processed or stored by a computer
a web site is a collection of web pages
email, short for "electronic mail," is one of the most widely…
In general, when a machine is "online," it is turned on and c…
data
computer data is information processed or stored by a computer
website
a web site is a collection of web pages
12 terms
OLD Computer Skills: Computer Applications
document ... a piece of writing you make…
type ... to write with a keyboard
presentation ... giving information to a…
slide ... a page in an electronic presen…
Remember to save your document.
Sandra types her name.
Amanda uses PowerPoint for her presentation.
The first slide has my name on it.
document ... a piece of writing you make…
Remember to save your document.
type ... to write with a keyboard
Sandra types her name.
Computers-spreadsheet
Spreadsheet
Spreadsheet
Spreadsheet
Cell
A sheet of paper (or computer program) that is divided into c…
Primarily used with numbers in accounting
Often used in business and other applications to answer the q…
Is a box formed by the intersection of a column and a row
Spreadsheet
A sheet of paper (or computer program) that is divided into c…
Spreadsheet
Primarily used with numbers in accounting
65 terms
Ms. Berrios, Computer Applications
Folder
file
Heading
Insert date
An area for storing files to keep them organized
a set of related records (either written or electronic) kept…
The lines that identify the author of the paper, the class an…
word feature to insert the date and or time into a document
Folder
An area for storing files to keep them organized
file
a set of related records (either written or electronic) kept…
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
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 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
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…
1 of 10