Study sets matching "computer chapter 2 excel"

Study sets
Classes
Users

Study sets matching "computer chapter 2 excel"

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…
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…
Computer App- Excel Chapter 2
Fixed Dollar Sign
Arugments
Average Function
Comma Style
Dollar sign is as far left of cell with space between the sig…
Values used with a function.
Sum of a range of numbers divided by number of cells in the r…
Inserts a comma every three positions. Rounds to the nearest…
Fixed Dollar Sign
Dollar sign is as far left of cell with space between the sig…
Arugments
Values used with a function.
23 terms
Computer Apps: Excel Chapter 2
Function
Formula
Circular Reference
Indirect Circular Reference
prewritten formula built into Excel
series of numbers with operation signs; mathematical equation
formula in a cell that contains a reference back to itself
formula in a cell refers to another cell
Function
prewritten formula built into Excel
Formula
series of numbers with operation signs; mathematical equation
32 terms
Computer Apps Chapter 2 study guide -Excel
Argument
AutoCalculate
Formula AutoComplete
Function
The values and other inputs that a functions uses to calculat…
A featuare that temporary preforms the fallowing calculations…
A feature that speeds up the manually entry of funtions
A predefined formula that performs a specific calculation usi…
Argument
The values and other inputs that a functions uses to calculat…
AutoCalculate
A featuare that temporary preforms the fallowing calculations…
SIA Computer Excel Chapter 2 Multiple Choice
Worksheet
requirements
understand what is required
cell
An Excel ____________ allows data easliy to be summarized and…
The person or persons requesting the worksheet should supply…
the first step in creating an effective worksheet is to make…
to enter data in the cell, you must first select or activate…
Worksheet
An Excel ____________ allows data easliy to be summarized and…
requirements
The person or persons requesting the worksheet should supply…
SIA Computer Chapter 2 Excel True/False
True
False
False
True
A requirements document includes a needs statement, source of…
Worksheet titles and subtitles should be as wordy as possible
A thin red border indicates the active cell, as shown in the…
Both the Cancel Box and the Enter Box appear on the formula b…
True
A requirements document includes a needs statement, source of…
False
Worksheet titles and subtitles should be as wordy as possible
SIA Computer Chapter 2 Excel True/False
True
False
False
True
A requirements document includes a needs statement, source of…
Worksheet titles and subtitles should be as wordy as possible
A thin red border indicates the active cell, as shown in the…
Both the Cancel Box and the Enter Box appear on the formula b…
True
A requirements document includes a needs statement, source of…
False
Worksheet titles and subtitles should be as wordy as possible
Computer Applications 1 Excel Chapter 2 Study
Function
How do you make the words in a column…
What does this symbol mean -
what overrides the order of operations?
a prewritten formula that is built into excel
ALT Enter
negation
parenthesis
Function
a prewritten formula that is built into excel
How do you make the words in a column…
ALT Enter
Computer 1-- 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…
Computer 1-- 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…
26 terms
Excel Chapter 2
AVERAGE Function
Conditional format
COUNT
COUNTIF Function
An Excel function that adds a group of values, and then divid…
A format that changes the appearance of a cell - for example,…
A statistical function that counts the number of cells in a r…
A statistical function that counts the number of cells within…
AVERAGE Function
An Excel function that adds a group of values, and then divid…
Conditional format
A format that changes the appearance of a cell - for example,…
Excel Chapter 2
Print titles
Find and Replace
Excel Table
Statistical Function
Command that enables you to specify rows and columns to repea…
Command that searches the cells in a worksheet-or selected ra…
Series of rows and columns that contains related data that is…
Used to analyze a group of measurements
Print titles
Command that enables you to specify rows and columns to repea…
Find and Replace
Command that searches the cells in a worksheet-or selected ra…
15 terms
Excel Chapter 2
Function
Formula
Order of operations
Point mode
A pre-written formula that is built into Excel
A mathematical expression that Excel uses to calculate a result
Formulas are read from left to right in this order: (1) negat…
Allows you to select cells for use in a formula by using the…
Function
A pre-written formula that is built into Excel
Formula
A mathematical expression that Excel uses to calculate a result
27 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…
25 terms
Excel Chapter 2 Vocabulary
Argument
Formulas AutoComplete
Functions
Function Name
The values and other inputs that a function uses to calculate…
A Features that speeds up the manual entry of functions
A predefined formula that performs a specific calculation usi…
the name given to one of Excel's predefined formulas
Argument
The values and other inputs that a function uses to calculate…
Formulas AutoComplete
A Features that speeds up the manual entry of functions
25 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…
23 terms
Microsoft Excel Chapter 2
MIN
MAX
Valid Arithmetic Operators
Point mode
Function that determines the lowest number in a range.
Function that determines the highest number in a range.
- % ^ * / +
When you select cells for use in a formula by using the mouse…
MIN
Function that determines the lowest number in a range.
MAX
Function that determines the highest number in a range.
6 terms
computer Excel chap 2 terms
range name
conditional formating
freeze
filter
an identifying label assigned to a group of cells.... also known…
changes the formatting applied based on the contents of the c…
a method to keep specified rows anf columns- usually ones con…
to display only certain records. ... 1. by form: use a form to e…
range name
an identifying label assigned to a group of cells.... also known…
conditional formating
changes the formatting applied based on the contents of the c…
Computer Tech St 2: Excel
rows
columns
cells
active cell
a horizontal series of cells in a chart, table, or spreadsheet
a vertical series of cells in a chart, table, or spreadsheet
intersection of a row and a column
selected cell in which data is entered when you begin typing
rows
a horizontal series of cells in a chart, table, or spreadsheet
columns
a vertical series of cells in a chart, table, or spreadsheet
6 terms
Excel Chapter 2
copy
cut
fill handle
formula bar
takes the information from one location and duplicates it
removing data from a worksheet, but it is still located on th…
a small square in the lower-right corner of a selected cell
place between ribbon and worksheet where you can make changes…
copy
takes the information from one location and duplicates it
cut
removing data from a worksheet, but it is still located on th…
Excel Chapter 2
Accounting Number Format
arguments
asterisk
AVERAGE function
displays numbers with a dollar sign to the left of the number…
the information necessary to calculate the answer
a star-shaped character * used in printing also used in multi…
sums the numbers in the specified range and then divides the…
Accounting Number Format
displays numbers with a dollar sign to the left of the number…
arguments
the information necessary to calculate the answer
Excel Chapter 2
Accounting Number Format
arguments
asterisk
AVERAGE function
displays numbers with a dollar sign to the left of the number…
the information necessary to calculate the answer
a star-shaped character * used in printing
sums the numbers in the specified range and then divides the…
Accounting Number Format
displays numbers with a dollar sign to the left of the number…
arguments
the information necessary to calculate the answer
Excel Chapter 2
Accounting Number Format
arguments
asterisk
AVERAGE function
displays numbers with a dollar sign to the left of the number…
the information necessary to calculate the answer
a star-shaped character * used in printing also used in multi…
sums the numbers in the specified range and then divides the…
Accounting Number Format
displays numbers with a dollar sign to the left of the number…
arguments
the information necessary to calculate the answer
10 terms
Computer Excel Chapter 3
1. What do you do to emphasize a parti…
2. This finds the input needed in one…
3. Whole goal of Excel is to do ______…
4. This shape effect caused the edges…
Explode (pull the slice out from the rest of the chart)
Goal Seek
What If Analysis
Bevel
1. What do you do to emphasize a parti…
Explode (pull the slice out from the rest of the chart)
2. This finds the input needed in one…
Goal Seek
10 terms
computer excel vocab #2
Absolute reference
Relative reference
Transpose
Argument
A cell address in a formula that will not change when you cop…
A cell address that can change in a copied formula
A method to rearrange data by switching the positions of colu…
The values and other inputs that a function uses to calculate…
Absolute reference
A cell address in a formula that will not change when you cop…
Relative reference
A cell address that can change in a copied formula
Computer app excel ch 2
Arguments
Average function
Comparison operators
Conditional format
Values that an excel function uses to perform calculatikns or…
Excel function that adds a group of value and then divides th…
Symbols that evaluate each value to determine if it is the sa…
Changes appearance of a cell
Arguments
Values that an excel function uses to perform calculatikns or…
Average function
Excel function that adds a group of value and then divides th…
Computer Apps Excel Ch 2
Accounting Number Format
arguments
Auto Fill Options
AVERAGE function
Displays numbers with a dollar sign to the left and inserts a…
The values that are used with a function
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 Format
Displays numbers with a dollar sign to the left and inserts a…
arguments
The values that are used with a function
Excel Chapter 2
A set of rules that governs the struct…
Displays the current date.
Indicates a cell's specific location;…
Occurs when a formula directly or indi…
Syntax
TODAY function
Absolute cell reference
Circular reference
A set of rules that governs the struct…
Syntax
Displays the current date.
TODAY function
50 terms
Excel Chapter 1 (2)- NWCC Computer Concepts
A ______ is a prewritten formula that…
To start a new line in a cell, press t…
When you enter a two-digit year that i…
A(n) ______ circular reference occurs…
A. Function
C. ALT + Enter
A. 20xx
D. Indirect
A ______ is a prewritten formula that…
A. Function
To start a new line in a cell, press t…
C. ALT + Enter
18 terms
Excel Chapter 2
A _____ is a prewritten formula that i…
To start a new line in a cell, press t…
Which of the following calculations mu…
When more than one arithmetic operator…
function
ALT+ENTER
=23%
operations
A _____ is a prewritten formula that i…
function
To start a new line in a cell, press t…
ALT+ENTER
36 terms
Excel Chapter 2
Accounting Number Format
arguments
asterisk
AVERAGE function
displays numbers with a dollar sign to the left of the number…
the information necessary to calculate the answer
a star-shaped character * used in printing
sums the numbers in the specified range and then divides the…
Accounting Number Format
displays numbers with a dollar sign to the left of the number…
arguments
the information necessary to calculate the answer
29 terms
Excel - Chapter 2
Accounting Number Format
arguments
AVERAGE function
best fit
displays numbers with a dollar sign all the way in the left m…
the values within the parentheses that you use with a functio…
sums the numbers in the specified range and then divides the…
means that the width of the column will be increased or decre…
Accounting Number Format
displays numbers with a dollar sign all the way in the left m…
arguments
the values within the parentheses that you use with a functio…
27 terms
Computer I -- EXCEL Chapter 3
Categories
Chart
Chart sheet
Column chart
In most cases, each column of charted worksheet.
A graphic that compares and contrasts worksheet data in a vis…
A chart that occupies its own worksheet
The default chart type that displays each data point as a ver…
Categories
In most cases, each column of charted worksheet.
Chart
A graphic that compares and contrasts worksheet data in a vis…
22 terms
Excel Chapter 2
flash fill
formula
circular reference
direct circular reference
feature that looks for patterns in the data and automatically…
consists of cell references, numbers, and arithmetic operator…
formula in a cell that contains a reference back to itself
occurs when a formula refers to the same cell in which it is…
flash fill
feature that looks for patterns in the data and automatically…
formula
consists of cell references, numbers, and arithmetic operator…
20 terms
Excel Chapter 2
Function
Formula
Circular Reference
Indirect Circular Reference
A pre-written formula that is built into Excel.
An expression telling the computer what mathematical operatio…
A formula in a cell that contains a reference back to itself.
Occurs when a formula in a cell refers to another cell or cel…
Function
A pre-written formula that is built into Excel.
Formula
An expression telling the computer what mathematical operatio…
38 terms
Excel Chapter 2
Addition
Autofill Options
Average Function
Best Fit
Arithmetic operator that adds contents of cells
Button that gives options for how to fill cells following a f…
Sums numbers then divides by the number of values
The width of the column will increase or decrease so the wide…
Addition
Arithmetic operator that adds contents of cells
Autofill Options
Button that gives options for how to fill cells following a f…
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.
36 terms
Excel Chapter 2
Accounting Number Format
arguments
asterisk
AVERAGE function
displays numbers with a dollar sign to the left of the number…
the information necessary to calculate the answer
a star-shaped character * used in printing
sums the numbers in the specified range and then divides the…
Accounting Number Format
displays numbers with a dollar sign to the left of the number…
arguments
the information necessary to calculate the answer
20 terms
Microsoft Excel Chapter 2
A command with which you can display t…
A cell reference that refers to a cell…
Rules that specify the way numbers sho…
The Default value applied to numbers
Text Wrap
Absolute Cell Reference
Number Format
General Format
A command with which you can display t…
Text Wrap
A cell reference that refers to a cell…
Absolute Cell Reference
24 terms
Chapter 2 Excel Vocabulary
asterisk
best fit
circular reference
debugging
is a arithmetic operator that directs excel to preform the mu…
that the width of the column will increase or decrease so tha…
a formula in a cell that contains a reference back to itself
is the process of finding and correcting errors in the worksh…
asterisk
is a arithmetic operator that directs excel to preform the mu…
best fit
that the width of the column will increase or decrease so tha…
17 terms
excel chapter 2
Auto Fill
AutoComplete
copy
copy pointer
Excel provides Auto Fill options that automatically fill cell…
If the first few characters that you type in a column match a…
Copy takes the information from one location and duplicates it.
When the pointer becomes a copy pointer (arrow with a plus),…
Auto Fill
Excel provides Auto Fill options that automatically fill cell…
AutoComplete
If the first few characters that you type in a column match a…
5 terms
Excel Chapter 2
copy
paste
fill handle
range
takes information from one location and duplicates it
used to put information in a location
small square in lower right corner of the cell
group of adjacent cells
copy
takes information from one location and duplicates it
paste
used to put information in a location
32 terms
Excel Chapter 2
function
statistical functions
SUM function
arguments
a predefined formula that performs calculations by using spec…
Functions used to describe large quantities of data; average,…
a predefined formula that adds all the numbers in a selected…
the values that an Excel function uses to perform calculation…
function
a predefined formula that performs calculations by using spec…
statistical functions
Functions used to describe large quantities of data; average,…
Excel Chapter 2
A relative cell reference
An absolute cell reference
A mixed cell reference
A circular reference
indicates a cells relative location from the cells containing…
indicates a cells specific location and the reference does no…
Contains both an absolute and a relative cell reference
occurs when a formula directly or indirectly refers to the ce…
A relative cell reference
indicates a cells relative location from the cells containing…
An absolute cell reference
indicates a cells specific location and the reference does no…
17 terms
Excel chapter 2 vocabulary
Auto fill
Auto complete
Copy
Copy pointer
Automatically fill cells with data and or formatting
Feature works only for entries that contain text or à combinâ…
Takes the information from one location and duplicates it
You can drag the cell or range of cells to the new location
Auto fill
Automatically fill cells with data and or formatting
Auto complete
Feature works only for entries that contain text or à combinâ…
7 terms
Excel Chapter 2 Terms
default settings
definitive command
document properties
fast command
standard settings installed by an application as presets so t…
a command that closes Backstage view and returns the user to…
document information that identifies who created the document…
a command that provides quick access to common functions and…
default settings
standard settings installed by an application as presets so t…
definitive command
a command that closes Backstage view and returns the user to…
20 terms
Excel Chapter 2
text wrap
absolute cell reference
number format
general format
a command with which you can display text on multiple lines w…
a cell reference that refers to a cell by its fixed position…
rules that specify the way numbers should display
the default format applied to numbers
text wrap
a command with which you can display text on multiple lines w…
absolute cell reference
a cell reference that refers to a cell by its fixed position…
Excel Chapter 2 -B
Case
Concatenation
Freeze
Panes
The use of capital and small letters in text.
The linking of elements together in a series.
A method to keep specified rows and columns—usually ones cont…
Sections or areas in a window that enable you to see differen…
Case
The use of capital and small letters in text.
Concatenation
The linking of elements together in a series.
Excel Chapter 2 -A
Argument
AutoCalculate
Formula AutoComplete
Functions
The values and other unputs 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 predefind formula that performs a specific calculation usin…
Argument
The values and other unputs that a function uses to calculate…
AutoCalculate
A feature that temporarily performs the following calculation…
1 of 10