Excel Quiz 9 Posted on April 11, 2015September 25, 2021 by Vijay A. Verma Quiz 9 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 I am in cell E35 and press Home, which cell would it reach? A35 E38 A1 E1 2 / 10 Personal.xlsb file doesn’t exist until you record a macro to it. FALSE TRUE 3 / 10 If A1=johndoe@us.com What would be the answer for =RIGHT(A1,6) u @us.com @ us.com 4 / 10 Largest allowed positive number is 10^309 9.9E+308 9.99999999999999E+307 10^100 5 / 10 If A1=johndoe@us.com What would be the answer for =LEN(A1) 0 14 10 11 6 / 10 What would be the answer for =SMALL({11,20,45,67,2,98,45},3) 45 20 11 0 7 / 10 Fill in the blanks - This button is found under Data tab -Text to _ _ _ _ _ _ _ COLUMNS ROWS COLUMN ROW 8 / 10 Excel file format to store macros CSV XLSX All Excel file formats can store macros XLSM 9 / 10 What would be answer for =COLUMNS($A:F) 0 6 F1 A1 10 / 10 Fill in the blanks - Add cells to the _ _ _ _ _ _ _ _ _ _ _ list to keep an eye on their values as you update other parts of the sheet. Forms Window Fills Blanks Watch Window Forms Correl Your score is LinkedIn Facebook Twitter Retake quiz Exit