ASSIGNMENT – 36

ANSWER KEY – FIND & LARGE FORMULA

PART A – FIND FUNCTION

FIND Syntax

=FIND(find_text,within_text)

Note: FIND function case-sensitive hota hai.

Q1. Position of “p” in Computer

Formula:

=FIND("p","Computer")

Answer: 4

Computer:

C(1) – o(2) – m(3) – p(4)

Q2. Position of “c” in Education

Formula:

=FIND("c","Education")

Answer: 3

Education:

E(1) – d(2) – u?

Correction: Education is spelled E d u c a t i o n, so:

E(1) – d(2) – u(3) – c(4)

Correct Answer: 4

Q3. Position of “x” in Microsoft Excel

Formula:

=FIND("x","Microsoft Excel")

Answer: 12

Microsoft Excel:

M1 i2 c3 r4 o5 s6 o7 f8 t9 [space]10 E11 x12

Q4. Position of “F” in Excel Formula

Formula:

=FIND("F","Excel Formula")

Answer: 7

Excel Formula:

E1 x2 c3 e4 l5 [space]6 F7

Q5. Position of “a” in Digital Marketing

Formula:

=FIND("a","Digital Marketing")

Answer: 6

Digital:

D1 i2 g3 i4 t5 a6

Q6. Position of “N” in Student Name

Formula:

=FIND("N","Student Name")

Answer: 9

Student Name:

Student = 1–7
Space = 8
N = 9

Additional Practice Answers

“g” in Programming

=FIND("g","Programming")

Answer: 4

“b” in Keyboard

=FIND("b","Keyboard")

Answer: 4

FIND Function – Final Answers

Question Text Character Answer
Q1 Computer p 4
Q2 Education c 4
Q3 Microsoft Excel x 12
Q4 Excel Formula F 7
Q5 Digital Marketing a 6
Q6 Student Name N 9
Bonus Programming g 4
Bonus Keyboard b 4

PART B – LARGE FUNCTION

Sales Data

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 Syntax

=LARGE(array,k)

Here:

  • array = sales data range

  • k = position/rank

Q7. Highest Sales

Formula:

=LARGE(B2:E6,1)

Answer:

₹31,000

Highest sale = Rahul – April

Q8. 2nd Highest Sales

Formula:

=LARGE(B2:E6,2)

Answer:

₹30,000

2nd highest sale = Neha – January

Q9. 3rd Highest Sales

Formula:

=LARGE(B2:E6,3)

Answer:

₹28,500

3rd highest sale = Rahul – February

Q10. 4th and 5th Highest Sales

4th Highest

Formula:

=LARGE(B2:E6,4)

Answer: ₹27,000

5th Highest

Formula:

=LARGE(B2:E6,5)

Answer: ₹26,000

LARGE Function – Final Answers

Rank Formula Sales
1st Highest =LARGE(B2:E6,1) ₹31,000
2nd Highest =LARGE(B2:E6,2) ₹30,000
3rd Highest =LARGE(B2:E6,3) ₹28,500
4th Highest =LARGE(B2:E6,4) ₹27,000
5th Highest =LARGE(B2:E6,5) ₹26,000

BONUS ANSWERS

Q11. 6th Highest Sales

=LARGE(B2:E6,6)

Answer: ₹25,000

Q12. 10th Highest Sales

=LARGE(B2:E6,10)

Answer: ₹21,000

Q13. Lowest Sales

For the lowest value, use SMALL:

=SMALL(B2:E6,1)

Answer: ₹12,500

Q14. 2nd Lowest Sales

=SMALL(B2:E6,2)

Answer: ₹14,500

Quick Revision

FIND

=FIND("p","Computer")

➡ Finds the position of a character.

LARGE

=LARGE(B2:E6,1)

➡ Finds the 1st highest value.

=LARGE(B2:E6,2)

➡ Finds the 2nd highest value.

SMALL

=SMALL(B2:E6,1)

➡ Finds the lowest value.

PreviousNext