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