ASSIGNMENT – 36

USE OF FIND & LARGE FORMULA

Objective

In this assignment, you will learn how to use:

  • FIND Function – to find the position of a character inside text.

  • LARGE Function – to find the 1st, 2nd, 3rd, 4th, 5th highest values from a data range.

PART A – FIND FUNCTION

Table 1 – Find the Position of a Character

Enter the following data in Excel:

Text Letter to Find Position
Computer p  
Education c  
Microsoft Excel x  
Excel Formula F  
Digital Marketing a  
Student Name N  
Programming g  
Keyboard b  

FIND Syntax

=FIND(find_text,within_text)

Example

To find the position of “p” in Computer:

=FIND("p","Computer")

The formula returns the position of the character.

Important: FIND is case-sensitive.
For example, "F" and "f" are treated as different characters.

Questions – FIND Function

Q1. Find the position of “p” in the word Computer using FIND.

Q2. Find the position of “c” in Education using FIND.

Q3. Find the position of “x” in Microsoft Excel using FIND.

Q4. Find the position of “F” in Excel Formula using FIND.

Q5. Find the position of “a” in Digital Marketing using FIND.

Q6. Find the position of “N” in Student Name using FIND.

Additional Practice

Also find the position of:

  • “g” in Programming

  • “b” in Keyboard

PART B – LARGE FUNCTION

Sales Data

Enter the following sales data in Excel:

Salesperson Jan Feb Mar Apr
Aarav 12,500 18,500 15,000 22,000
Riya 25,000 16,500 21,000 19,500
Karan 14,500 27,000 18,000 24,500
Neha 30,000 22,500 26,000 17,500
Rahul 20,000 28,500 23,500 31,000

LARGE Function

Syntax

=LARGE(array,k)

Where:

  • array = range containing the numbers

  • k = position/rank of the value

Examples

1st Highest:

=LARGE(B2:E6,1)

2nd Highest:

=LARGE(B2:E6,2)

3rd Highest:

=LARGE(B2:E6,3)

Questions – LARGE Function

Q7. Find the Highest Sales from the complete sales data using LARGE.

Q8. Find the 2nd Highest Sales using LARGE.

Q9. Find the 3rd Highest Sales using LARGE.

Q10. Find the 4th and 5th Highest Sales using LARGE.

Bonus Practice

Using the same sales data:

Q11. Find the 6th Highest Sales.

Q12. Find the 10th Highest Sales.

Q13. Find the Lowest Sales using an appropriate Excel function.

Q14. Find the 2nd Lowest Sales.

Learning Outcome

After completing this assignment, students will be able to:

  1. Find the position of a character within text.

  2. Understand the FIND function.

  3. Understand that FIND is case-sensitive.

  4. Find the highest value from a large dataset.

  5. Find the 2nd, 3rd, 4th and 5th highest values.

  6. Use the LARGE function with different k values.

  7. Apply these functions to practical Excel data.

PreviousNext