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