How can we help?

You can also find more resources in our Help Center.

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…
40 terms
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…
25 terms
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
25 terms
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
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,…
20 terms
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…
20 terms
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…
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
29 terms
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…
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.
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
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…
20 terms
Excel Chapter 2
active cell
AutoComplete
AutoFilter
Backstage view
The worksheet cell that contains the cell cursor. Each worksh…
A feature that looks at the entries that you make in a worksh…
A feature in Excel 2010 that enables you to temporarily hide…
A new feature in Excel 2010 — accessible from the green File…
active cell
The worksheet cell that contains the cell cursor. Each worksh…
AutoComplete
A feature that looks at the entries that you make in a worksh…
47 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 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
34 terms
Excel Chapter 2
AVERAGE Function
Arguments
Comparison Operators
Conditional format
An Excel function that adds a group of values, and then divid…
The values that an Excel function uses to perform calculation…
Symbols that evaluate each value to determine if it is the sa…
A format that changes the appearance of a cell - for example,…
AVERAGE Function
An Excel function that adds a group of values, and then divid…
Arguments
The values that an Excel function uses to perform calculation…
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
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…
49 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 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
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…
11 terms
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
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…
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…
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…
30 terms
Excel Chapter 2
Formula
Order of operations
Point mode
AVERAGE function
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…
Sums the numbers in a range and then divides by the number of…
Formula
A mathematical expression that Excel uses to calculate a result
Order of operations
Formulas are read from left to right in this order: (1) negat…
25 terms
Excel Chapter 2
Conditional format
COUNT
COUNTIF Function
Criteria
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…
Conditions that you specify in a logical function.
Conditional format
A format that changes the appearance of a cell - for example,…
COUNT
A statistical function that counts the number of cells in a r…
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
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,…
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
29 terms
Excel 2010: Chapter 2
A ___ is a prewritten formula that is…
An ___ alerts Excel that you are enter…
Values used with a function are called…
The order in which calculations are pe…
Function
Equal Sign
Arguments
Order of Operations
A ___ is a prewritten formula that is…
Function
An ___ alerts Excel that you are enter…
Equal Sign
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
29 terms
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…
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
41 terms
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
18 terms
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…
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
17 terms
Computer Apps: Excel Lesson 2
cell content
budget
enter
functions
the words, numbers, or both contained in each cell in a works…
an estimate of income and expenses over time
to move from one cell to the cell below
built in formulas within Excel
cell content
the words, numbers, or both contained in each cell in a works…
budget
an estimate of income and expenses over time
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
18 terms
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.
13 terms
Excel 2013 Chapter 2
Argument
AutoCalculate
Criterion
Excel Table
The values and other inputs that a function uses to calculate…
A feature that temporarily performs the following calculation…
A value, some text, or an expression that defines the type of…
Data arranged in columns and specially formatted with column…
Argument
The values and other inputs that a function uses to calculate…
AutoCalculate
A feature that temporarily performs the following calculation…
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
Equal Sign
Row references
Min function
Max function
Formulas start with this
Updates automatically when fill handle is used
Lowest number in a range
Highest number in a range
Equal Sign
Formulas start with this
Row references
Updates automatically when fill handle is used
19 terms
Excel Chapter 2
Accounting Number Format
Arguments
Average Function
Best Fit
Puts a dollar sign to the left of the number, inserts a comma…
The values that you use with a function Ex =SUM(A1:A10)
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
Puts a dollar sign to the left of the number, inserts a comma…
Arguments
The values that you use with a function Ex =SUM(A1:A10)
32 terms
Chapter 2 Excel
Function
Statistical Functions
SUM Function
AVERAGE Function
A predefined formula that performs calculations by using spec…
Excel functions, such as AVERAGE, that are useful to analyze…
A predefined formula that adds all the numbers in a selected…
An Excel function that adds a group of values and then divide…
Function
A predefined formula that performs calculations by using spec…
Statistical Functions
Excel functions, such as AVERAGE, that are useful to analyze…
1 of 10