Spreadsheet

Spreadsheet

1. Formulae

   • Multiplying
     • How to: 1). = 2). First cell 3). * 4). second cell 5). ENTER
     • Symbol: X = *
   • Division
     • How to: 1). = 2). first cell 3). / 4). Second cell 5). ENTER
     • Symbol: % = /
   • Addition
     • How to: 1). SUM = 2). first cell 3). + 4). second cell 5). ENTER
     • Symbol: + =+
   • Subtraction
     • How to: 1). = 2). first cell 3). - 4). second cell 5). ENTER
     • Symbol: - = -

2. VLOOKUP

   • For comparing data
   • How to: 1). Name the table (e.g. cost) 2). choose the cell to lookup from and click 'fx' scroll down to find VLOOKUP 3). Lookup value = where the data will go. Table_array = table name 4). col_index_num = columns you want to display (e.g. 2) 5). Range_lookup = true/false - most of the time, false