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