Excel Quiz 21 Posted on September 21, 2015September 25, 2021 by Vijay A. Verma Quiz 21 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 would be the answer for =DOLLARFR(150.15,4) 150.0006 150.06 150.154 146.15 2 / 10 Excel's default column width is 8.43 7.83 12 8 3 / 10 If you click on a Hyperlink to move within the workbook, what is the shortcut to come back? ALT + Back Arrow ALT + Home F5 ALT + PageUp 4 / 10 What does EFFECT function does? Converts Normal to Effective FV Returns Effective EMI Returns Effective Principal Returns Effective Interest Rate 5 / 10 Below stock formula is used for which purpose - =LOOKUP(10^307,A1:A100) Find the last number in a range Find the first character in a range Find the first number in a range Find the last character in a range 6 / 10 What does following formula do? =COLUMNS(1:1) This gives #VALUE error Generates an array of 1 Gives the number of columns in your worksheet Give the number of non blank cells in first row 7 / 10 Shortcut to go to last active cell ALT + Left Arrow No shortcut exists ALT + Backspace CTRL + Home 8 / 10 What is the result returned by the formula =SUM(34,45,-34,-45,4) 34 0 4 #VALUE 9 / 10 Smart Art can not be used in Excel? TRUE FALSE 10 / 10 Maximum zoom possible in Excel is 800% 888% Unlimited 400% Your score is LinkedIn Facebook Twitter Retake quiz Exit
