Advance Excel Quiz for Beginners 0% 1 Report a question Table of Contents ToggleReport a questionShare this:Like this:Related What’s wrong with this question? You cannot submit an empty report. Please add some details. Oops! Times Up! Advance Excel Advance Excel Quiz (Level - Beginner) Check Your Knowledge! Click on Start Button, Now! Information Form. 1 / 50 Category: Easy Level Which function counts numeric values only? a. COUNT b. CNT c. COUNTALL d. COUNTA 2 / 50 Category: Easy Level The function IF() is used for: a. Charts b. Math operations c. Logical tests d. Text formatting 3 / 50 Category: Easy Level Which function returns current date and time? a. DATE() b. TODAY() c. TIME() d. NOW() 4 / 50 Category: Easy Level Which function is used to find the length of text? a. COUNT b. SIZE c. LENGTH d. LEN 5 / 50 Category: Easy Level Conditional Formatting is used to: a. Format charts b. Format workbook c. Format multiple sheets d. Format cells based on conditions 6 / 50 Category: Easy Level What does Ctrl + Z do? a. Redo b. Insert c. Undo d. Delete 7 / 50 Category: Easy Level What is the default column width in Excel? a. 15 b. 10 c. 12 d. 8.43 8 / 50 Category: Easy Level Which shortcut copies content? a. Ctrl + X b. Ctrl + A c. Ctrl + V d. Ctrl + C 9 / 50 Category: Easy Level Which type of reference is $A$1? a. Relative b. Absolute c. Absolute d. Complex 10 / 50 Category: Easy Level To insert a chart, use the tab: a. Data b. View c. Insert d. Home 11 / 50 Category: Easy Level Which function is used to find the sum of a range? a. ADD b. TOTAL c. SUM d. COUNT 12 / 50 Category: Easy Level Which of the following is NOT a valid chart in Excel? a. Pie b. Hexagon c. Bubble d. Line 13 / 50 Category: Easy Level What is the maximum number of rows in Excel 2016? a. 500,000 b. 2,000,000 c. 65,536 d. 1,048,576 14 / 50 Category: Easy Level Which key is used to edit a cell? a. F9 b. F4 c. F1 d. F2 15 / 50 Category: Easy Level Which function returns today’s date? a. TODAY() b. NOW() c. TIME() d. DATE() 16 / 50 Category: Easy Level The shortcut for creating a new workbook is: a. Ctrl + Shift + N b. Ctrl + N c. Ctrl + O d. Ctrl + W 17 / 50 Category: Easy Level Which chart is best for showing proportions? a. Scatter Chart b. Pie Chart c. Line Chart d. Bar Chart 18 / 50 Category: Easy Level Which symbol is used to start a formula in Excel? a. = b. @ c. # d. $ 19 / 50 Category: Easy Level Excel columns are identified by: a. Both A & B b. Letters c. Numbers d. Symbols 20 / 50 Category: Easy Level Which function finds the maximum value? a. HIGH b. MAX c. HIGHEST d. MAXIMUM 21 / 50 Category: Easy Level What is the use of the VLOOKUP function? a. Vertical lookup b. Filtering c. Sorting d. Horizontal lookup 22 / 50 Category: Easy Level What does the AutoFill handle look like? a. A small dash b. A triangle c. A circle d. A small square 23 / 50 Category: Easy Level Which operator compares two values? a. . . b. "> or <" c. == d. = 24 / 50 Category: Easy Level Excel files are saved with which extension by default (Excel 2016 and later)? a. .xlsx b. .docx c. .xlw d. .xls 25 / 50 Category: Easy Level What is the intersection of a row and a column called? a. Cell b. Field c. Box d. Table 26 / 50 Category: Easy Level Which tab contains Sort & Filter? a. Data b. View c. Home d. Insert 27 / 50 Category: Easy Level Excel is developed by: a. Microsoft b. IBM c. Apple d. Google 28 / 50 Category: Easy Level The shortcut for bold text is: a. Ctrl + I b. Ctrl + U c. Ctrl + B d. Ctrl + Shift + B 29 / 50 Category: Easy Level Which function returns the smallest value? a. MINIMUM b. LOW c. SMALL d. MIN 30 / 50 Category: Easy Level Which function counts empty cells? a. EMPTY b. COUNTEMPTY c. COUNTBLANK d. BLANK 31 / 50 Category: Easy Level Which key deletes the selected cells? a. Esc b. Shift c. Backspace d. Delete 32 / 50 Category: Easy Level What does the CONCATENATE function do? a. Adds numbers b. Filters data c. Sorts cells d. Joins text 33 / 50 Category: Easy Level The active cell is identified by: a. A thick black border b. Highlighted fill color c. Bold text d. Dotted lines 34 / 50 Category: Easy Level Which one is a valid cell address? a. 1A b. A0 c. A1 d. AA0 35 / 50 Category: Easy Level Which function combines text from multiple cells? a. TEXTADD b. CONCAT c. MERGE d. JOIN 36 / 50 Category: Easy Level Which function returns the average of selected numbers? a. MEAN b. AVG c. ADD d. AVERAGE 37 / 50 Category: Easy Level Which feature quickly fills a series? a. AutoFill b. Quick Fill c. Series Fill d. Flash Fill 38 / 50 Category: Easy Level Which operator is used for multiplication? a. * b. # c. / d. x 39 / 50 Category: Easy Level In Excel, text too large for a cell can be fixed using: a. Merge Cells b. Split c. Wrap Text d. Autofit 40 / 50 Category: Easy Level The formula =COUNT(A1:A5) counts: a. Text cells b. Empty cells c. Numeric cells d. All cells 41 / 50 Category: Easy Level In Excel, a formula begins with: a. + b. % c. = d. ! 42 / 50 Category: Easy Level Freeze Panes is used to: a. Protect sheets b. Lock rows/columns c. Format cells d. Split worksheets 43 / 50 Category: Easy Level Excel rows are identified by: a. Numbers b. Symbols c. Roman numerals d. Letters 44 / 50 Category: Easy Level What does Ctrl + P do? a. Paste b. Print c. Preview d. Page Setup 45 / 50 Category: Easy Level The default view of Excel is: a. Page Layout b. Normal View c. Page Break Preview d. Full Page 46 / 50 Category: Easy Level Which shortcut is used to save a workbook? a. Ctrl + V b. Ctrl + X c. Ctrl + S d. Ctrl + C 47 / 50 Category: Easy Level Name of Excel’s grid structure is: a. Document b. Database c. Spreadsheet d. Table 48 / 50 Category: Easy Level What is the shortcut for “Find”? a. Ctrl + K b. Ctrl + F c. Ctrl + L d. Ctrl + H 49 / 50 Category: Easy Level A collection of worksheets in Excel is called a: a. Worksheet b. Table c. File d. Workbook 50 / 50 Category: Easy Level Which menu option protects a workbook? a. Insert b. Page Layout c. View d. Review Your score is 0% Restart quiz Rate Us! Thank You for Rating ! Send feedback Share this: Share on Facebook (Opens in new window) Facebook Share on X (Opens in new window) X Like this:Like Loading… Related Share post Please Share This Share this content Opens in a new window Opens in a new window Opens in a new window Opens in a new window Read more articles Previous PostMS Office (Excel) Quiz (level – Easy) Next Post50+ MS Excel Question Quiz (Level – Intermediate) Prajjwal Singh Tech Blogger || Web developer || Computer Networking Enthusiast || Microsoft SQL Database Management Expert || Software Debugger || Learned DOS OS Structure You Might Also Like Download Windows, Tally Prime, MS Office & LibreOffice Keyboard Shortcut Keys Images – Free August 7, 2026 Learn Excel Fast: 30 Hands-On Projects for 30 Days May 4, 2026 30 Days PowerPoint Challenge: Build Stunning Presentations May 6, 2026 Leave a ReplyCancel reply
Download Windows, Tally Prime, MS Office & LibreOffice Keyboard Shortcut Keys Images – Free August 7, 2026
