How can we help?

You can also find more resources in our Help Center.

Study sets matching "applications business computer excel"

Study sets
Classes
Users

Study sets matching "applications business computer excel"

Computer Business Application Unit 3: Excel
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.
18 terms
Computer Applications- Excel
Excel
Spreadsheet
Rows
Columns
Spreadsheet or a worksheet
Grid of rows or columns containing words, numbers, text, and/…
Run left to right, identified as numbers
Top to bottom, identified as letters
Excel
Spreadsheet or a worksheet
Spreadsheet
Grid of rows or columns containing words, numbers, text, and/…
15 terms
Computer Applications Excel Terminology
Workbook
Worksheet
Cell
Active Cell
An excel file with one or more worksheets
The work area for calculating data made up of columns and row…
The intersection of a column and a row on a worksheet
The cell that is ready to take data
Workbook
An excel file with one or more worksheets
Worksheet
The work area for calculating data made up of columns and row…
20 terms
Computer Applications excel Romereim
Active Cell
Cell Reference
Column
Row
The cell displayed with a bold border
The column letter and row number that identify a cell, such a…
Vertical part of the worksheet grid identified by the letters
Horizontal part of the worksheet grid identified by the numbers
Active Cell
The cell displayed with a bold border
Cell Reference
The column letter and row number that identify a cell, such a…
26 terms
Computer Applications for Business Exam 3 (Excel) Rutgers Stephen Stoll
Ch 13
Spreadsheet
Clipped data
CATEGORY
basic excel
• An array of cells for setting up a list... • The guide lines a…
Data too long for a cell will appear to flow into the next ce…
When organizing data, each column will represent a CATEGORY,…
Ch 13
basic excel
Spreadsheet
• An array of cells for setting up a list... • The guide lines a…
19 terms
Computer Applications - Excel
A designation that provides a permanen…
A predefined formula that calculates t…
A predefined formula that tallies the…
A predefined formula that tallies the…
Absolute cell reference
AVERAGE function
COUNT function
COUNTA function
A designation that provides a permanen…
Absolute cell reference
A predefined formula that calculates t…
AVERAGE function
30 terms
Computer Applications in Business Vocab-Berrios
Application... Aplicacion
Blog... escribir opiniones en una pagina…
Desktop... Computadora usualmente ubicada…
Document... Documento
A computer or software program, activated by a user that can…
A diary or personal journal kept on a website, usually update…
The background area on a computer screen which usually contai…
Any self-contained piece of work created using an application…
Application... Aplicacion
A computer or software program, activated by a user that can…
Blog... escribir opiniones en una pagina…
A diary or personal journal kept on a website, usually update…
48 terms
Computer Applications: Excel
*Spreadsheet/Worksheet
Workbook
Column
Row
an interactive computer application program for organization,…
A spreadsheet file containing one or many worksheets
A vertical stack of cells in a table or worksheet.
A horizontal group of cells in a worksheet identified by numb…
*Spreadsheet/Worksheet
an interactive computer application program for organization,…
Workbook
A spreadsheet file containing one or many worksheets
30 terms
Computer Applications Excel
columns run..
rows run...
a spreadsheet arranges data into...
worksheet is another name for
vertically
horizontally
rows and columns for mathematical calculations
spreadsheet
columns run..
vertically
rows run...
horizontally
16 terms
Computer applications excel notes
Order of Operations
Function
absolute reference
Today's Date
determines the order of mathematical operations
premade formulas
used in formulas to repeatedly refer back to a specific cell…
Control semicolon.Simply put in today's date. Static.
Order of Operations
determines the order of mathematical operations
Function
premade formulas
31 terms
BCHS Computer Applications Excel Review
=A1*B1
sort
$
min
This is the equation I should write in C1 to multiply cells A…
arrange in order
This sign is the symbol used to represent an anchor.
function to find the smallest value in a range of cells
=A1*B1
This is the equation I should write in C1 to multiply cells A…
sort
arrange in order
13 terms
Excel- Computer Applications Test
Dates are automatically treated as wha…
What is the definition of a spreadsheet?
What is the main advantage of using a…
What is the difference between a value…
General
An electronic document in which data is arranged in the rows…
You can change the data and the formulas are updated.
Labels- text/numbers you type, values- results of calculations
Dates are automatically treated as wha…
General
What is the definition of a spreadsheet?
An electronic document in which data is arranged in the rows…
Computer Applications Excel
the hilighted cell is the
A1 is the active cell in a ____ spread…
enter and the ______ key perform the s…
AUTOSUM FUNCTION
active cell
new
downward
<<<autosum by filter... <<<select enter
the hilighted cell is the
active cell
A1 is the active cell in a ____ spread…
new
12 terms
Computer Applications Excel
Workbook
Quick Access Toolbar
Ribbon
Column Heading
The file made in Excel - made up of 3 worksheets
Lets you access quick commands; undo, redo, save... can custo…
Contains commands you need to do common tasks; made up of mul…
Contains 16,000~ __________, named using letter(s)
Workbook
The file made in Excel - made up of 3 worksheets
Quick Access Toolbar
Lets you access quick commands; undo, redo, save... can custo…
60 terms
Computer Applications Excel Exam
Workbook
Worksheet
Active Cell
Cell Reference
An Excel file that contains one or more worksheets.
The primary document that you use in Excel to store and work…
The cell surrounded by a green border, ready to receive data…
The identification of a specific cell by it's intersecting co…
Workbook
An Excel file that contains one or more worksheets.
Worksheet
The primary document that you use in Excel to store and work…
122 terms
Adv. computer applications excel
You should hold down the ____ key to s…
To hide an entire workbook on an unatt…
Data is in ____ sequence if it is in o…
Excel automatically selects the Left c…
CTRL
(VIEW tab | Window group)
ascending
True
You should hold down the ____ key to s…
CTRL
To hide an entire workbook on an unatt…
(VIEW tab | Window group)
27 terms
Computer Applications Excel Vocab
Worksheet
Spreadsheet
Cell
Formula
the electronic representation of a spreadsheet. A worksheet i…
computer software program that can be used to manipulate data…
the basic unit of a worksheet in which data are stored. Inter…
an arrangement of numbers and/or cell addresses and arithmeti…
Worksheet
the electronic representation of a spreadsheet. A worksheet i…
Spreadsheet
computer software program that can be used to manipulate data…
14 terms
Computer Applications: Word Excel
Spreadsheet
Workbook
Cell
Formula Bar
A spreadsheet in a grid of blocks that will keep data organiz…
It is the screen you are working on to create your spreadsheet.
A block in Excel where you enter data.
Create or edit your text there.
Spreadsheet
A spreadsheet in a grid of blocks that will keep data organiz…
Workbook
It is the screen you are working on to create your spreadsheet.
30 terms
computer applications excel
information created in excel is saved…
in an excel worksheet, columns are ref…
what part of the excel screen displays…
the portion of the excel screen contai…
workbook
columns-letters/rows-numbers
formula bar
worksheet area
information created in excel is saved…
workbook
in an excel worksheet, columns are ref…
columns-letters/rows-numbers
75 terms
Computer applications midterm (excel)
Workbook
Active cell
Autofill
A series
An excel document is called?
The ______, when outlined in black, indicates it is ready to…
______ generates and extends a series of values into adjacent…
A group of items that comes one after another in succession
Workbook
An excel document is called?
Active cell
The ______, when outlined in black, indicates it is ready to…
36 terms
Computer Application: Introduction to Excel
understand what is required
cell
ESC
Auto correct
The first step in creating an effective worksheet is to make…
To enter data in a cell, you must first select or activate th…
To cancel an entire entry before entering it into the cell, p…
The _____________ feature works behind the scenes , fixing co…
understand what is required
The first step in creating an effective worksheet is to make…
cell
To enter data in a cell, you must first select or activate th…
41 terms
computer application excel vocab
Accounting number format1
arguments 2
Auto Fill Options 3
AVERAGE function4
Displays numbers with a dollar sign to the left and inserts a…
The values that are used with a function2
Button that gives options for how to fill cells following a f…
Sums numbers in a specified range and then divides by the num…
Accounting number format1
Displays numbers with a dollar sign to the left and inserts a…
arguments 2
The values that are used with a function2
36 terms
Computer Applications: Excel---Lesson 1
Excel
spreadsheet
worksheet
workbook
spreadsheet program in the Microsoft Office 2010 software
a grid of rows and columns in which you enter text, numbers,…
a computerized spreadsheet
collection of related workbooks
Excel
spreadsheet program in the Microsoft Office 2010 software
spreadsheet
a grid of rows and columns in which you enter text, numbers,…
Computer Application: Excel
Rows
Columns
Assumptions
Formula
Go across the page and are named by numbers
Go up and down the page and are named by letters
Values in cells that you can change to determine new values f…
A calculation assigned to a cell
Rows
Go across the page and are named by numbers
Columns
Go up and down the page and are named by letters
132 terms
Computer Business Applications
Application Software
Central Processing Unit (CPU)
File Management
File Type
computer software created to allow the user to perform specif…
executes commands from a computer's hardware and software; th…
a program on a computer that allows the user to create, edit,…
an extension at the end of a file name, including which appli…
Application Software
computer software created to allow the user to perform specif…
Central Processing Unit (CPU)
executes commands from a computer's hardware and software; th…
20 terms
Business Computer Applications Vocabulary
tab
font
case
return address
a location (or measurement) you use to align text
a set of characters with a specific typeface size and style
the specific use of upper or lower letters
the author's address typically appearing at the very top of t…
tab
a location (or measurement) you use to align text
font
a set of characters with a specific typeface size and style
Computer Application: Excel Exam
Letters
Numbers
Cell Address
Range
Columns go up and down a page and are named by ________
Rows go across a page and are named by _________
The _____ is a cell's location using its column letter and ro…
A ______ is a block of adjoining cells
Letters
Columns go up and down a page and are named by ________
Numbers
Rows go across a page and are named by _________
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
33 terms
Computer Applications 2 EOC Excel
AutoFormat
Currency format
Fit to
Merge
Built-in set of formatting instructions that applies fonts, c…
Format data using commas and dollar signs
Printing option that allows user to change page scaling
A feature that combines a data document with a main document…
AutoFormat
Built-in set of formatting instructions that applies fonts, c…
Currency format
Format data using commas and dollar signs
38 terms
Computer Applications Excel Chp 3
Cell references in a formula are calle…
When you set up a worksheet, you shoul…
Which of the following is a suggested…
With a solid understanding of the requ…
assumptions
Constant
determine the necessary functions and formulas needed
use Excel to create the worksheet
Cell references in a formula are calle…
assumptions
When you set up a worksheet, you shoul…
Constant
55 terms
Computer Business Applications
The most commonly used tabs are, left,…
You can enter a soft return by using t…
The keyboard shortcut for saving a per…
Can remove a tab by dragging the tab m…
Decimals
it prevents word form creating a new paragraph
Crtl + S
True
The most commonly used tabs are, left,…
Decimals
You can enter a soft return by using t…
it prevents word form creating a new paragraph
50 terms
Computer Basics - Business Technology Applications
Computer
Data
Information
Computer Hardware
A programmable electronic device that can store, retrieve, an…
A collection of raw facts, figures, and symbols given to a co…
Data that is organized, meaningful, and useful
The physical parts and components of a computer
Computer
A programmable electronic device that can store, retrieve, an…
Data
A collection of raw facts, figures, and symbols given to a co…
271 terms
Computer Applications for Business FINAL
Herman Hollerith
Hardware
Central Processing Unit
Software
Credited with the first "production" application of digital i…
Built out of wires, rollers, and motors... Computer machinery an…
Performs instructions stored in the computer's memory... Execute…
Written programs or procedures or rules and associated docume…
Herman Hollerith
Credited with the first "production" application of digital i…
Hardware
Built out of wires, rollers, and motors... Computer machinery an…
27 terms
Computer Applications 7 - Excel Vocab
Worksheet
Spreadsheet
Cell
Formula
The electronic representation of a spreadsheet. A worksheet i…
Computer software program that can be used to manipulate data…
The basic unit of a worksheet in which data are stored. Inter…
An arrangement of numbers and/or cell addresses and arithmeti…
Worksheet
The electronic representation of a spreadsheet. A worksheet i…
Spreadsheet
Computer software program that can be used to manipulate data…
65 terms
Computer Applications for Business
In order for something to be considere…
What was used to make analyzing result…
When using Google or Bing, what keywor…
What word is interchangeable with comp…
False
punch cards and punch card readers
definition
Processor
In order for something to be considere…
False
What was used to make analyzing result…
punch cards and punch card readers
19 terms
Computer Applications Vocab 7 (Excel)
Active Cell
Quick Access Toolbar
cell
Column
refers to the currently selected cell in a spreadsheet.
gives you quick access to commonly used features such as the…
a specific location within a spreadsheet and is defined by th…
a vertical group of values within a table. It contains values…
Active Cell
refers to the currently selected cell in a spreadsheet.
Quick Access Toolbar
gives you quick access to commonly used features such as the…
Computer Applications Excel Module test
You can apply the Bold font style by p…
Excel remembers the last ____ actions…
The ____ feature works behind the scen…
You use ____ to view an XPS file.
CTRL+B
100
AutoCorrect
XPS Viewer
You can apply the Bold font style by p…
CTRL+B
Excel remembers the last ____ actions…
100
11 terms
Computer Applications Intro to Excel Notes
Spreadsheet
Worksheet
Workbook
Cell Reference
Grid of rows and columns containing numbers, text and formula…
Computerized spreadsheet in Excel; a grid of rows and columns…
Collection of related worksheets in Excel.
Identifies a cell by the column letter and row number (for ex…
Spreadsheet
Grid of rows and columns containing numbers, text and formula…
Worksheet
Computerized spreadsheet in Excel; a grid of rows and columns…
13 terms
Computer Business Applications
Animation
Design template/Theme
Graphic
Handouts
the way text and objects move on and off a slide during a sli…
prepared designs that can be applied to presentation slides t…
an image or object created or inserted into a document that i…
a print option that allows you to choose the number of slides…
Animation
the way text and objects move on and off a slide during a sli…
Design template/Theme
prepared designs that can be applied to presentation slides t…
40 terms
Computer Applications Excel Chp 1
An Excel _____ allows data easily to b…
The person or persons requesting the w…
The first step in creating an effectiv…
To enter data in a cell, you must firs…
worsheet
requirements
understand what is required
Cell
An Excel _____ allows data easily to b…
worsheet
The person or persons requesting the w…
requirements
12 terms
Computer Business Applications
storage device
memory
application software
system unit
external hardware used to store and retrieve data, such as a…
computer chips that store data and programs while the compute…
computer software created to allow the user to perform a spec…
a computer case that contains the CPU, power supply, memory,…
storage device
external hardware used to store and retrieve data, such as a…
memory
computer chips that store data and programs while the compute…
57 terms
Business Computer Applications
Change Line Spacing
Play slide show from beginning
Press______to advance to slides
To return to slide press
HOME tab- under paragraph group click line and paragraph spac…
SLIDE SHOW tab- from beginning
Spacebar
Page up function
Change Line Spacing
HOME tab- under paragraph group click line and paragraph spac…
Play slide show from beginning
SLIDE SHOW tab- from beginning
28 terms
Computer Applications (Excel Chapter 1)
Requirements document
When selecting a cell the mouse pointe…
Cancel box/Enter box
AutoCorrect feature
includes a needs statement, a source of data, a summary of... ca…
The mouse is a block plus sign mouse pointer.
If you type the wrong letter and notice the error before clic…
Works behind the scenes, correcting common mistakes when you…
Requirements document
includes a needs statement, a source of data, a summary of... ca…
When selecting a cell the mouse pointe…
The mouse is a block plus sign mouse pointer.
15 terms
Business computer applications
Artificial intelligence
ENIAC
Read only
IP address
Theory and development of computer systems able to perform ta…
Worlds first general purpose computer
Able to be accessed but not modified
Unique string of number separated by periods that identify ea…
Artificial intelligence
Theory and development of computer systems able to perform ta…
ENIAC
Worlds first general purpose computer
65 terms
NNU Computer Applications in Business
CTRL+ESC
Operating system
User account
Time and date
To display the Start screen, press _________.
An _______________ is a computer program that coordinates all…
Windows enables each user to establish a ____, which identifi…
The lock screen consists of ____.
CTRL+ESC
To display the Start screen, press _________.
Operating system
An _______________ is a computer program that coordinates all…
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
20 terms
Computer Business Application: EOC
Destination file
Embedded file
Integration
Linking
the file that is the current file being edited and where the…
file that becomes part of the current file but is a separate…
the sharing or combining of data between applications
placing a copy of an object or data in a destination file tha…
Destination file
the file that is the current file being edited and where the…
Embedded file
file that becomes part of the current file but is a separate…
10 terms
Computer application- Excel ch 1
Active Cell
Auto Fill
Fill handle
Formula
The current cell in a worksheet. It is indicated by a dark bo…
A feature that enables you to copy the contents of a cell or…
A small black square at the bottom-right corner of a cell use…
A combination of cell references, operators, values, and/or f…
Active Cell
The current cell in a worksheet. It is indicated by a dark bo…
Auto Fill
A feature that enables you to copy the contents of a cell or…
73 terms
Business Computing - Excel
spreadsheet
Concatenate
spreadsheet program
worksheet
an electronic file that contains a grid of columns and rows c…
adds strings of text together with " " separating words
a computer application used to create and modify spreadsheets
a spreadsheet that contains, formulas, functions, values, tex…
spreadsheet
an electronic file that contains a grid of columns and rows c…
Concatenate
adds strings of text together with " " separating words
16 terms
Business Computers Applications
Savings and Checking account
Types of savings
Rule of 72
social security and bank account
FDIC- federal deposit insurance corporation.... Principal: The a…
CD's: Certificate of Deposit... Different Lengths- Longer time=…
Time/interest rate=Double your investment or savings.
Bank... Employer... Driver License... Passports
Savings and Checking account
FDIC- federal deposit insurance corporation.... Principal: The a…
Types of savings
CD's: Certificate of Deposit... Different Lengths- Longer time=…
1 of 10