Excel Quiz 5 Posted on January 3, 2015September 24, 2021 by Vijay A. Verma Quiz 5 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 1. To find the remainder after dividing a number by a divisor which function will be used MOD MODULUS QUOTIENT REMAINDER 2 / 10 2. To highlight all duplicate entries in a range which Excel functionality can be used Conditional Formatting Remove Duplicates Format Cells None of the above 3 / 10 3. Which is not a valid shortcut in Excel CTRL+W CTRL+H CTRL+M CTRL+K 4 / 10 4. To fill a color in the cell Select cell > Home Tab > Fill Color in Font Ribbon Group Select Cell > Right Click > Format Cells > Fill tab > Choose Color Select Cell > Home tab > Format > Color Only 1st and 2nd 5 / 10 5. Following is not a Logical function in Excel NAND NOR XOR All of the above 6 / 10 6. The Macros can be run by Developer tab > Macros > Select the Macro > Run ALT+F8 > Macros > Select the Macro > Run View tab > Macros > View Macros > Select the Macro > Run All of the above 7 / 10 7. To find Today's date, following formula can be used =TODAY() =TEXT(NOW(),"mm/dd/yy") Neither 1st nor 2nd Both 1st and 2nd 8 / 10 8. To calculate your EMI (Equal Monthly Installment) which function can be used PMT PV EMI CPMT 9 / 10 9. Following is not a Special category in Number tab of Format Cells Zip Code Social Security Number Credit Card Number Phone Number 10 / 10 10. For a given character string, A1 = "President of USA", the formula to extract first 5 characters would be =LEFT(A1,5) =MID(A1,1,5) =REPLACE(A1,6,LEN(A1),"") All of the above Your score is LinkedIn Facebook Twitter Retake quiz
Returns a specific number of characters from a text string starting at the position you specify (4) is MID, not TRIM Reply
As I am doing this quizes many of the quizes do not display the results, it jumps to another page. When I press the BACK button it takes me to the START of the test. Reply
Returns a specific number of characters from a text string starting at the position you specify (4) is MID, not TRIM
Thanks a lot for spotting the error. The same has been corrected.
Thank you again.
As I am doing this quizes many of the quizes do not display the results, it jumps to another page. When I press the BACK button it takes me to the START of the test.