M11 Lab_Manual_Excel_Basics_V3

Lab Manual

Excel Basics

Module 11

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? Compare the text given below for the exact content [content and case]: AB TexT TExt TEXT TEXT

Guidelines What will be the steps to get the output? • We are going to compare the two text strings exactly for the content and the case. • We will make use of the function called EXACT (text 1, text 2). It compares the text to be exactly the same and returns true if the texts have the same content and same case. [EXACT TAKES ONLY TWO TEXTS AT A TIME]. • We can simply compare the cells by using the formula = EXACT (Cell 1 containing text, cell 2 containing text) • The formula will return ‘TRUE’ if both the text strings are the same otherwise ‘FALSE’.

Learning Outcome You will be able to compare the texts for EXACT content using the EXACT function.

Thank You!