How can we help?

You can also find more resources in our Help Center.

Study sets matching "term:accounting = the ______________ number format displays numbers with a dollar sign, commas and decimals."

Study sets
Classes
Users

Study sets matching "term:accounting = the ______________ number format displays numbers with a dollar sign, commas and decimals."

20 terms
excel ch.2 vocabulary
accounting number format
arguments
asterisk
average function
with a dollar sign to the left to the number
the values that you use with a function
directs excel to perform the multiplication operation
sums the numbers in the specified rang and the divides the su…
accounting number format
with a dollar sign to the left to the number
arguments
the values that you use with a function
5 terms
excel terminology part 3 NUMBER FORMATTING
Accounting format
Comma Format
Currency format
Number format
A style that vertically aligns with dollar signs ($) thousand…
A style that displays numbers with the thousands separator ex…
A style that displays dollar signs immediately preceding the…
A format that controls how numerical data is displayed, inclu…
Accounting format
A style that vertically aligns with dollar signs ($) thousand…
Comma Format
A style that displays numbers with the thousands separator ex…
12 terms
Excel Number Formats
General
Number
Currency
Accounting
The Default format; displays numbers as typed. If the number…
Displays numbers with a fixed number of places to the right o…
Displays numbers preceded by a dollar sign with a thousands s…
Displays numbers in the Currency format but lines up the doll…
General
The Default format; displays numbers as typed. If the number…
Number
Displays numbers with a fixed number of places to the right o…
11 terms
Number formatting
General
Number
Currency
Accounting
The default number format; displays numbers as typed. If the…
Displays numbers with a fixed number of places to the right o…
Displays numbers preceded by dollar sign with thousands separ…
Displays numbers of the currency format but lines up the doll…
General
The default number format; displays numbers as typed. If the…
Number
Displays numbers with a fixed number of places to the right o…
12 terms
Excel Number Formats
General
Number
Currency
Accounting
The Default format; displays numbers as typed. If the number…
Displays numbers with a fixed number of places to the right o…
Displays numbers preceded by a dollar sign with a thousands s…
Displays numbers in the Currency format but lines up the doll…
General
The Default format; displays numbers as typed. If the number…
Number
Displays numbers with a fixed number of places to the right o…
14 terms
Excel ch. 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Both column and row references are relative. When copied to a…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
Both column and row references are relative. When copied to a…
12 terms
ACA Excel Number Formats
General
Number
Currency
Accounting
The Default format; displays numbers as typed. If the number…
Displays numbers with a fixed number of places to the right o…
Displays numbers preceded by a dollar sign with a thousands s…
Displays numbers in the Currency format but lines up the doll…
General
The Default format; displays numbers as typed. If the number…
Number
Displays numbers with a fixed number of places to the right o…
14 terms
Excel Chapter 2
Function
Relative Cell Reference
Order of operations
Point mode
A prewritten formula that makes it easy to perform common cal…
Both column and row references are relative. When copied to a…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula that makes it easy to perform common cal…
Relative Cell Reference
Both column and row references are relative. When copied to a…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
cell reference that adjusts to a new location when copied or…
Negation, percentages, exponentiation, multiplication, divisi…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
cell reference that adjusts to a new location when copied or…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Cell reference that adjusts to a new location when copied or…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
Cell reference that adjusts to a new location when copied or…
14 terms
Excel Chapter 2
Function
Relative cell reference (page EX 162)
Order of operations
Point mode
A prewritten formula built into Excel
B4 instructs Excel to adjust the cell reference as it copies…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference (page EX 162)
B4 instructs Excel to adjust the cell reference as it copies…
Business S2: Excel Number Formats
General
Number
Currency
Accounting
The default format; displays numbers as typed. If the number…
Displays numbers with a fixed number of places to the right o…
Displays numbers preceded by a dollar sign with a thousands s…
Displays numbers in the Currency format but lines up the doll…
General
The default format; displays numbers as typed. If the number…
Number
Displays numbers with a fixed number of places to the right o…
14 terms
Excel Chapter 2
Function
Relative Cell Reference
Order of Operations
Point Mode
A prewritten formula built into Excel
cell reference that adjusts to a new location when copied or…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative Cell Reference
cell reference that adjusts to a new location when copied or…
14 terms
Excell Chapter 2
Function
Relative Cell Reference
Order Of Operations
Point Mode
A prewritten formula built into Excel
A formula that adjust the cell reference as it is copied in =…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative Cell Reference
A formula that adjust the cell reference as it is copied in =…
14 terms
chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Cell reference that adjusts to a new location when copied or…
A set of rules for evaluating an expression involving more th…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
Cell reference that adjusts to a new location when copied or…
14 terms
Excel Chapter 2
Function
Relative cell reference (page EX 162)
Order of operations
Point mode
A prewritten formula built into Excel
instructs Excel to adjust the cell reference as it copies it…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference (page EX 162)
instructs Excel to adjust the cell reference as it copies it…
14 terms
Excel ch 2
function
relative cell reference
order of operations
point mode
A prewritten formula built into Excel
B4 instructs Excel to adjust the cell reference as it copies…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
function
A prewritten formula built into Excel
relative cell reference
B4 instructs Excel to adjust the cell reference as it copies…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Instruct excel to adjust the cell reference as it copies it t…
Negatives, percentages, exponential ions, multiplication, div…
Select cells and create formulas with the mouse, rather than…
Function
A prewritten formula built into Excel
Relative cell reference
Instruct excel to adjust the cell reference as it copies it t…
14 terms
Excel Chapter 2
Function... \
Relative Cell Reference
Order Of Operations
Point Mode
A prewrittem formula built into EXcel
cell reference that adjusts to a new location when copied or…
Negation, percentages, exponentiation, Multiplication, divisi…
Selected cells and create formulas with the mouse, rather the…
Function... \
A prewrittem formula built into EXcel
Relative Cell Reference
cell reference that adjusts to a new location when copied or…
14 terms
excel chapter 2
Function
Relative cell reference (page EX 162)
Order of operations
Point mode
A prewritten formula built into Excel
A cell address expressed in relation to the cell containing t…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference (page EX 162)
A cell address expressed in relation to the cell containing t…
14 terms
Excel Chapter 2 Vocabulary List
Function
Relative Reference
Order of Operations
Point Mode
Prewritten formula that is built into excel.
What each adjusted cell reference is called
Moving left to right, first negation (-), then all percentage…
Allows you to select cells for use in a formula by using the…
Function
Prewritten formula that is built into excel.
Relative Reference
What each adjusted cell reference is called
10 terms
Excel chapter 2
Function
Order of operations
Point mode
AVERAGE function
a prewritten formula that is built into Excel
First negation, then all percentages, then all exponentiation…
allows you to select cells for use in a formula by using the…
sums the numbers in the specified range and then divides the…
Function
a prewritten formula that is built into Excel
Order of operations
First negation, then all percentages, then all exponentiation…
10 terms
excel chapter 2
function
order of operation
point mode
AVERAGE function
A prewritten formula built into Excel
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Sums numbers then divides by the number of values
function
A prewritten formula built into Excel
order of operation
Negation, percentages, exponentiations, multiplication, divis…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
a prewritten formula built into excel
cell reference that adjusts to a new location when copied or…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
a prewritten formula built into excel
Relative cell reference
cell reference that adjusts to a new location when copied or…
14 terms
excel chapter 2
function
order of operation
point mode
AVERAGE function
A prewritten formula built into Excel
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Sums numbers then divides by the number of values
function
A prewritten formula built into Excel
order of operation
Negation, percentages, exponentiations, multiplication, divis…
14 terms
Excel Ch 2
Function
Order of operations
Point mode
AVERAGE function
A prewritten formula built into Excel
Negation, percentages, exponentiation, multiplication, divisi…
Select cells and create formulas with the mouse, rather then…
Sums numbers then divides by the number of values
Function
A prewritten formula built into Excel
Order of operations
Negation, percentages, exponentiation, multiplication, divisi…
14 terms
Excel Chapter 2 Vocabulary
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
What each adjusted cell is called
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
What each adjusted cell is called
14 terms
Excel Chapter 2 Vocab
Function
Relative Cell Reference
order of operations
Point mode
A prewritten formula built into Excel
Instructs excel to adjust the cell reference as it copies it…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative Cell Reference
Instructs excel to adjust the cell reference as it copies it…
14 terms
Excel Chapter 2 Vocab
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
When copied across multiple cells they change based on the re…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
When copied across multiple cells they change based on the re…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Displays a dollar sign in the far left of the cell
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
Displays a dollar sign in the far left of the cell
14 terms
Excel Chapter 2
function
relative cell referance
order of operation
point mode
A prewritten formula built into Excel
cell references are relative references. When copied across m…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
function
A prewritten formula built into Excel
relative cell referance
cell references are relative references. When copied across m…
14 terms
Chapter 2 Excel
Function
Retaliative Cell Reference
Order of Operations
Point mode
A prewritten formula built into Excel
both column and row is retaliative
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Retaliative Cell Reference
both column and row is retaliative
14 terms
Excel vocab Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
both column and row reference are relative. When copied to an…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
both column and row reference are relative. When copied to an…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
adjust the cell reference as it copies it to the destination
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
adjust the cell reference as it copies it to the destination
14 terms
excel chapter 2
Function
Relative cell reference
Order of operations
Point mode
If you type in the formula, you must start with an equal sign,
identifies the location of a cell or group of cells
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
If you type in the formula, you must start with an equal sign,
Relative cell reference
identifies the location of a cell or group of cells
14 terms
Excel Chapter 2
Function
Relative Cell Reference
Order of Operations
Point Mode
A prewritten formula built into Excel
What each adjusted cell reference is called
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative Cell Reference
What each adjusted cell reference is called
14 terms
Excel Chapter 2 Vocabulary
Function
Relative Cell Reference
Order of Operations
Point Mode
A prewritten formula built into Excel
What each adjusted cell reference is called
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative Cell Reference
What each adjusted cell reference is called
14 terms
Excel chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Cells adjust when copied
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
Cells adjust when copied
14 terms
Chapter 2 Excel Vocabulary
function
relative cell reference
order of operations
point mode
A prewritten formula built into Excel
Adjusts the cell reference as it copies it to the destination…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
function
A prewritten formula built into Excel
relative cell reference
Adjusts the cell reference as it copies it to the destination…
14 terms
Chapter 2 Excel
Function
Relative cell reference (page EX 162)
Order of operations
Point mode
A prewritten formula built into Excel
A formula to adjust the cell as it copies it to the destinati…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference (page EX 162)
A formula to adjust the cell as it copies it to the destinati…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
all cell references are relative references.
Negation, percentages, exponentiations, multiplication, divis…
If you press any keyboard navigation key (such as Page Up, Pa…
Function
A prewritten formula built into Excel
Relative cell reference
all cell references are relative references.
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
identifies the location of a cell or group of cells
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
identifies the location of a cell or group of cells
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
is a prewritten formula that is built into excel
both column and row references are relative. when copied to a…
is as follows: first negation(-),(%),(^),(*),(/),(+),(-) subt…
allows you to select cells for use in a formula by using the…
Function
is a prewritten formula that is built into excel
Relative cell reference
both column and row references are relative. when copied to a…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point made
A prewritten formula built into Excel
instructs excel to adjust the cell reference as it copies it…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
instructs excel to adjust the cell reference as it copies it…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
Adjust the cell reference as it copies to the destination area
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
Adjust the cell reference as it copies to the destination area
Excel Chapter 1
Function
Relative cell reference
Order of operations
Point mode
Sums numbers then divides by the number of values
Excel to adjust the cell reference as it copies it to the des…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
Sums numbers then divides by the number of values
Relative cell reference
Excel to adjust the cell reference as it copies it to the des…
14 terms
Excel Chapter 2
Function
Relative Cell Reference
Order of Operation
Point Mode
A formula for a set of numbers
Cell reference that adjusts to a new location when copied or…
Displays the lowest value for a range of values
Select cells and create formulas with the mouse, rather then…
Function
A formula for a set of numbers
Relative Cell Reference
Cell reference that adjusts to a new location when copied or…
14 terms
Excel Chapter 2 Vocabulary
Function
Relative Cell Reference
Order of Operations
Point Mode
A prewritten formula built into Excel
When copied into another cell, both the column and row in the…
Negation, Percentages, Exponentiations, Multiplication, Divis…
Select cells and create formulas with the mouse, rather than…
Function
A prewritten formula built into Excel
Relative Cell Reference
When copied into another cell, both the column and row in the…
14 terms
Excel Chapter 2
Function
Relative cell reference
Order of operations
Point mode
A prewritten formula built into Excel
When copied across multiple cells, they change based on the r…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference
When copied across multiple cells, they change based on the r…
14 terms
excel chapter 2
Function
Relative cell reference (page EX 162)
Order of operations
Point mode
A prewritten formula built into Excel
B4 instructs excel to adjust the cell reference as it copies…
Negation, percentages, exponentiations, multiplication, divis…
Select cells and create formulas with the mouse, rather then…
Function
A prewritten formula built into Excel
Relative cell reference (page EX 162)
B4 instructs excel to adjust the cell reference as it copies…
1 of 10