Excel Quiz 34 Posted on September 19, 2016September 26, 2021 by Vijay A. Verma Quiz 34 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 can be the maximum row heights in points? 1024 255 256 409 2 / 10 Maximum, how many fields a data form can contain? 100 32 1000 8 3 / 10 Shortcut to apply date format is CTRL+SHIFT+} CTRL+SHIFT+# CTRL+SHIFT+; CTRL+SHIFT+: 4 / 10 Maximum, how many fields can be dragged into Value section of a pivot table? 16 64 128 256 5 / 10 Maximum Undo levels in Excel can be 255 128 100 256 6 / 10 The maximum number of cells in a worksheet can be 1.05 Million 16.384 Billion 1048576 Million 17.18 Billion 7 / 10 The maximum length of a formula content ______ characters 8132 16384 10000 8192 8 / 10 Maximum, how many Excel Tables (not range) a Shared workbook can contain? 256 8 0 16 9 / 10 Maximum, how many sheets an Excel workbook can contain? 255 1024 Limited by available memory 64 10 / 10 Maximum number of characters in a header or footer can be 2000 128 255 1048 Your score is LinkedIn Facebook Twitter Retake quiz Exit
