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