# Excel Chapter 3

### 20 terms by cackmann1

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

### 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 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 will not change when you copy it - it is absolute

### relative cell reference

cell reference will change when you copy it - it is relative to the active cell

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

after you key the cell F21 - if you press F4 - Excel will add the dollar signs to make an absolute cell reference

### IF Function

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

### Cell References

ALWAYS use cell references whenever possible in functions and formulas so the value only needs to be changed once.

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

Example: