Excel Quiz 50 Posted on January 11, 2021September 26, 2021 by Vijay A. Verma Quiz 50 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 What will be the result of this formula? =CEILING(1233,1000) 1000 1500 2000 1233 2 / 10 Which is a volatile function? DATE TIME CELL INDEX 3 / 10 Which of the following formulas can be used to extract last name from a cell if a cell contains First Name Last Name like A2 = John Doe hence answer should be Doe =RIGHT(A2,LEN(A2)-FIND( ,A2)) =REPLACE(A2,1,FIND( ,A2),) =TRIM(RIGHT(SUBSTITUTE(A2, ,REPT( ,LEN(A2))),LEN(A2))) All of the above 4 / 10 What will be the result of following formula? =CHOOSE(3*2,"Mon","Tue","Wed","Thu","Fri","Sat","Sun") Wed Sat Tue #VALUE 5 / 10 What will be the answer for following formula =VLOOKUP(105,A:C,4,0) #REF 21 Joe #NA 6 / 10 Which function can be used to calculate number of months to pay up a loan at constant rate? NPER RATE PMT None of the above 7 / 10 What is the result of following formula =TEXT(12345678,"0.0,,") 12.3 12,345,678 1234567.8 12.346 8 / 10 If A2 has a date, then following formula can be used to find a date after 3 months =EDATE(A2,3) =DATE(YEAR(A2),MONTH(A2)+3,DAY(A2)) Both A and B Neither A or B 9 / 10 What will be the result of this formula? =FIND("c?o","microsoft excel") 3 6 #VALUE 0 10 / 10 If A2 has a number in Text format, then which formula can be used to convert this text number into number format? =A2& =--A2 =TRIM(A2) =TEXT(A2,@) Your score is LinkedIn Facebook Twitter Retake quiz Exit
Regarding question 7 my Version of Excel (Microsoft 365) does not use the wildcard, and empty find text criteria will give a value of 1 Regarding question 7. Reply
Nice quiz and helpful
Regarding question 7 my Version of Excel (Microsoft 365) does not use the wildcard, and empty find text criteria will give a value of 1 Regarding question 7.