 |
Java Games: Flashcards, matching, concentration, and word search. |
 |
|
Excel Functions
Flash cards for syntax on functions
|
| A | B |
|---|
| IF | =IF(logic_test,value_if_true,value_if_false) |
| MAX | =MAX(cell_range) |
| MIN | =MAX(cell_range) |
| SUM | =SUM(cell_range) |
| VLOOKUP | =VLOOKUP(lookup_value,table_array, column) |
| CHOOSE | =CHOOSE(index_number,value1,value2,value3...) |
| AVERAGE | =AVERAGE(cell_range) |
| PMT | =PMT(rate,nper,pv,fv,type) |
| Fill Down | Relatively copies the formula or cell content to other cells |
| Absolute Reference | F4, places $ in front of column and/or row reference to keep the cell reference constant in formulas |
|
| |
