Excel Quiz 56 Posted on February 22, 2023August 18, 2023 by Vijay A. Verma Excel Quiz 56 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 If A2="USA", then which formula will give the answer "U"? =LEFT(A2) =LEFT(A2,1) =MID(A2,1,1) All the above 2 / 10 What is the answer for following in Excel? =ROUND(27.65,-1) 25 20 30 2.8 3 / 10 Which key combination do you use to confirm a formula as Array formula in Excel? CTRL+Enter SHIFT+Enter CTRL+ALT+Enter CTRL+SHIFT+Enter 4 / 10 Which is not a What-if Analysis tool? Analyze Data Scenario Manager Goal Seek Data Table 5 / 10 Which is not a valid function in Excel? STRING TEXT CHAR T 6 / 10 What is the shortcut for Flash Fill? ALT+F SHIFT+F CTRL+F CTRL+E 7 / 10 Which one is not a Lambda Helper function in Excel? RANDARRAY MAP SCAN REDUCE 8 / 10 What does following formula do? =EDATE(TODAY(),-10) Reduces 10 days from today Reduces 10 months from today Reduces 10 years from today Reduces 10 weeks from today 9 / 10 In Excel, which one is Mixed cell reference? A. $A2 B. A$2 C. Neither A nor B D. Both A & B 10 / 10 What is the shortcut for applying/removing Filter? CTRL+SHIFT+L ALT+A+T ALT+D+F+F All the above Your score is LinkedIn Facebook Twitter Retake quiz Exit
