How can we help?

You can also find more resources in our Help Center.

Study sets matching "applications 1 computer apps spreadsheet"

Study sets
Classes
Users

Study sets matching "applications 1 computer apps spreadsheet"

10 terms
SPREADSHEET REVIEW 1(Computer Apps)
column and row
arguments
=Today
absolute
used to name each cell
values the function needs for the calculation
function that returns the current date
not a common formatting for numbers in a spreadsheet
column and row
used to name each cell
arguments
values the function needs for the calculation
Computer Apps Spreadsheets Unit 1
Workbook
Worksheet
Sheet Tab
Rows
The complete file with one or many worksheets
One tab in the workbook that contains many columns and rows
Another name for a worksheet
Horizontal Bars; Labeled with numbers
Workbook
The complete file with one or many worksheets
Worksheet
One tab in the workbook that contains many columns and rows
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…
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…
8 terms
Computer Apps:Spreadsheet formulas
formula to calculate AVERAGE
formula to calculate Highest # in set…
formula to calculate lowest # in set o…
formula to calculate sum
= AVERAGE(cell:cell)
=MAX(cell:cell)
=MIN(cell:cell)
=SUM(sum:sum)
formula to calculate AVERAGE
= AVERAGE(cell:cell)
formula to calculate Highest # in set…
=MAX(cell:cell)
23 terms
Computer Apps Spreadsheets Test
Spreadsheets
Function
PMT Function
Absolute Cell Reference
Electronic documents in which data is arranged into columns a…
Pre-set formula
Financial function used to calculate a loan
$A$2
Spreadsheets
Electronic documents in which data is arranged into columns a…
Function
Pre-set formula
21 terms
Computer Apps Spreadsheets
Cell
Rows
Columns
Cell References
where a row and column intersect, for example column A and ro…
identified by numbers and are horizontal
identified by letters and are vertical
this is the name of the cell or how we would refer to the cel…
Cell
where a row and column intersect, for example column A and ro…
Rows
identified by numbers and are horizontal
8 terms
Computer apps spreadsheets
What do all formualas begin with
What is the thing if you wnated to add…
What is the thing if you want to subtr…
What is the thing if you wanted to mul…
=
=SUM( : )
=cell-cell
=cell*cell
What do all formualas begin with
=
What is the thing if you wnated to add…
=SUM( : )
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
12 terms
Computer Apps Unit 6 - Spreadsheets
Active Cell
Alignment
Cell
Cell range
a selected worksheet cell that is ready for data entry
the position of data within a cell
the intersection of a column and a row on a worksheet.
a continuous group of selected cells in a spreadsheet (Ex. B2…
Active Cell
a selected worksheet cell that is ready for data entry
Alignment
the position of data within a cell
15 terms
Computer Apps Unit 6 - Spreadsheet Charting Vocabulary
Chart
Column Chart
Data marker
Data Point
A graphical representation of data
a chart that uses bars of varying height to illustrate values…
A single column, pie slice, or point from a data series.
A value that originates in a worksheet cell and that is repre…
Chart
A graphical representation of data
Column Chart
a chart that uses bars of varying height to illustrate values…
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
20 terms
Lesson 1 Computer Applications
arithmetic/logic unit (ALU)
central processing unit (CPU)
circuit board
computer
part of the central processing unit that performs arithmetic…
microprocessor; the brains of the computer
a thin plate inside the computer that contains electronic com…
an electronic device that receives, processes, and stores dat…
arithmetic/logic unit (ALU)
part of the central processing unit that performs arithmetic…
central processing unit (CPU)
microprocessor; the brains of the computer
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)
Computer Applications Unit 1
Access keys
Application software
Close
Cursor
shortcut keys; keys used in combination to create actions or…
any program that processes data for the user (inventory, payr…
processing of quitting the open window or application
insertion point in a document in the form of a blinking verti…
Access keys
shortcut keys; keys used in combination to create actions or…
Application software
any program that processes data for the user (inventory, payr…
10 terms
Computer Apps vocabulary #1
URL
Netiquette
Search Engines
Homepage
Uniform Resource Locater... An address that tells the web browse…
Netiquette A set of rules about getting along harmoniously in…
Any program that locates information in a database or locate…
The page that serves as a base for the rest of the pages of a…
URL
Uniform Resource Locater... An address that tells the web browse…
Netiquette
Netiquette A set of rules about getting along harmoniously in…
34 terms
Computer Apps vocab unit 3 (spreadsheets)
Google Spreadsheets:
Excel
Ribbon:
File Menu:
allows you to organize, edit and analyze different types of i…
spreadsheet software that allows us to make spreadsheets to s…
contains all commands you'll need in order to do common tasks…
allows you to manage and share documents, it is located in th…
Google Spreadsheets:
allows you to organize, edit and analyze different types of i…
Excel
spreadsheet software that allows us to make spreadsheets to s…
43 terms
Spreadsheet applications Ch. 1-3
Requirements Document
Range
Pressing the right arrow key in a cell
Enter Box
Includes a needs statement, source of data, and summary of ca…
Series of two or more adjacent cells in a column or row
Activates the adjacent cell
Completes an entry; big check mark
Requirements Document
Includes a needs statement, source of data, and summary of ca…
Range
Series of two or more adjacent cells in a column or row
22 terms
NC Computer Apps I, 4.01 Spreadsheet Components
Workbook
Spreadsheet
Cells
Cell address
a file which contains one or more spreadsheets.
an arrangement of cells in columns and rows used to organize,…
individual locations on a spreadsheet.
refers to one specific location, such as A4.
Workbook
a file which contains one or more spreadsheets.
Spreadsheet
an arrangement of cells in columns and rows used to organize,…
15 terms
Computer Applications: Week 1
Computer
Information processing data
Data
Information
an electronic device for storing and processing data, typical…
processing of information, especially the handling of informa…
facts and statistics collected together for reference or anal…
facts provided or learned about something or someone
Computer
an electronic device for storing and processing data, typical…
Information processing data
processing of information, especially the handling of informa…
36 terms
Computer Applications - Ch. 4 Programs and Apps
Program / software
Application or app
Operating system
Productivity Application Steps
consists of a series of related instructions, organized for a…
consists of programs designed to make users more productive a…
a set of programs that coordinates all the activities among c…
Create a project, edit a project, format a project, save a pr…
Program / software
consists of a series of related instructions, organized for a…
Application or app
consists of programs designed to make users more productive a…
13 terms
Computer Applications 1: Tables
column
row
cell
cell address
A vertical (up and down) selection of cells identified by let…
A horizontal (left to right) selection of cells identified by…
The intersection of a row and a column; where you enter data.
The location of a cell in your table. Cell Addresses are iden…
column
A vertical (up and down) selection of cells identified by let…
row
A horizontal (left to right) selection of cells identified by…
Computer Applications Vocab 1
software
application software
password
system software
instructions for the computer; a series of instructions that…
any program that processes data for the user (inventory, payr…
keyword used to access information on a network, website, etc.
software made up of control programs, such as the operating s…
software
instructions for the computer; a series of instructions that…
application software
any program that processes data for the user (inventory, payr…
20 terms
Lesson 1 Computer Applications
arithmetic/logic unit (ALU)
central processing unit (CPU)
circuit board
computer
part of the central processing unit that performs arithmetic…
microprocessor; the brains of the computer
a thin plate inside the computer that contains electronic com…
an electronic device that receives, processes, and stores dat…
arithmetic/logic unit (ALU)
part of the central processing unit that performs arithmetic…
central processing unit (CPU)
microprocessor; the brains of the computer
15 terms
Computer Apps Vocab 1-15
Active Cell
Application Software
Ascending Order
AVERAGE
in Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
in Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
20 terms
Computer Apps Vocab 1-20
Active Cell
Application Software
Ascending Order
AVERAGE
in Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
in Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
30 terms
Computer Apps Vocab 1-30
Active Cell
Application Software
Ascending Order
AVERAGE
in Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
in Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
10 terms
Computer Apps Vocab 1-10
Active Cell
Application Software
Ascending Order
AVERAGE
in Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
in Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
25 terms
Computer Apps Vocab 1-25
Active Cell
Application Software
Ascending Order
AVERAGE
in Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
in Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
43 terms
Computer Apps Vocab 1-45
Active Cell
Application Software
Ascending Order
AVERAGE
In Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
In Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
19 terms
Computer Apps 1 Ch. 2 Understanding Computers
computer system
input devices
command
speech-recognition software
includes several devices that perform the four basic function…
devices or methods used to enter data such as text, images, o…
an instruction for the computer to perform some action
users can input text by speaking into a microphone
computer system
includes several devices that perform the four basic function…
input devices
devices or methods used to enter data such as text, images, o…
40 terms
Computer Apps Vocab 1-40
Active Cell
Application Software
Ascending Order
AVERAGE
in Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
in Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
35 terms
Computer Apps Vocab 1-35
Active Cell
Application Software
Ascending Order
AVERAGE
In Excel, the worksheet cell with the dark border that is rea…
Software used for a specific task, such as word processing.
A to Z or 0 to 9.
The Excel function that calculates the average value in a ran…
Active Cell
In Excel, the worksheet cell with the dark border that is rea…
Application Software
Software used for a specific task, such as word processing.
20 terms
Computer Apps Vocab Quiz 1
Adapter
Alert Box
Antivirus
Application
A device that allows a specific type of hardware to work with…
A small window that pops up on your screen to give you inform…
A type of utility used for scanning and removing viruses from…
A software program that runs on your computer.
Adapter
A device that allows a specific type of hardware to work with…
Alert Box
A small window that pops up on your screen to give you inform…
35 terms
Business Computer Application 1
Word 2010
Excel
Access
Publisher
Type: Word Proccessing... Flie extension: .docx
Type: Spread sheet... File Extension: .xlsx
Type: Data Base... File Extension: .accdb
Type: Destop Publishing... File Esxtension: .pud
Word 2010
Type: Word Proccessing... Flie extension: .docx
Excel
Type: Spread sheet... File Extension: .xlsx
8 terms
Computer Applications Ch. 1
turing test
ubiquitous computing (ubicomp)
unicode
vacuum tube
a measure of a computer's ability to display intelligent beha…
technology that recedes into the background and becomes part…
an extended ASCII set that is the standard on the internet an…
a tube that resembles an incandescent lightbulb and was used…
turing test
a measure of a computer's ability to display intelligent beha…
ubiquitous computing (ubicomp)
technology that recedes into the background and becomes part…
25 terms
Computer Applications Chapter 1 (Word)
Bold
Bulleted List
Centered
Character Formatting
characters are displayed somewhat thicker and darker
a series of paragraphs, each beginning with a symbol or numbe…
positioned horizontally between the left and right margins on…
is the process of changing the way characters appear on the s…
Bold
characters are displayed somewhat thicker and darker
Bulleted List
a series of paragraphs, each beginning with a symbol or numbe…
10 terms
Computer Applications - Vocab #1
software
hardware
menu bar
program
lines of computer code written by programmers that tell the c…
the physical parts of a computer and all related devices
the horizontal strip that contains lists of available menus f…
executable software that runs on a computer
software
lines of computer code written by programmers that tell the c…
hardware
the physical parts of a computer and all related devices
10 terms
Computer Skills and Applications 1
Keyboard
Monitor
CPU
Emoticon
Used to key in words
Used to view words from computer
Holds base of computer functions
Emotional characters
Keyboard
Used to key in words
Monitor
Used to view words from computer
42 terms
Computer Applications 1.1
abstraction
activity
algorithm
app
Hiding data or details.
In an Android app, the entry point where your app begins... exec…
A sequence of instructions that accomplishes a task.
An application that can run on the Android operating... system.
abstraction
Hiding data or details.
activity
In an Android app, the entry point where your app begins... exec…
18 terms
Computer Apps Unite 1
Collaborate
Ribbon/Toolbar
Program/Application
Cloud
working together to make or produce something
Collaborate
working together to make or produce something
Ribbon/Toolbar
9 terms
Computer Applications Ch. 1
information processing cycle (IPC)
integrated circuit
Internet of Things
laptop
There are four steps, input, processing, storage, and output.
chips that contain large numbers of tiny transistors fabricat…
a connection of the physical world to the internet, not only…
computers are portable personal computers.
information processing cycle (IPC)
There are four steps, input, processing, storage, and output.
integrated circuit
chips that contain large numbers of tiny transistors fabricat…
58 terms
Unit 1 Computer Applications
Type a list of the pieces of computer…
Type of list of input devices on your…
Type of a list of software on your com…
Type a list of output devices in this…
Input , processors, communication, output, memory, and storag…
Keyboard, mouse stylus, smart phone, touch pad, tablets (touc…
Microsoft Office 2010, Adobe PhotoShop, Windows 7, and Window…
Speakers, headphones, printer, monitor, and digital camera
Type a list of the pieces of computer…
Input , processors, communication, output, memory, and storag…
Type of list of input devices on your…
Keyboard, mouse stylus, smart phone, touch pad, tablets (touc…
9 terms
Computer Applications Ch. 1
information processing cycle (IPC)
integrated circuit
Internet of Things
laptop
There are four steps, input, processing, storage, and output.
chips that contain large numbers of tiny transistors fabricat…
a connection of the physical world to the internet, not only…
computers are portable personal computers.
information processing cycle (IPC)
There are four steps, input, processing, storage, and output.
integrated circuit
chips that contain large numbers of tiny transistors fabricat…
12 terms
Computer Apps 1 Notes
Grace Hopper
Mark 1
Jack Kilby
Integrated Circuit
Woman, helped develop standard codes. Helped program Mark 1.
IBM Computer .
Texas Instruments worker made computers smaller. Invented Int…
Increased efficiency of computer by combining transistor and…
Grace Hopper
Woman, helped develop standard codes. Helped program Mark 1.
Mark 1
IBM Computer .
18 terms
Computer apps unite 1
Collaborate
Ribbon/Toolbar
Program/Application
Cloud (not the puffy thing in the sky)
work together
A downloaded app
you can access them anywhere you have a internet connection
Collaborate
work together
Ribbon/Toolbar
77 terms
Computer Applications 1
Program
Windows 8
Operating system
Desktop app
a set of instructions that a computer uses to accomplish a ta…
operating system developed by Microsoft Corporation that work…
a specific type of computer program that manages other progra…
a computer program that is installed on the hard drive of you…
Program
a set of instructions that a computer uses to accomplish a ta…
Windows 8
operating system developed by Microsoft Corporation that work…
37 terms
Computer Apps Ch. 1
access
click
closing a document
double-click
the Office database application
pressing the left mouse button and releasing it quickly
removing a document from the application window and the file…
pressing the left mouse button twice in rapid succession
access
the Office database application
click
pressing the left mouse button and releasing it quickly
123 terms
Computer Apps. 1 Shortcuts
F1
CTRL+ESC
ALT
CTRL+F1
To obtain help in many apps
To display the start screen
To display KeyTips (keyboard code icons for certain commands)
To collapse and expand the ribbon and use full screen mode
F1
To obtain help in many apps
CTRL+ESC
To display the start screen
15 terms
Computer Applications Review: 1
The primary editing view in PowerPoint
A presentation page that can contain t…
The first slide in a presentation, the…
A box on a slide that holds title and…
Normal view
Slide
Title slide
Placeholder
The primary editing view in PowerPoint
Normal view
A presentation page that can contain t…
Slide
1 of 10