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