Advanced spreadsheet skills

• Enumerate the 10 different functions in microsoft excel:

  SUM()

  SUMIF()

  COUNT()

  AVERAGE()

  IF()

  AND()

  VLOOKUP()

  CONCATENATE()

  MAX()

  MIN()
• Enumerate the features we learned in Microsoft Excel:

  Conditional formatting

  Text to columns

  Data validation
• A range refers to a group or array of cells
• The SUM function allows to sum numerical data in any number of columns or rows by selecting them or typing them in.
• The basic format for SUM function is =SUM(sum_range).
• The SUMIF function is used to summate the values of cells in a range that meet the criteria that have been specified .
• The basic format for the formula of SUMIF function is =SUMIF (range, criteria, sum_range).
• The AVERAGE function allows the user to get the average of all the numbers in the chosen cells.
• The basic formula of AVERAGE is : =AVERAGE(range to be averaged).
• The COUNT function is used to count the number of chosen cells that have a number value in them
• The basic formula format for COUNT function Is

  =COUNT(range to be counted).
• The IF function allows users to achieve a particular value if the condition has been satisfied or TRUE, or it the condition has not been satistied or FAlSE.
• The basic format for the IF Function is =IF(CONDITION,RESULT IF TRUE,RESULT IF FALSE).