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