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