Advertisement Upgrade to remove ads

Accounting Number Format

assigns the desired Accounting number format

arguments

the values that you use with a function

asterisk

following d4 is the arithmetic operator that directs Excel to perform the multiplication operation

AVERAGE function

sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range

best fit

the width of the column will be increased or decreased so the widest entry will fit in the column

blank cell

in Excel, has a numerical value of zero, which would have resulted in an error message

Comma style format

can be assigned to a range of cells by clicking the Comma Style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths

condition

which is made up of two values and a relational operator , is true or false for each cell in the range

conditional formatting

formatting that appears only when the value in a cell meets conditions that you specify

debugging

the process of finding and correcting errors in the worksheet

e-mail

electronice mail, the electronic transmission of messages and files to and from other computers using the internet

equal sign

preceding d4*e4 is an important part of the formula, it alerts excel that you are entering a formula or function and not text

fixed dollar sign

to the far left in the cell, often with spaces between it and the first digit

floating dollar sign

appears immediately to the left of the first digit with no spaces, use the Currency style in the Format Cells dialog box

formula

assign it to excel and it will calculate a result

formulas version

shows the actual formulas you have entered rather than the resulting values

function

a prewritten formula that is built into Excel

hiding cells

a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see

landscape orientation

means the printout is printed across the length of the page

MAX function

displays the highest value in a range

MIN function

determines the lowest (minimum) number in the range D4:D12

Normal View

the default view that you have worked in up until thid point in the book

order of operations

moving from left to right in a formula starting with negation, percentage, exponentiations, multiplications, divisions, additions and subtractions

Page Layout View

allows you to create or modify a worksheet while viewing how it will look in printed format

pixel

a dot on the screen that contains a color

Point mode

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

portrait orientation

printed across the width of the page

previewing the worksheet

you can see exactly how it will look without generating a printout

Range Finder

to check which cells are referenced in the formula assigned to the active cell

relative cell references

if you copy across, excel adjusts the column portion of cell references

smart tag indicator

a small purple triangle to indicate that a smart tag is available

smart tags

labeled data

spell checker

checks the worksheet for spelling errors

theme

a prefined set of colors, fonts, chart styles, cell styles, and fill effects

values version

shows the results of the formulas you have entered

Web query

you can import data stored on a website

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set