Excel Quiz 55 Posted on April 24, 2022December 3, 2022 by Vijay A. Verma Quiz 55 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 How many rows are possible in a worksheet? 2^20 2^16 2^10 2^22 2 / 10 Following formula can be used to sum natural numbers from 1 to 10 All options =SUM(ROW(1:10)) =SUM(COLUMN(A1:J1)) =SUM(SEQUENCE(10)) 3 / 10 What would be the answer for following =8+5*4-6/3 26 50 12.67 4.96 4 / 10 What is the difference between COUNT and COUNTA? No difference COUNT counts those cells in a range which are not blanks whereas COUNTA counts all cells whether blank or not COUNT counts those cells in a range which have numbers and COUNTA counts all non-blank cells whether numbers or not. COUNT counts those cells in a range which have numbers and COUNTA counts all blank cells 5 / 10 Which is not a reporting format in pivot table? Modern Outline Compact Tabular 6 / 10 What is the name of an intersection between a column and a row in Excel? Cell Rectangle Range Grid 7 / 10 Which function will you use to retrieve current time? TODAY() CURRENTTIME() NOW() CURTIME() 8 / 10 Which is not a valid chart type in Excel? Waterfall Scatter Radar Infograph 9 / 10 Which is a valid formula in Excel? 45%9 45&9 45//9 45**9 10 / 10 What does Double Underscore/Underline format denote in Excel from accounting purpose? Total in a pivot table Grand Total Most important information Sub Total Your score is LinkedIn Facebook Twitter Retake quiz Exit
