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