Excel Quiz No. 48 Posted on August 17, 2020September 26, 2021 by Vijay A. Verma Quiz 48 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 is not a way to create a named range? Name Manager Define Name Create from Selection Show Formulas 2 / 10 What is not supported in Conditional Formatting? Icon Sets Color Scales Color Map Data Bars 3 / 10 What is not part of Font formatting in Excel? Underline Double Underline Upper Underline Strikethrough 4 / 10 Which function would you use to add to or subtract months from a date? EDATE DATE EOMONTH MONTH 5 / 10 The default font in Excel 2016 / 365 is (unless changed) Times New Roman Tahoma Arial Calibri 6 / 10 Which is not a function in Excel? LTRIM RTRIM STRIP All of the above 7 / 10 To extract the first two characters from a string, which function is preferred? MID LEFT RIGHT LTRIM 8 / 10 Which is not a menu tab in Excel? Review Formulas Filter Page Layout 9 / 10 What is the shortcut for Excel Options? CTRL+E+O CTRL+SHIFT+O ALT+E+O ALT+T+O 10 / 10 Which menu tab is not part of default installation of Excel unless added explicitly? Formulas Review Developer Page Layout Your score is LinkedIn Facebook Twitter Retake quiz Exit
