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 Vocab
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 fo…
Cell
the intersection between a row and a column on a spreadsheet
Column
the vertical series of cells on a spreadsheet
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)
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…
5 terms
SPREADSHEET REVIEW 2 (Computer Apps)
spreadsheet
merge
columns
relative cell address
collection of data arranged in rows and columns
to combine into a single cell
spaces between the vertical grid lines
specified as the number of rows and columns that the second c…
spreadsheet
collection of data arranged in rows and columns
merge
to combine into a single cell
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
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
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
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( : )
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…
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)
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
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
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…
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
45 terms
Computer Apps Unit 1
Collaborate
Ribbon/Toolbar
Program/Application
Cloud
work jointly on an activity especially to produce or create s…
use the services of the computers operating system and other…
iCloud is a suite of free cloud-based services from Apple tha…
Collaborate
work jointly on an activity especially to produce or create s…
Ribbon/Toolbar
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,…
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…
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…
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…
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…
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.
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.
14 terms
Computer Applications Chapter 1
Hardware
Microprocesor
Acceptable Use Policies (AUPs)
Hackers
Includes the physical parts of an digital device like micropr…
Is the microchip or the brain
Rules to guide users in the use of their computers
Is an unauthorized computer uses who commits illegal acts.
Hardware
Includes the physical parts of an digital device like micropr…
Microprocesor
Is the microchip or the brain
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…
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.
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.
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…
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.
35 terms
Computer Applications 1 Semester Final
Cell
Column
Row
Range
a single data point or element in a spreadsheet
a vertical set of cells
a horizontal set of cells
a selection of cells extending across a row, column, or both
Cell
a single data point or element in a spreadsheet
Column
a vertical set of cells
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.
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.
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…
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…
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…
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…
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…
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 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
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…
COMPUTER APPLICATIONS 1
Database
Electronic Data Processing
File
Hard Disk
An organized collection of related data describes a
The handling of data using equipment that operates through el…
A collection of information on a disk (or other storage media…
A device containing a sealed, rigid, magnetic disk and read/w…
Database
An organized collection of related data describes a
Electronic Data Processing
The handling of data using equipment that operates through el…
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…
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
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…
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)
Computer Programs
Programs that enable you to accomplish…
Two or more computers connected togeth…
Used to manage network resources, this…
Software
Application Software
Computer Network
Server
Computer Programs
Software
Programs that enable you to accomplish…
Application Software
1 of 10