Excel Quiz 16 Posted on July 11, 2015September 25, 2021 by Vijay A. Verma Quiz 16 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 Maximum zoom possible in Excel 400% Constrained only by available memory 800% 200% 2 / 10 CTRL+U is the shortcut for Underlines the cell value Does not do anything Inserts a vertical pipe character Makes the font Italics 3 / 10 Precision of Number in Excel 10 digits before decimal and 5 after decimal 15 significant digits 15 digits Unlimited 4 / 10 Total number of characters that a cell can contain 1024 255 256 32767 5 / 10 Maximum levels of nested functions 32 7 64 16 6 / 10 Number of columns in a Worksheet 16384 No Limit 256 1024 7 / 10 Maximum number of Hyperlinks 66530 1024 64000 16 8 / 10 Latest date allowed for calculation 31-Dec-2099 1-Jan-9999 31-Dec-9999 31-Dec-2199 9 / 10 ALT+F11 is shortcut for Opens VBA window Does nothing Copies the formula down Repeats the character 10 / 10 Largest allowed negative number -9.99999999999999E+308 -9.99E+100 -9.99999999999999E+307 -1E99999 Your score is LinkedIn Facebook Twitter Retake quiz Exit
