36 terms

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