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