Department of Medical Informatics and Biostatitics

Faculty of Medicine, Iuliu Hațieganu University of Medicine and Pharmacy, Cluj-Napoca, România

Practical Activity 02: 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)

 

These are essential subjects to master for the practical evaluation:

- Working with Microsoft Excel: formulas and functions

Read 2028 times
Published in Practical activities
Download attachments:
back to top