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