M12 Lab_Manual_Excel_Basics_V3

Lab Manual

Excel Basics

Module 12

Objectives of this Lab Manual This lab manual is designed to - Exercises for hands on practice Guidelines to complete the exercise Learning Outcome

Exercise What will you do? Use a relevant function to combine the three columns (Year, Month, Day) and form a date. YEAR MONTH DAY DATE 2022 05 23 ?

Guidelines What will be the steps to get the output? This Exercise can be solved using the DATE function Which is: =DATE (year, month, day) =DATE (A2, B2, C3). (This will substitute the value at that particular cell location into the function) 23-05-2022 this is the output you will get. Theoretical Solution: • Type =DATE and select the range • By default it is formatted as year, month, and day • Click on enter

Learning Outcome You will be able to combine the three columns to form a date using the DATE function.

Thank You!