MS-Excel Quiz (Level – Easy) 0% 0 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! Time Up! MS Office MS Excel Ouiz (Level Easy) Loging Here. 1 / 30 Category: Easy Level 1. Excel files are saved with which extension by default (Excel 2016 and later)? a. .xlw b. .xlsx c. .docx d. .xls 2 / 30 Category: Easy Level 2. What is the use of the VLOOKUP function? a. Horizontal lookup b. Vertical lookup c. Sorting d. Filtering 3 / 30 Category: Easy Level 3. What is the intersection of a row and a column called? a. Field b. Table c. Cell d. Box 4 / 30 Category: Easy Level 4. Which function counts numeric values only? a. COUNTA b. CNT c. COUNT d. COUNTALL 5 / 30 Category: Easy Level 5. Which function counts empty cells? a. COUNTBLANK b. COUNTEMPTY c. EMPTY d. BLANK 6 / 30 Category: Easy Level 6. Which of the following is NOT a valid chart in Excel? a. Line b. Hexagon c. Pie d. Bubble 7 / 30 Category: Easy Level 7. Which function returns today’s date? a. NOW() b. TODAY() c. TIME() d. DATE() 8 / 30 Category: Easy Level 8. Which operator is used for multiplication? a. * b. x c. / d. # 9 / 30 Category: Easy Level 9. Which function returns the smallest value? a. SMALL b. MINIMUM c. MIN d. LOW 10 / 30 Category: Easy Level 10. In Excel, a formula begins with: a. = b. ! c. + d. % 11 / 30 Category: Easy Level 11. Which function finds the maximum value? a. HIGH b. HIGHEST c. MAX d. MAXIMUM 12 / 30 Category: Easy Level 12. Which shortcut copies content? a. Ctrl + C b. Ctrl + A c. Ctrl + V d. Ctrl + X 13 / 30 Category: Easy Level 13. A collection of worksheets in Excel is called a: a. File b. Worksheet c. Table d. Workbook 14 / 30 Category: Easy Level 14. The default view of Excel is: a. Page Break Preview b. Page Layout c. Full Page d. Normal View 15 / 30 Category: Easy Level 15. What does the AutoFill handle look like? a. A small dash b. A small square c. A circle d. A triangle 16 / 30 Category: Easy Level 16. The active cell is identified by: a. Bold text b. Highlighted fill color c. A thick black border d. Dotted lines 17 / 30 Category: Easy Level 17. Conditional Formatting is used to: a. Format multiple sheets b. Format charts c. Format cells based on conditions d. Format workbook 18 / 30 Category: Easy Level 18. What does Ctrl + Z do? a. Redo b. Delete c. Undo d. Insert 19 / 30 Category: Easy Level 19. Which function returns the average of selected numbers? a. AVG b. ADD c. MEAN d. AVERAGE 20 / 30 Category: Easy Level 20. Freeze Panes is used to: a. Format cells b. Lock rows/columns c. Protect sheets d. Split worksheets 21 / 30 Category: Easy Level 21. Which key is used to edit a cell? a. F4 b. F9 c. F1 d. F2 22 / 30 Category: Easy Level 22. In Excel, text too large for a cell can be fixed using: a. Autofit b. Split c. Merge Cells d. Wrap Text 23 / 30 Category: Easy Level 23. Which chart is best for showing proportions? a. Bar Chart b. Pie Chart c. Scatter Chart d. Line Chart 24 / 30 Category: Easy Level 24. What is the default column width in Excel? a. 12 b. 15 c. 8.43 d. 10 25 / 30 Category: Easy Level 25. What does Ctrl + P do? a. Print b. Preview c. Paste d. Page Setup 26 / 30 Category: Easy Level 26. Which shortcut is used to save a workbook? a. Ctrl + C b. Ctrl + X c. Ctrl + S d. Ctrl + V 27 / 30 Category: Easy Level 27. Which function is used to find the sum of a range? a. ADD b. SUM c. COUNT d. TOTAL 28 / 30 Category: Easy Level 28. The shortcut for creating a new workbook is: a. Ctrl + N b. Ctrl + O c. Ctrl + Shift + N d. Ctrl + W 29 / 30 Category: Easy Level 29. Which one is a valid cell address? a. A1 b. 1A c. A0 d. AA0 30 / 30 Category: Easy Level 30. Which symbol is used to start a formula in Excel? a. $ b. # c. @ d. = Your score is 0% Restart quiz Rate the Quiz Thank You for Rating Us! 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 Next PostMS Office (Excel) Quiz (level – Easy) 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 Leave a ReplyCancel reply
