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