How can we help?

You can also find more resources in our Help Center.

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

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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

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…

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…

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…

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…

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…

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…

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

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…

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…

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…

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…

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…

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

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…

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…

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

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…

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

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…

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

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

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

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

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

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…

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…

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.

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

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…

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…

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

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…

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…

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…

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…

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…