Advertisement Upgrade to remove ads

Fixed Dollar Sign

dollar sign appears all the way in the left of the cell

Floating Dollar Sign

dollar sign appears just to the left of the number of "floats" depending on how big the number is

Currency

uses floating dollar signs

Accounting

uses fixed dollar signs

Fill Handle

copies formula, adjusting the cell reference, also copies the format of the cell

exploded

pie chart with one or more slice offset

=IF(D2=100, 0, SUM(A2:A5)

write an IF function: if cell D2 is equal to 100, place a 0 in the cell, if not, sum a range of cells.

freezing worksheet titles

useful technique for viewing large worksheets that extend beyond the window - freezes the row titles and column titles

#

indicates an error in a formula related to an inaccurate cell reference

=IF(A14<90, "you did not get an A", "you got an A")

write an IF function: if the score is less than 90, the cell should display you did not get an A. Otherwise the cell should display you got an A.

=IF(A14>=90, "you got an A", "you did not get an A")

write an IF function: if the score is less than 90, the cell should display you did not get an A. Otherwise the cell should display you got an A.

absolute cell reference

cell reference does not adjust when using this type of cell reference

relative cell reference

cell reference will adjust when using this type of cell reference

first data cell

the cell you should select when you want to freeze the titles - just below the column headings and just to the right of the row titles

$ are used in the cell name

the way to indicate a cell is an absolute reference - EXAMPLE: $F$21

F4 key

what key would you press after entering a cell address in order to make it absolute

IF Function

useful function when you want to assign a value based on a logical test - you can use < <= = >= > or <>

so you only have to change the value one time and the entire sheet will update

why should you always use cell reference whenever possible

Range Finder

method of checking formulas for accuracy - double click the cell

NOW function

date and time function - you must format it to display the way you choose - returns the computer system date and time

COUNT function

What function counts the number of cells in a range that contain numbers?

COUNTA function

What function counts the number of cells in a range that are not empty?

STDEV.P function

What function calculates the standard deviation of a range of numbers?

COUNTIF function

What function counts the number of cells in a range that meet a specific criteria?

=NOW()

how do you enter a NOW function

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