How can we help?

You can also find more resources in our Help Center.

Study sets matching "business computer excel"

Study sets
Classes
Users

Study sets matching "business computer excel"

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
109 terms
Business Computing - Excel
spreadsheet
spreadsheet program
worksheet
workbook
an electronic file that contains a grid of columns and rows c…
a computer application used to create and modify spreadsheets
a spreadsheet that contains, formulas, functions, values, tex…
a file containing related worksheets
spreadsheet
an electronic file that contains a grid of columns and rows c…
spreadsheet program
a computer application used to create and modify spreadsheets
14 terms
Business Computing Excel Chapter 1
Spreadsheet
Worksheet
workbook
input area
electronic file that contains a grid od columns and rows cont…
A spreadsheet that contains formulas, functions, values, text…
a file containing related worksheets
a range of cells containing values and for variables used in…
Spreadsheet
electronic file that contains a grid od columns and rows cont…
Worksheet
A spreadsheet that contains formulas, functions, values, text…
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.
105 terms
Business computers (Word, Excel, Access, PowerPoint)
excel
template
slides
a context menu appears
What would be the best program to create a sales chart, inclu…
A __________ acts as a guideline in creating a document, work…
Your PowerPoint presentation is divided into __________.
What happens when you hover your mouse pointer over a button?
excel
What would be the best program to create a sales chart, inclu…
template
A __________ acts as a guideline in creating a document, work…
21 terms
Business Computing Excel BQuiz 10/18
5 things in a cell
6 dimensions of a cell
IF function
=IF(C2="Yes",1,2)
(1) formulas/functions... (2) logical values (true/false)... (3) er…
(1) number... (2) alignment... (3) border... (4) font... (5) fill... (6) pro…
=IF(something is true, then do something, otherwise do someth…
If C2 equals yes, then return a 1, otherwise return a 2
5 things in a cell
(1) formulas/functions... (2) logical values (true/false)... (3) er…
6 dimensions of a cell
(1) number... (2) alignment... (3) border... (4) font... (5) fill... (6) pro…
140 terms
Business computers (Word, Excel, Access, PowerPoint)
Quiz 1 Word and intro
What would be the best program to crea…
A __________ acts as a guideline in cr…
Your PowerPoint presentation is divide…
...
excel
template
slides
Quiz 1 Word and intro
...
What would be the best program to crea…
excel
20 terms
Computer excel
workbook
spreadsheet
worksheet
columns
an excel file with one or more worksheets is called a...
a grid of rows and columns in which they enter text, numbers,…
a computerized spreadsheet is called a... By default, each wo…
on a worksheet... appear vertically and are identified by let…
workbook
an excel file with one or more worksheets is called a...
spreadsheet
a grid of rows and columns in which they enter text, numbers,…
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…
100 terms
Computer excel
using auto fill is not as fast as copy…
All cells in a range touch each other…
computer software engineer is one of t…
when a cell is selected the column and…
false
true
true
true
using auto fill is not as fast as copy…
false
All cells in a range touch each other…
true
19 terms
Excel in Business
Analyze
Wholesale
Sales Tax
Mortgage
Examine methodically and in detail the constitution or struct…
A type of business that buys goods in large amounts and resel…
A percentage fee placed by the government on the sale of good…
A loan given to a home-buyer for part of the purchase price o…
Analyze
Examine methodically and in detail the constitution or struct…
Wholesale
A type of business that buys goods in large amounts and resel…
30 terms
Strive Computer Excel basics
Spreadsheet
Row
Cell
Column
A spreadsheet is a document that stores data in a grid of hor…
Horizontal line of cells
A Box that holds data
A vertical line of cells
Spreadsheet
A spreadsheet is a document that stores data in a grid of hor…
Row
Horizontal line of cells
12 terms
ISQS Exam 2; Computer Software, Excel, & Electronic Business Systems
Software
Software Includes:
Program
Syntax
receives signals from the CPU and gives the signals actions f…
Programming Language... Operating System ... General Purpose Applic…
a set of symbols and rules to write codes that can be interpr…
The rules of language
Software
receives signals from the CPU and gives the signals actions f…
Software Includes:
Programming Language... Operating System ... General Purpose Applic…
37 terms
computer excel
how are labels aligned
how are numbers aligned
where is cell content displayed
what does comma style apply
to the left
to the right
in function bar and cell itself
commas and two decimal points
how are labels aligned
to the left
how are numbers aligned
to the right
61 terms
Computer excel
Object
Contextual format
Picture, clip art
Sizing handles
Anything that appears on the screen that you can select wand…
Contextual tabs appear when you insert an object such as a sh…
You might use this to make the appearance of your worksheet m…
You use this to resize around the edge of a picture
Object
Anything that appears on the screen that you can select wand…
Contextual format
Contextual tabs appear when you insert an object such as a sh…
15 terms
Excel Computer
what does an equal sign do for functions
Range
IF Function
#DIV/0
starts the function off wouldn't work without it
From point to point number range
Comparison
divided by 0
what does an equal sign do for functions
starts the function off wouldn't work without it
Range
From point to point number range
40 terms
Computer excel
Workbooks
Name box
Select all button
Row heading
Excel stores spreadsheets in these files
Displays cell reference of active cell
Select all cells in worksheet
Numbers on left side of worksheet window
Workbooks
Excel stores spreadsheets in these files
Name box
Displays cell reference of active cell
25 terms
Computer Excel
Rows
Columns
Cells
Data
Run horizontally in an Excel worksheet
A vertical stack of cells in a table.
The rectangles that are formed when rows and columns intersect.
Information stored in cells
Rows
Run horizontally in an Excel worksheet
Columns
A vertical stack of cells in a table.
67 terms
computer excel
active cell
cell
cell address or cell reference
formula bar
the active cell contains the cell pointer. there is a dark ou…
the intersection of a column and a row on a worksheet. you en…
the location of a cell in a worksheet as identified by its co…
as you enter data in a cell, it simultaneously appears in the…
active cell
the active cell contains the cell pointer. there is a dark ou…
cell
the intersection of a column and a row on a worksheet. you en…
81 terms
Computer Excel
Row heading
Column heading
Default Format Excel
Cell style
Horizontal group of cells identified by numbers
Vertical group of cells identified by letters
Calibri, 11, general format
Defined formatting characteristics such as font, size, color,…
Row heading
Horizontal group of cells identified by numbers
Column heading
Vertical group of cells identified by letters
129 terms
Computer excel
Active window- the window in which you…
AutoRecover- a feature in some microso…
Backstage view- a feature of microsoft…
Byte- a unit used to measure storage c…
...
a feature in some microsoft office 2010 programs that automat…
a feature of microsoft office 2010 from which you access file…
a unit used to measure storage capacity. one byte equals abou…
Active window- the window in which you…
...
AutoRecover- a feature in some microso…
a feature in some microsoft office 2010 programs that automat…
20 terms
computer excel
In Excel, column designations are always
Row designations are always
When you click on the green check mark…
To move from one cell to an other, use…
letters
numbers
The contents are entered into the cell
up down left right tab enter
In Excel, column designations are always
letters
Row designations are always
numbers
10 terms
Computer - Excel
What is the significance of an equals…
Define the term range in reference to…
Explain the IF Function in Excel.
Explain the following errors in Excel…
a formula must begin with an equals sign
a selection of 2 or more cells
used to make a decision based on a comparison
1. the formula is trying to divide by 0 2. the formula contai…
What is the significance of an equals…
a formula must begin with an equals sign
Define the term range in reference to…
a selection of 2 or more cells
29 terms
Computers-- EXCEL
Fill handle
Cell address
Cell
Name box
Shows up as a back cross. Allows you to fill cell content eit…
Based on which column and row it intersects ... Example: C5
Each rectangle in a worksheet
A box that shows what your cell address is
Fill handle
Shows up as a back cross. Allows you to fill cell content eit…
Cell address
Based on which column and row it intersects ... Example: C5
40 terms
Computers:Excel
Absolute cell reference
Active cell
Adjacent cells
Boundary
A cell reference that does not change when copied because a d…
the cell displayed with a bold border. Also called the select…
cells that are next to each other
the bar separating the column letters at the top of the works…
Absolute cell reference
A cell reference that does not change when copied because a d…
Active cell
the cell displayed with a bold border. Also called the select…
Computer-Excel
Chart
Data point
Data series
Column chart
A visual representation of numerical data
A numeric value that describes a single value on a chart
A group of related data points in a chart
Displays data comparisons vertically in columns
Chart
A visual representation of numerical data
Data point
A numeric value that describes a single value on a chart
14 terms
Computers- Excel
Spreadsheet
Spreadsheets
Words, numbers, formulas
Labels
A tool that calculates numbers and data
Average grades, create budget, and calculate car payments
Information that can be used in a spreadsheet
Titles and text
Spreadsheet
A tool that calculates numbers and data
Spreadsheets
Average grades, create budget, and calculate car payments
12 terms
Computers Excel
Four major parts of Excel are.....
Workbook
Table
Web support
-workbooks and worksheets ... -charts... -table... -web support
A collection of worksheets... - allow user to enter, calculate,…
Organize and store data
-allows users to save worksheets or parts of a worksheet in H…
Four major parts of Excel are.....
-workbooks and worksheets ... -charts... -table... -web support
Workbook
A collection of worksheets... - allow user to enter, calculate,…
13 terms
Computers-Excel
What is excel?
What can Excel be used for
Worksheet
Cell
•software program... •enter facts and numbers... •organize facts... •s…
•complete projects... •make your schedule ... •show sports statisti…
The blank document in excel
The empty boxes that holds data
What is excel?
•software program... •enter facts and numbers... •organize facts... •s…
What can Excel be used for
•complete projects... •make your schedule ... •show sports statisti…
13 terms
Computer Tech - Excel Vocabulary
Bar Chart
Cell
Column Chart
Column
Bar Chart
Cell
24 terms
Computers Excel
Worksheet identifier that appears at t…
Cell reference area located below the…
Appears horizontally, identified by nu…
Which key do you press to move down on…
Sheet tab
Name box
Row
Down arrow key
Worksheet identifier that appears at t…
Sheet tab
Cell reference area located below the…
Name box
20 terms
Computers Excel
Organizes content in rows and columns
By numbers
By letters
Cell
What does Excel do?
How are the rows identified?
How are columns identified?
The intersection of each row and column is
Organizes content in rows and columns
What does Excel do?
By numbers
How are the rows identified?
10 terms
COMPUTER - EXCEL INFORMATION
Cell
Columns
Rows
Graphs / Charts
Each rectangle is called a cell
VERTICAL lines labeled with... ALPHABET. ----------
HORIZONTAL lines labels with NUMBERS... |||||||
C9lumns, Bar, Circle, Line
Cell
Each rectangle is called a cell
Columns
VERTICAL lines labeled with... ALPHABET. ----------
23 terms
EXCEL - BUSINESS
Active cell
Formula
Range
Comma style
The active cell is the cell you are currently working on. It…
Cell entry beginning with an = sign
A rectangular Group of cells referenced with the top left cel…
A number format option in Excel that inserts a comma in thous…
Active cell
The active cell is the cell you are currently working on. It…
Formula
Cell entry beginning with an = sign
15 terms
Computer business
Input Device
File management
Central Processing Unit ( CPU )
Memory
Data entered into the computer through a variety of devices s…
A program on a computer that allows the user to create, edit,…
Executes commands from a computer's hardware and software; th…
Computer chips that store data and programs while the compute…
Input Device
Data entered into the computer through a variety of devices s…
File management
A program on a computer that allows the user to create, edit,…
24 terms
Computer Apps - Excel Vocabulary List
absolute Cell Reference
arguments
ascending order
AVERAGE
A cell reference that does not change when copied because a d…
the data required by a function
in order from lowest to highest; also called alphabetical ord…
function that adds the values in a range of cells and then di…
absolute Cell Reference
A cell reference that does not change when copied because a d…
arguments
the data required by a function
10 terms
Business Excel
How to center Key board short cut
Key board shortcuts background color c…
how to make best fit?
How to Bold
Command-E
Command-1
Double Click Column Boundary
Command-B
How to center Key board short cut
Command-E
Key board shortcuts background color c…
Command-1
Computer Solutions- Excel Vocabulary
Absolute Cell Reference
Default
Active Cell
Formula
formula refers to a specific cell location. Absolute referenc…
A predetermined (by the manufacturer) setting for a particula…
contains the insertion point and is identified by a dark bord…
is a mathematical statement usually containing cell reference…
Absolute Cell Reference
formula refers to a specific cell location. Absolute referenc…
Default
A predetermined (by the manufacturer) setting for a particula…
16 terms
Business- excel
Spreadsheet
Cells
Letters
Numbers
A program used to work with numbers. It can do many types of…
Spreadsheets are grids made up of these little boxes
Columns are marked with these
rows are marked with these
Spreadsheet
A program used to work with numbers. It can do many types of…
Cells
Spreadsheets are grids made up of these little boxes
33 terms
Computer Literacy - Basic Computer Terms, Part 6 - Excel
Name Box
Formula Bar
Active Cell
Spreadsheet
In this field, you might see "A6". It tells you which is your…
In this field, you can see which of the three types of inform…
This is a cell that is ready to have information added or to…
Similar to a page in Word or a slide in Powerpoint
Name Box
In this field, you might see "A6". It tells you which is your…
Formula Bar
In this field, you can see which of the three types of inform…
10 terms
Computer I -- EXCEL Chapter 1C
Arithmetic (operators)
Formula
Order of precedence
SUM function
Symbols used in mathematical operations: +, -, *, /
An instruction Excel used to calculate a result.
The order in which Excel performs the mathematical operations…
A built-in calculation used to add a range of values together.
Arithmetic (operators)
Symbols used in mathematical operations: +, -, *, /
Formula
An instruction Excel used to calculate a result.
9 terms
Excel for computer apps
What is Microsoft Excel?
What is the ribbon?
How can I hide or show the ribbon?
How can you wrap the text within a cell?
an electronic worksheet used for organizing, storing and mani…
top of the application and is the replacement for the toolbar…
use of the CTRL and F1 key can show or hide this
by selecting the text you want and clicking a button on the h…
What is Microsoft Excel?
an electronic worksheet used for organizing, storing and mani…
What is the ribbon?
top of the application and is the replacement for the toolbar…
20 terms
Computer I -- EXCEL Chapter 1A
Active cell
The Backstage view
Cell
Formula bar
The active cell contains the cell pointer. There is a dark ou…
A feature of Microsoft Office 2013 from which you access file…
______ is the intersection of a column and a row on a workshe…
As you enter data in a cell, it simultaneously appears here,…
Active cell
The active cell contains the cell pointer. There is a dark ou…
The Backstage view
A feature of Microsoft Office 2013 from which you access file…
20 terms
Computer I -- EXCEL Chapter 2B
Conditional formatting
Data bars
Highlight cells rules
Icon sets
Variable formatting that changes the formatting applied based…
A type of conditional formatting that creates filled backgrou…
A method of applying conditional formatting based on how cell…
A type of conditional formatting that includes one of a set o…
Conditional formatting
Variable formatting that changes the formatting applied based…
Data bars
A type of conditional formatting that creates filled backgrou…
8 terms
Computer Excel Charts
Define Chart
Name the two ways a chart can be displ…
Clustered Column-
Stacked Column-
A graphic created from spreadsheet data
1. It is an imbedded object... 2. You can move it to its own she…
Shows a simple comparison between sets of numbers using verti…
Shows a simple comparison between sets of numbers using stack…
Define Chart
A graphic created from spreadsheet data
Name the two ways a chart can be displ…
1. It is an imbedded object... 2. You can move it to its own she…
20 terms
Computer I -- EXCEL Chapter 2A
Argument
AutoCalculate
Formula AutoComplete
Function
The values and other inputs that a function uses to calculate…
A feature that temporarily performs the following calculation…
A feature that speeds up the manual entry of functions.
A predefined formula that performs a specific calculation usi…
Argument
The values and other inputs that a function uses to calculate…
AutoCalculate
A feature that temporarily performs the following calculation…
42 terms
Computer Science: Excel
PMT
Average
Median
Counta
Function that calculates payment of a loan
Function to find the mean list
Function to find the middle value
Function used to count the non empty cells
PMT
Function that calculates payment of a loan
Average
Function to find the mean list
22 terms
Computer I -- EXCEL Chapter 1B
Accounting format
Cell Style
Comma format
Currency format
A style that vertically aligns dollar sign ($). Thousands sep…
A combination of a font, text color, cell color, and other fo…
Style that displays numbers with thousands separator
A style that displays dollar sign ($) immediately preceding t…
Accounting format
A style that vertically aligns dollar sign ($). Thousands sep…
Cell Style
A combination of a font, text color, cell color, and other fo…
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…
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/…
1 of 10