> > >

Excel MCQs

The following formula uses Get last name from name?

=RIGHT(name,LEN(name),FIND("*",SUBSTITUTE(name," ","",LEN(name)-LEN(SUBSTITUTE(name," ",""))))

=RIGHT(name,LEN(name)-FIND("*",SUBSTITUTE(name," ","*",LEN(name)-LEN(SUBSTITUTE(name," ","")))))

{=MAX(IF(ISERROR(SEARCH(H5&"*",files)),0,ROW(files)-ROW(INDEX(files,1,1))+1))} =RIGHT(name,LEN(name)-FIND("",SUBSTITUTE(name,"

","*",LEN(name)LEN(SUBSTITUTE(name," ","")))))

Answer

Correct Answer: =RIGHT(name,LEN(name)-FIND("*",SUBSTITUTE(name," ","*",LEN(name)-LEN(SUBSTITUTE(name," ","")))))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it