M14 Lab_Manual_Excel_Basics_V3

Lab Manual

Excel Basics

Module 14

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 the Lookup function on the corresponding Data Roll Number Student Name Lookup Roll No. 16 55 Divya ? 25 Paresh 43 Raman 39 Priya 16 02 Dhanashri Preyash

Guidelines What will be the steps to get the output? • Look for this piece of information, in the following area, and give me some corresponding data from another column • The first step to effectively using the VLOOKUP function is to make sure your data is well organized and suitable for using the function • We start by typing the formula “=VLOOKUP(“ and then select the cell that contains the information we want to lookup • we select the table where the data is located and tell Excel to search in the leftmost column for the information we selected in the previous step • In this step, we need to tell Excel which column contains the data that we want to have as an output from the VLOOKUP. • To do this, Excel needs a number that corresponds to the column number in the table • This final step is to tell Excel if you’re looking for an exact or approximate match by entering “True” or “False” in the formula

Learning Outcome You will be able to use the LOOKUP function and its types

Thank You!