ASSIGNMENT – 37

ANSWER KEY – LEFT, FIND, LEN, LOWER & NETWORKDAYS

PART A – LEFT FUNCTION

Q1. Extract the Required Characters

Formula:

=LEFT(A2,B2)
Text Characters Required Left String
Computer 3 Com
Education 4 Educ
Microsoft 5 Micro
Excel123 6 Excel1
Training 2 Tr

Individual Examples

=LEFT("Computer",3)

Answer: Com

=LEFT("Education",4)

Answer: Educ

=LEFT("Microsoft",5)

Answer: Micro

=LEFT("Excel123",6)

Answer: Excel1

=LEFT("Training",2)

Answer: Tr

PART B – LEFT + FIND

Q2. Extract First Name

Formula:

=LEFT(A2,FIND(" ",A2)-1)
Full Name First Name
Rahul Sharma Rahul
Neha Kapoor Neha
Amit Verma Amit
Priya Singh Priya
Karan Mehta Karan

Explanation

FIND(" ",A2) finds the position of the space.

-1 removes the space itself.

LEFT then extracts everything before the space.

PART C – LEN FUNCTION

Q3. Find Total Number of Characters

Formula:

=LEN(A2)
Text Length
Rahul Sharma 12
Excel Training 14
Computer 8
Microsoft Excel 15
Student 7

Important

LEN counts spaces also.

For example:

Rahul Sharma

  • Rahul = 5

  • Space = 1

  • Sharma = 6

Total = 12 characters

PART D – LOWER FUNCTION

Q4. Convert Text into Lowercase

Formula:

=LOWER(A2)
Upper Case Text Lower Case
RAHUL SHARMA rahul sharma
NEHA KAPOOR neha kapoor
EXCEL TRAINING excel training
COMPUTER COURSE computer course
MICROSOFT EXCEL microsoft excel

PART E – NETWORKDAYS

Q5. Calculate Working Days

Formula:

=NETWORKDAYS(A2,B2)

By default, Saturday and Sunday are excluded.

Start Date End Date Working Days
01-09-2026 07-09-2026 5
10-09-2026 18-09-2026 7
01-10-2026 15-10-2026 11
05-10-2026 20-10-2026 12
12-10-2026 30-10-2026 15

Example

=NETWORKDAYS(A2,B2)

If A2 = 01-09-2026 and B2 = 07-09-2026:

Answer = 5 working days

BONUS PRACTICE

Q6. Extract First Name from “Aarav Mehta”

Formula:

=LEFT("Aarav Mehta",FIND(" ","Aarav Mehta")-1)

Answer: Aarav

Q7. Find Length of “Advanced Excel Course”

Formula:

=LEN("Advanced Excel Course")

Answer: 21

Breakdown:

  • Advanced = 8

  • Space = 1

  • Excel = 5

  • Space = 1

  • Course = 6

Total = 21

Q8. Convert “ADVANCED EXCEL TRAINING” to Lowercase

Formula:

=LOWER("ADVANCED EXCEL TRAINING")

Answer: advanced excel training

Q9. Working Days Between 01-11-2026 and 15-11-2026

Formula:

=NETWORKDAYS(DATE(2026,11,1),DATE(2026,11,15))

Answer: 10 working days

Q10. Integrated Practice

Full Name First Name Name Length Lower Case Name
Aarav Sharma Aarav 12 aarav sharma
Riya Kapoor Riya 11 riya kapoor
Karan Mehta Karan 11 karan mehta
Neha Singh Neha 10 neha singh
Rahul Verma Rahul 11 rahul verma

First Name Formula

=LEFT(A2,FIND(" ",A2)-1)

Name Length Formula

=LEN(A2)

Lower Case Formula

=LOWER(A2)

Final Answer Summary

Question Answer
Q1 Com, Educ, Micro, Excel1, Tr
Q2 Rahul, Neha, Amit, Priya, Karan
Q3 12, 14, 8, 15, 7
Q4 rahul sharma, neha kapoor, excel training, computer course, microsoft excel
Q5 5, 7, 11, 12, 15 working days
Q6 Aarav
Q7 21 characters
Q8 advanced excel training
Q9 10 working days

Quick Revision

LEFT → Left side characters निकालना

=LEFT(A2,3)

FIND → Character/space की position पता करना

=FIND(" ",A2)

LEN → Total characters count करना

=LEN(A2)

LOWER → Text को lowercase करना

=LOWER(A2)

NETWORKDAYS → Working days calculate करना

=NETWORKDAYS(A2,B2)
PreviousNext