ADVANCE EXCEL KE KUCH SOLUTION JARUR DEKHYE

Advance Mock Test  Ap Bhi Dekh Lo Isme Condition Lagani Hai Jaisa Ki Bataya Gaya Hai Mene Is Tarah Se Condition Ke Sath Lagaya Formula Show Kya Hua Hai

	Notes:
	Q1. Grade Score In Table 2 Basis The List Below
	The Letter Grades Are Assigned To Numbers Using The Following Key.
	If Score Is	Then Return
	Greater Than 89	A
	From 80 To 89	B
	From 70 To 79	C
	From 60 To 69	D
	Less Than 60	F
	Table 2
	Score	Grades
	45	F	If(B15>89,"A",If(B15>80,"B",If(B15>70,"C",If(B15>60,"D","F"))))
	90	A	If(B16>89,"A",If(B16>80,"B",If(B16>70,"C",If(B16>60,"D","F"))))
	78	C	If(B17>89,"A",If(B17>80,"B",If(B17>70,"C",If(B17>60,"D","F"))))
	46	F	If(B18>89,"A",If(B18>80,"B",If(B18>70,"C",If(B18>60,"D","F"))))
	72	C	If(B19>89,"A",If(B19>80,"B",If(B19>70,"C",If(B19>60,"D","F"))))
	64	D	If(B20>89,"A",If(B20>80,"B",If(B20>70,"C",If(B20>60,"D","F"))))
	73	C	If(B21>89,"A",If(B21>80,"B",If(B21>70,"C",If(B21>60,"D","F"))))
	47	F	If(B22>89,"A",If(B22>80,"B",If(B22>70,"C",If(B22>60,"D","F"))))
	91	A	If(B23>89,"A",If(B23>80,"B",If(B23>70,"C",If(B23>60,"D","F"))))
	90	A	If(B24>89,"A",If(B24>80,"B",If(B24>70,"C",If(B24>60,"D","F"))))
	42	F	If(B25>89,"A",If(B25>80,"B",If(B25>70,"C",If(B25>60,"D","F"))))
	84	B	If(B26>89,"A",If(B26>80,"B",If(B26>70,"C",If(B26>60,"D","F"))))
	99	A	If(B27>89,"A",If(B27>80,"B",If(B27>70,"C",If(B27>60,"D","F"))))
	88	B	If(B28>89,"A",If(B28>80,"B",If(B28>70,"C",If(B28>60,"D","F"))))
	93	A	If(B29>89,"A",If(B29>80,"B",If(B29>70,"C",If(B29>60,"D","F"))))
	100	A	If(B30>89,"A",If(B30>80,"B",If(B30>70,"C",If(B30>60,"D","F"))))
	97	A	If(B31>89,"A",If(B31>80,"B",If(B31>70,"C",If(B31>60,"D","F"))))
	43	F	If(B32>89,"A",If(B32>80,"B",If(B32>70,"C",If(B32>60,"D","F"))))
	48	F	If(B33>89,"A",If(B33>80,"B",If(B33>70,"C",If(B33>60,"D","F"))))
	57	F	If(B34>89,"A",If(B34>80,"B",If(B34>70,"C",If(B34>60,"D","F"))))
	56	F	If(B35>89,"A",If(B35>80,"B",If(B35>70,"C",If(B35>60,"D","F"))))
	40	F	If(B36>89,"A",If(B36>80,"B",If(B36>70,"C",If(B36>60,"D","F"))))
	75	C	If(B37>89,"A",If(B37>80,"B",If(B37>70,"C",If(B37>60,"D","F"))))
	53	F	If(B38>89,"A",If(B38>80,"B",If(B38>70,"C",If(B38>60,"D","F"))))
	46	F	If(B39>89,"A",If(B39>80,"B",If(B39>70,"C",If(B39>60,"D","F"))))

Q – 2 Test :-  Condition Dekar Grade Show Karana Hai 

Q - 3 Test  :Right Hand Side Ka Data Bahut Bada Hai Isilye Pura Nahi Dikha Raha Hu

Q - 4 Test :- 

1. Please Map area sales manager name into column D from Table given in Column G and H 2. In Column K extract first name of area sales manager from column H
Date Zones of India Area Sales Manager Sales ('000) FORMULAS SHOW 39451 West Hemant Punia 50 IF(C6$G$6,$H$6,IF(C6$G$7,$H$7,IF(C6$G$8,$H$8,IF(C6$G$9,$H$9,"")))) 39458 North Raghav Chawla 50 IF(C7$G$6,$H$6,IF(C7$G$7,$H$7,IF(C7$G$8,$H$8,IF(C7$G$9,$H$9,"")))) 39465 South Saurabh Sharma 55 IF(C8$G$6,$H$6,IF(C8$G$7,$H$7,IF(C8$G$8,$H$8,IF(C8$G$9,$H$9,"")))) 39472 West Hemant Punia 70 IF(C9$G$6,$H$6,IF(C9$G$7,$H$7,IF(C9$G$8,$H$8,IF(C9$G$9,$H$9,"")))) 39479 East Karan Singhal 20 IF(C10$G$6,$H$6,IF(C10$G$7,$H$7,IF(C10$G$8,$H$8,IF(C10$G$9,$H$9,"")))) 39486 North Raghav Chawla 100 IF(C11$G$6,$H$6,IF(C11$G$7,$H$7,IF(C11$G$8,$H$8,IF(C11$G$9,$H$9,"")))) 39493 South Saurabh Sharma 150 IF(C12$G$6,$H$6,IF(C12$G$7,$H$7,IF(C12$G$8,$H$8,IF(C12$G$9,$H$9,"")))) 39500 West Hemant Punia 120 IF(C13$G$6,$H$6,IF(C13$G$7,$H$7,IF(C13$G$8,$H$8,IF(C13$G$9,$H$9,"")))) 39506 East Karan Singhal 175 IF(C14$G$6,$H$6,IF(C14$G$7,$H$7,IF(C14$G$8,$H$8,IF(C14$G$9,$H$9,"")))) 39514 North Raghav Chawla 135 IF(C15$G$6,$H$6,IF(C15$G$7,$H$7,IF(C15$G$8,$H$8,IF(C15$G$9,$H$9,"")))) 39521 South Saurabh Sharma 20 IF(C16$G$6,$H$6,IF(C16$G$7,$H$7,IF(C16$G$8,$H$8,IF(C16$G$9,$H$9,"")))) 39528 West Hemant Punia 25 IF(C17$G$6,$H$6,IF(C17$G$7,$H$7,IF(C17$G$8,$H$8,IF(C17$G$9,$H$9,"")))) 39535 East Karan Singhal 26 IF(C18$G$6,$H$6,IF(C18$G$7,$H$7,IF(C18$G$8,$H$8,IF(C18$G$9,$H$9,"")))) 39542 North Raghav Chawla 27 IF(C19$G$6,$H$6,IF(C19$G$7,$H$7,IF(C19$G$8,$H$8,IF(C19$G$9,$H$9,"")))) 39549 South Saurabh Sharma 28 IF(C20$G$6,$H$6,IF(C20$G$7,$H$7,IF(C20$G$8,$H$8,IF(C20$G$9,$H$9,"")))) 39556 West Hemant Punia 29 IF(C21$G$6,$H$6,IF(C21$G$7,$H$7,IF(C21$G$8,$H$8,IF(C21$G$9,$H$9,"")))) 39563 East Karan Singhal 30 IF(C22$G$6,$H$6,IF(C22$G$7,$H$7,IF(C22$G$8,$H$8,IF(C22$G$9,$H$9,"")))) 39570 North Raghav Chawla 31 IF(C23$G$6,$H$6,IF(C23$G$7,$H$7,IF(C23$G$8,$H$8,IF(C23$G$9,$H$9,"")))) 39577 South Saurabh Sharma 32 IF(C24$G$6,$H$6,IF(C24$G$7,$H$7,IF(C24$G$8,$H$8,IF(C24$G$9,$H$9,"")))) 39584 West Hemant Punia 33 IF(C25$G$6,$H$6,IF(C25$G$7,$H$7,IF(C25$G$8,$H$8,IF(C25$G$9,$H$9,"")))) 39591 East Karan Singhal 34 IF(C26$G$6,$H$6,IF(C26$G$7,$H$7,IF(C26$G$8,$H$8,IF(C26$G$9,$H$9,"")))) 39598 North Raghav Chawla 35 IF(C27$G$6,$H$6,IF(C27$G$7,$H$7,IF(C27$G$8,$H$8,IF(C27$G$9,$H$9,"")))) 39605 South Saurabh Sharma 36 IF(C28$G$6,$H$6,IF(C28$G$7,$H$7,IF(C28$G$8,$H$8,IF(C28$G$9,$H$9,"")))) 39612 West Hemant Punia 37 IF(C29$G$6,$H$6,IF(C29$G$7,$H$7,IF(C29$G$8,$H$8,IF(C29$G$9,$H$9,"")))) 39619 East Karan Singhal 38 IF(C30$G$6,$H$6,IF(C30$G$7,$H$7,IF(C30$G$8,$H$8,IF(C30$G$9,$H$9,"")))) 39626 North Raghav Chawla 39 IF(C31$G$6,$H$6,IF(C31$G$7,$H$7,IF(C31$G$8,$H$8,IF(C31$G$9,$H$9,"")))) 39633 South Saurabh Sharma 40 IF(C32$G$6,$H$6,IF(C32$G$7,$H$7,IF(C32$G$8,$H$8,IF(C32$G$9,$H$9,"")))) Ye Jankari Kesi Lagi  Comment Jarur Kijiye  Taki Isme Sudhar Bhi Kya Ja Sake

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )

APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH