Excel Quiz 35 Posted on December 2, 2016September 26, 2021 by Vijay A. Verma Quiz 35 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 Remove Duplicates is found in which tab? Data Info File Formulas 2 / 10 Which Excel function can be used to generate random numbers >=0 and <1? RAND RND RANDOM RANDBETWEEN 3 / 10 What is the largest font size? 409 200 72 255 4 / 10 Through which functionality of Excel, you can stop somebody from inserting a sheet in your workbook? Protect workbook Protect sheet Encryption Share workbook 5 / 10 What is the file extension for an Excel template? .xltx .temp .xlsb .tlat 6 / 10 By default, numbers are aligned? Center Right Left Random 7 / 10 Spell check can not be done in Excel. TRUE FALSE 8 / 10 In the expression, =A1^3, which operator is denoted by ^ Exponentiation Cube Addition Scientific 9 / 10 Through which functionality of Excel, you can highlight your cells with data bars? Insert Picture Word art Conditional formatting Custom formatting 10 / 10 How many names an Excel workbook can contain? 66530 64000 Limited by available memory 1024 Your score is LinkedIn Facebook Twitter Retake quiz Exit