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

Study sets

Classes

Users

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 sum…

accounting number format

with a dollar sign to the left to the number

arguments

the values that you use with a function

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 exa…

A style that displays dollar signs immediately preceding the n…

A format that controls how numerical data is displayed, includ…

Accounting format

A style that vertically aligns with dollar signs ($) thousand…

Comma Format

A style that displays numbers with the thousands separator exa…

General

Number

Currency

Accounting

1000 ... The default number format; displays numbers as typed. If…

1000.00 ... Displays numbers with a fixed number of places to the…

$1,000.00 ... Displays numbers preceded by a dollar sign with a t…

$1,000.00... $ 9.00 ... Displays numbers in the Currency format but…

General

1000 ... The default number format; displays numbers as typed. If…

Number

1000.00 ... Displays numbers with a fixed number of places to the…

Absolute Cell Reference

accounting number format

Comma style format

fill handle

cell reference that does not adjust to the new cell location w…

Displays numbers with a dollar sign to the left and inserts a…

...

...

Absolute Cell Reference

cell reference that does not adjust to the new cell location w…

accounting number format

Displays numbers with a dollar sign to the left and inserts a…

General

Number

Currency

Accounting

The Default format; displays numbers as typed. If the number d…

Displays numbers with a fixed number of places to the right of…

Displays numbers preceded by a dollar sign with a thousands se…

Displays numbers in the Currency format but lines up the dolla…

General

The Default format; displays numbers as typed. If the number d…

Number

Displays numbers with a fixed number of places to the right of…

function

relative cell reference

order of operations

point mode

Can be assigned to a cell and will display calculated result

a cell the is a reference

process of math

the mode of point

function

Can be assigned to a cell and will display calculated result

relative cell reference

a cell the is a reference

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 an…

Negation, percentages, exponentiations, multiplication, divisi…

Select cells and create formulas with the mouse, rather then t…

Function

A prewritten formula built into Excel

Relative cell reference

Both column and row references are relative. When copied to an…

General

Number

Currency

Accounting

The default format; displays numbers as typed. If the number d…

Displays numbers with a fixed number of places to the right of…

Displays numbers preceded by a dollar sign with a thousands se…

Displays numbers in the Currency format but lines up the dolla…

General

The default format; displays numbers as typed. If the number d…

Number

Displays numbers with a fixed number of places to the right of…

Cell style

Currency format

Accounting format

Comma format

A combination of a front, text color, cell color, and other fr…

A style that displays dollar signs($) immediately preceding th…

A style that vertically aligns with dollar signs ($), thousand…

A style that displays numbers with a thousands separator (,)

Cell style

A combination of a front, text color, cell color, and other fr…

Currency format

A style that displays dollar signs($) immediately preceding th…

Cell style

Currency format

Accounting format

Comma format

A combination of a font, text color, and other font attributes…

A style that displays dollar signs immediately preceding the n…

A style that vertically aligns with dollar signs ($), thousand…

A style that displays numbers with a thousands separator

Cell style

A combination of a font, text color, and other font attributes…

Currency format

A style that displays dollar signs immediately preceding the n…

Cell style

Currency format

Accounting format

Comma format

A combination of a font, text color, cell color, and other fon…

A style that displays dollar signs ($) immediately preceding t…

A style that vertically aligns with dollar signs ($), thousand…

A style that displays numbers with a thousands separator (,)

Cell style

A combination of a font, text color, cell color, and other fon…

Currency format

A style that displays dollar signs ($) immediately preceding t…

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 m…

negation, percentages, exponentiations, multiplication, divisi…

select cells and create formulas with the mouse, rather then t…

function

a prewritten formula built into Excel

relative cell reference

cell reference that adjusts to a new location when copied or m…

General

Number

Currency

Accounting

The Default format; displays numbers as typed. If the number d…

Displays numbers with a fixed number of places to the right of…

Displays numbers preceded by a dollar sign with a thousands se…

Displays numbers in the Currency format but lines up the dolla…

General

The Default format; displays numbers as typed. If the number d…

Number

Displays numbers with a fixed number of places to the right of…

Function

Relative cell refrence

Order of operations

Point mode

A prewritten formula built into Excel. one word access to a se…

Both column and row references are relative. When copied to an…

Negation, percentages, exponentiations, multiplication, divisi…

Select cells and create formulas with the mouse, rather then t…

Function

A prewritten formula built into Excel. one word access to a se…

Relative cell refrence

Both column and row references are relative. When copied to an…

Function

Relative Cell Reference

Order of Operations

Point Mode

A prewritten formula built into Excel

Formula in Excel to adjust the cell reference as it copies it…

Negation, percentages, exponentiations, multiplication, divisi…

Select cells and create formulas with the mouse, rather then t…

Function

A prewritten formula built into Excel

Relative Cell Reference

Formula in Excel to adjust the cell reference as it copies it…

Accounting Number Format

arguments

asterisk

AVERAGE function

with dollar sign to the left of the number ,inserts a comma ev…

the value that you use with a function arguments

...

sums the numbers in the specified range and then divides the s…

Accounting Number Format

with dollar sign to the left of the number ,inserts a comma ev…

arguments

the value that you use with a function arguments

Cell style

Currency format

Accounting format

Comma format

A combinanion of a font, text color, cell color, and other for…

A style that displays dollar sifns ($) iimmediately precedingn…

A style that vertically aligns with dollar signs ($) and thous…

A style that displays numbers with a thousands separator (,)

Cell style

A combinanion of a font, text color, cell color, and other for…

Currency format

A style that displays dollar sifns ($) iimmediately precedingn…

function

order of operation

point mode

AVERAGE function

A prewritten formula built into Excel

Negation, percentages, exponentiations, multiplication, divisi…

Select cells and create formulas with the mouse, rather then t…

Sums numbers then divides by the number of values

function

A prewritten formula built into Excel

order of operation

Negation, percentages, exponentiations, multiplication, divisi…

Function

Relative cell reference

Order of operations

Point mode

A prewritten formula built into Excel

Technique used to hide data that is sensitive or not relative

Negation, percentages, multiplication, division, addition, sub…

Select cells and create formulas with the mouse, rather then t…

Function

A prewritten formula built into Excel

Relative cell reference

Technique used to hide data that is sensitive or not relative

General

Number

Currency

Accounting

The Default format; displays numbers as typed. If the number d…

Displays numbers with a fixed number of places to the right of…

Displays numbers preceded by a dollar sign with a thousands se…

Displays numbers in the Currency format but lines up the dolla…

General

The Default format; displays numbers as typed. If the number d…

Number

Displays numbers with a fixed number of places to the right of…

function

order of operation

point mode

AVERAGE function

A prewritten formula built into Excel

Negation, percentages, exponentiations, multiplication, divisi…

Select cells and create formulas with the mouse, rather then t…

Sums numbers then divides by the number of values

function

A prewritten formula built into Excel

order of operation

Negation, percentages, exponentiations, multiplication, divisi…

function

relative cell reference

order of operations

point mode

a prewritten formula that is build into Excel

both column and row references adjust to reflect new location…

moving from left to right; first negatives, percentages, all e…

allows you to select cells for use in a formula by using the m…

function

a prewritten formula that is build into Excel

relative cell reference

both column and row references adjust to reflect new location…

Accounting number format

Average Fuction

Conditional Formatting

Currency Style Format

With the dollar sign to the left, inserts a comma every three…

Sums numbers then divides by the number of values

Applied formatting only when value meets specified condition

Formats currency by using decimals and commas

Accounting number format

With the dollar sign to the left, inserts a comma every three…

Average Fuction

Sums numbers then divides by the number of values

Function

Order of operations

Point mode

AVERAGE function

A prewritten formula built into Excel

Negation, percentages, exponentiation, multiplication, divisio…

Select cells and create formulas with the mouse, rather then t…

Sums numbers then divides by the number of values

Function

A prewritten formula built into Excel

Order of operations

Negation, percentages, exponentiation, multiplication, divisio…

Cell style

Currency format

Accounting format

Comma format

A combination of a font, text color, cell color and other font…

a style that displays dollar signs. ($) imeedietly proceding t…

A style that vertically aligns with dollar signs ($) thousands…

a Style that displays numbers with a thoughsands separator

Cell style

A combination of a font, text color, cell color and other font…

Currency format

a style that displays dollar signs. ($) imeedietly proceding t…