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