M5 Lab_Manual_Excel_Basics_V3

Lab Manual

Excel Basics

Module 5

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? Format given Date into Numbers in excel

Guidelines What will be the steps to get the output? • Select a cell or a cell range of date column in worksheet • On the Home tab, select Number from the drop- down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells… , and select Number. ... • Select the number format. • Click on ok

Learning Date type is formatted into a number type Outcome

Thank You!