New Information systems

  1. ORDER OF OPERATIONS = PEMDAS

  1. Every formula or function must begin with an equal sign

  1. Name box: address of the cell you are on

  1. What is a cell that is highlighted in green: Active cell

  1. How does a cell solve formulas? Order of operations or pemdas

  1. File handle : gives me the activity to drag/increment

  1. Relative reference: referencing a cell and copy anywhere around the sheet and will update to other columns/cells

  1. A function is a predefined formula

-They have to have proper syntax means it has to start with an equal sign, after equal sign you need the name of the function, after you need an open parentheses ( then you must required arguments and can add optional argument or not, finally you need a closed parentheses )

  1. Arguments are separated by commas Example : =SUM(100, 1000, 10000, B5)

  1. Cell range is separate by colon: =SUM(B5:D44, A15, 100)

  1. CTRL ~ : will show formulas

  1. False means : look for a exact match

  1. V-lookup are for tables that are horizontal

  1. B5 - Relative Reference- Column and row will change relative to where you copied or pasted a function or formula referencing those cells

  1. $B$5 - Absolute Reference - Column and row will never change regardless of where you copy or move the function or formula referencing that cell.

  1. Logical operators

<

<=

>

>=

=

<>

  1. B5- Relative Reference: Column and row will both update relative to the number of columns and rows where a formula referencing this cell is copied or filled

  1. $B$5 - Absolute Reference: Column and row

  1. $BF - Mixed Reference: Column will not change but the row will change relative to the number of rows you copy or fill a formula or function referencing this cell

  1. B$F - Mixed Reference - Row will not change but the column will change relative to the number of columns 5