M13 Lab_Manual_Excel_Basics_V3

Lab Manual

Excel Basics

Module 13

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? Check whether the person is an adult or not (Above 18) using conditional analysis: AGE Adult / Not Adult 20 ? 14 ?

Guidelines What will be the steps to get the output? • Type =IF(select range < 18,”Adult”,”Not Adult”) • Click on Enter • Drag it until the range of the worksheet

Learning Outcome You will be able to check whether the person is an adult or not based on his age using the IF function.

Thank You!