25 terms

# Excel Chapter 3

###### PLAY
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