Practical Activity 04: Microsoft Excel Formulas & Functions

Learning Objectives:

  • Formating columns according to the type of data (Exercise 1 & 2)
  • Identify the type of variables (Exercise 1)
  • Using formulas in Excel: operators and order of operations (Exercise 1 & 2)
  • Writing equations using relative and absolute cell references (Exercise 1 & 2)
  • Using predefined functions: COUNT, COUNTIF, IF (Exercise 1 & 2) and SUM (Exercise 1)

Read 1016 times