L2

• Arithmetic Operators are mathematical operations used in performing calculations.
• Comparison Operators are logical operators used to compare two values. The result of the

  comparison can either be TRUE or FALSE.
• Text Concatenation Operator is used to join or connect two or more words to create a

  single word.
• Reference Operators are used to set a range of cells or values when computing.
• Point-Click Method

  Aside from manually typing the cell references for your formula, you can use the point-click

  method. Follow the same steps above but this time instead of typing the name of each cell,

  you just need to press Ctrl on your keyboard and click a cell where you want to start then

  type the operator.
• Fill Handle for Copying Formula

  When you have a huge amount of data, it is hard to manually type all the computations and

  formulas on each cell. Good thing spreadsheets have the functionality to copy and apply the

  same formula over a range of cells using the fill handle.
• Spreadsheet Functions

  Bigger data set means more computation and complex operations should be performed.

  Thus the need to use functions.
• SUM is a function that adds all the values of the cells in the argument.
• COUNT is a function that checks the number of cells in the range given. This function

  is useful if you need to count items.
• AVERAGE is a function that computes the average value of the cells in the argument.

  It computes the sum first and divides it by the number of cells in the argument.
• MAX is a function that looks for the highest value in the range.
• MIN is a function that looks for the lowest value in the range.
• Functions Library

  Different functions are available and can be found on the Formulas tab.