Excel Quiz 36 Posted on January 16, 2017September 26, 2021 by Vijay A. Verma Quiz 36 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 Which function can be used to calculate EMI (Equated Monthly Installment)? NPV EMI RATE PMT 2 / 10 Which tab contains Show All Comments? View Home Data Review 3 / 10 Font size can be increased or decreased from which tab? Data Home View Review 4 / 10 What is not found under What-if Analysis button? Data table Scenario analysis Evaluate formula Goal seek 5 / 10 Manual calculation can be set in which button? Consolidate Calculate now Group Calculation options 6 / 10 Which tab contains Record Macro? Formulas Page Layout Home Developer 7 / 10 Excel ribbon can be customized only through VBA? TRUE FALSE 8 / 10 Which is not found under View tab? Page Layout Hide Protect Sheet Zoom 9 / 10 What is the shortcut for contracting and expanding Ribbon? ALT+F1 F1 CTRL+F1 No shortcut 10 / 10 Which is not part of Data tab? Hyperlink Filter Text to Columns Data validation Your score is LinkedIn Facebook Twitter Retake quiz Exit
