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