MS-Excel MCQs (01-100)

  1. The default file extension for Excel 2016 and later is:
    A) .xls B) .xlsx C) .docx D) .csv
    Answer: B) .xlsx

  2. The shortcut key to create a new workbook is:
    A) Ctrl + O B) Ctrl + N C) Ctrl + W D) Alt + N
    Answer: B) Ctrl + N

  3. Which function is used to find the average of a range?
    A) SUM() B) AVERAGE() C) COUNT() D) MEAN()
    Answer: B) AVERAGE()

  4. The intersection of a row and a column in Excel is called:
    A) Cell B) Table C) Range D) Box
    Answer: A) Cell

  5. Which function returns the highest value in a range?
    A) MAX() B) MIN() C) LARGE() D) HIGH()
    Answer: A) MAX()

  6. The maximum number of columns in Excel 2019 is:
    A) 1,048,576 B) 16,384 C) 256 D) 65,536
    Answer: B) 16,384

  7. The shortcut key to save a workbook is:
    A) Ctrl + W B) Ctrl + S C) Alt + S D) Ctrl + Shift + S
    Answer: B) Ctrl + S

  8. Which chart type is best for showing trends over time?
    A) Bar chart B) Line chart C) Pie chart D) Scatter chart
    Answer: B) Line chart

  9. The default font in Excel 2016 is:
    A) Arial B) Calibri C) Verdana D) Times New Roman
    Answer: B) Calibri

  10. The cell address of column B and row 5 is:
    A) 5B B) B5 C) Row5ColB D) 5-B
    Answer: B) B5

  11. The function used to count numeric entries in a range is:
    A) COUNT() B) COUNTA() C) COUNTIF() D) COUNTBLANK()
    Answer: A) COUNT()

  12. The symbol used to make an absolute cell reference is:
    A) @ B) $ C) # D) %
    Answer: B) $

  13. Which Excel feature allows summarizing data by dragging fields?
    A) Filter B) Pivot Table C) Sort D) Chart
    Answer: B) Pivot Table

  14. The function used to combine text from two cells is:
    A) CONCATENATE() B) JOIN() C) MERGE() D) TEXTJOIN()
    Answer: A) CONCATENATE()

  15. The function that returns the current date is:
    A) DATE() B) NOW() C) TODAY() D) CURRENTDATE()
    Answer: C) TODAY()

  16. The extension of a macro-enabled Excel file is:
    A) .xlsx B) .xls C) .xlsm D) .csv
    Answer: C) .xlsm

  17. The shortcut key used to copy data is:
    A) Ctrl + X B) Ctrl + C C) Ctrl + V D) Ctrl + P
    Answer: B) Ctrl + C

  18. The function that checks a condition and returns TRUE or FALSE is:
    A) CHECK() B) IF() C) TEST() D) LOGICAL()
    Answer: B) IF()

  19. Charts can be inserted from which tab?
    A) Data B) Insert C) View D) Home
    Answer: B) Insert

  20. In newer Excel versions, comments are now called:
    A) Notes B) Remarks C) Tags D) Annotations
    Answer: A) Notes

  21. The Freeze Panes option is available in which tab?
    A) View B) Insert C) Data D) Review
    Answer: A) View

  22. The shortcut to insert a new worksheet is:
    A) Ctrl + N B) Shift + F11 C) Ctrl + W D) Alt + Shift + N
    Answer: B) Shift + F11

  23. The function that counts non-empty cells is:
    A) COUNT() B) COUNTA() C) COUNTBLANK() D) SUM()
    Answer: B) COUNTA()

  24. To calculate total sales as Quantity × Price, the correct formula is:
    A) =A1B1 B) A1B1 C) =MULT(A1,B1) D) =SUM(A1,B1)
    Answer: A) =A1*B1

  25. The default view in Excel is:
    A) Page Layout B) Normal View C) Page Break Preview D) Print Preview
    Answer: B) Normal View

  26. The shortcut to cut data is:
    A) Ctrl + X B) Ctrl + C C) Ctrl + V D) Ctrl + Shift + X
    Answer: A) Ctrl + X

  27. The shortcut to paste copied content is:
    A) Ctrl + V B) Ctrl + P C) Ctrl + C D) Ctrl + W
    Answer: A) Ctrl + V

  28. The function that counts cells meeting a condition is:
    A) COUNTIF() B) SUMIF() C) IF() D) COUNTA()
    Answer: A) COUNTIF()

  29. The Merge & Center option is available under:
    A) Home tab B) Insert tab C) View tab D) Layout tab
    Answer: A) Home tab

  30. The function that adds numbers in a range is:
    A) ADD() B) TOTAL() C) SUM() D) PLUS()
    Answer: C) SUM()

  31. To display formulas instead of values, use:
    A) Ctrl +  B) Ctrl + Alt + F C) Ctrl + Shift + F9 D) Alt + = **Answer:** A) Ctrl +

  32. Conditional Formatting is found under which tab?
    A) Home B) Insert C) Data D) Review
    Answer: A) Home

  33. The operator used to join text in Excel is:
    A) & B) + C) # D) $
    Answer: A) &

  34. To move one cell to the right, press:
    A) Tab B) Enter C) Shift D) Right Arrow
    Answer: A) Tab

  35. The function that finds the smallest value is:
    A) LOWEST() B) SMALL() C) MIN() D) BASE()
    Answer: C) MIN()

  36. The function that looks up values vertically is:
    A) VLOOKUP() B) HLOOKUP() C) INDEX() D) MATCH()
    Answer: A) VLOOKUP()

  37. The Quick Access Toolbar is located:
    A) Above the Ribbon B) Below the Ribbon C) Left of the Ribbon D) On the Status Bar
    Answer: A) Above the Ribbon

  38. Which feature restricts data entry?
    A) Data Validation B) Filter C) Conditional Formatting D) Security
    Answer: A) Data Validation

  39. The shortcut key for Print Preview is:
    A) Ctrl + P B) Ctrl + F2 C) Ctrl + Alt + P D) Shift + P
    Answer: B) Ctrl + F2

  40. To automatically sum a column, use:
    A) Alt + = B) Ctrl + S C) Shift + + D) Ctrl + Alt + =
    Answer: A) Alt + =

  41. The function that returns the current date and time is:
    A) NOW() B) TODAY() C) DATE() D) TIME()
    Answer: A) NOW()

  42. A group of cells in Excel is called a:
    A) Range B) Table C) Block D) Set
    Answer: A) Range

  43. To sort data from A to Z, use:
    A) Sort Ascending B) Sort Descending C) Filter D) Arrange
    Answer: A) Sort Ascending

  44. The function that counts blank cells is:
    A) COUNTBLANK() B) COUNT() C) EMPTY() D) BLANKS()
    Answer: A) COUNTBLANK()

  45. Columns in Excel are labeled using:
    A) Numbers B) Letters C) Both D) Symbols
    Answer: B) Letters

  46. Rows in Excel are labeled using:
    A) Numbers B) Letters C) Both D) Symbols
    Answer: A) Numbers

  47. The tab that provides access to functions is:
    A) Formulas B) Data C) Insert D) Review
    Answer: A) Formulas

  48. The default worksheet name in a new workbook is:
    A) Sheet1 B) Workbook1 C) Page1 D) Excel1
    Answer: A) Sheet1

  49. To rename a worksheet, you can:
    A) Double-click its tab B) Use F2 C) Right-click → Rename D) All of the above
    Answer: D) All of the above

  50. To close a workbook, you can use:
    A) Ctrl + W B) Ctrl + F4 C) Alt + F4 D) All of the above
    Answer: D) All of the above

  1. The default alignment of numbers in a cell is:
    A) Left B) Right C) Center D) Justify
    Answer: B) Right

  2. The default alignment of text in a cell is:
    A) Left B) Right C) Center D) Justify
    Answer: A) Left

  3. Which key combination opens the “Format Cells” dialog box?
    A) Ctrl + 1 B) Ctrl + F1 C) Ctrl + Shift + 1 D) Alt + 1
    Answer: A) Ctrl + 1

  4. Which function removes extra spaces from text?
    A) CLEAN() B) TRIM() C) REMOVE() D) SPACE()
    Answer: B) TRIM()

  5. To create a chart instantly from selected data, press:
    A) F11 B) Alt + F1 C) Ctrl + F1 D) Shift + F1
    Answer: B) Alt + F1

  6. Which key combination is used to open the “Go To” dialog box?
    A) Ctrl + G B) Ctrl + F C) Alt + G D) F5
    Answer: D) F5

  7. To insert the current date into a cell, use:
    A) Ctrl + D B) Ctrl + ; C) Ctrl + Shift + ; D) Alt + D
    Answer: B) Ctrl + ;

  8. To insert the current time into a cell, use:
    A) Ctrl + ; B) Ctrl + Shift + ; C) Alt + T D) Shift + T
    Answer: B) Ctrl + Shift + ;

  9. The Name Box displays:
    A) Cell name or address B) Formula C) Function name D) Chart name
    Answer: A) Cell name or address

  10. The Formula Bar shows:
    A) The formula or value in the active cell B) Only formulas C) Only values D) Cell address
    Answer: A) The formula or value in the active cell

  11. Which function converts text to uppercase?
    A) UPPER() B) CAPITAL() C) UCASE() D) TEXTUP()
    Answer: A) UPPER()

  12. Which function converts text to lowercase?
    A) LOWER() B) SMALL() C) TEXTLOW() D) DOWNCASE()
    Answer: A) LOWER()

  13. Which function capitalizes only the first letter of each word?
    A) INITCAP() B) PROPER() C) TITLE() D) CAPFIRST()
    Answer: B) PROPER()

  14. What is the function of AutoFill?
    A) Automatically fills data series B) Automatically saves files C) Deletes empty cells D) Formats text automatically
    Answer: A) Automatically fills data series

  15. Which function returns the number of characters in text?
    A) LEN() B) COUNT() C) LENGTH() D) SIZE()
    Answer: A) LEN()

  16. Which function rounds a number to the nearest integer?
    A) ROUND() B) TRUNC() C) INT() D) CEILING()
    Answer: A) ROUND()

  17. Which function removes decimal values without rounding?
    A) INT() B) ROUND() C) TRUNC() D) FLOOR()
    Answer: C) TRUNC()

  18. Which function returns the remainder after division?
    A) REMAINDER() B) MOD() C) DIV() D) RESIDUE()
    Answer: B) MOD()

  19. To find the square root of a number, use:
    A) SQRT() B) ROOT() C) POWER() D) SQUARE()
    Answer: A) SQRT()

  20. Which function counts all numeric and text cells in a range?
    A) COUNTA() B) COUNT() C) COUNTBLANK() D) SUM()
    Answer: A) COUNTA()

  21. Which function returns TRUE if all conditions are TRUE?
    A) AND() B) OR() C) NOT() D) IF()
    Answer: A) AND()

  22. Which function returns TRUE if any condition is TRUE?
    A) IF() B) OR() C) AND() D) TEST()
    Answer: B) OR()

  23. The function to reverse a logical value is:
    A) IF() B) AND() C) OR() D) NOT()
    Answer: D) NOT()

  24. The function that looks up data horizontally is:
    A) VLOOKUP() B) HLOOKUP() C) MATCH() D) INDEX()
    Answer: B) HLOOKUP()

  25. Which function finds the position of a value in a range?
    A) POSITION() B) INDEX() C) MATCH() D) LOCATE()
    Answer: C) MATCH()

  26. Which function retrieves a value by row and column number?
    A) MATCH() B) INDEX() C) LOOKUP() D) OFFSET()
    Answer: B) INDEX()

  27. Which function combines INDEX and MATCH for lookups?
    A) INDEXMATCH B) LOOKUP C) XLOOKUP D) FIND
    Answer: C) XLOOKUP

  28. Which function removes non-printable characters from text?
    A) CLEAN() B) TRIM() C) REMOVE() D) DELETE()
    Answer: A) CLEAN()

  29. Which feature allows hiding certain rows based on conditions?
    A) Filter B) Sort C) Data Validation D) Group
    Answer: A) Filter

  30. Which feature arranges data alphabetically or numerically?
    A) Sort B) Filter C) Pivot Table D) Group
    Answer: A) Sort

  31. Which tab contains the “Sort & Filter” option?
    A) Home B) Data C) Insert D) Formulas
    Answer: B) Data

  32. Which function finds the average of values meeting a condition?
    A) AVERAGEIF() B) COUNTIF() C) SUMIF() D) MEANIF()
    Answer: A) AVERAGEIF()

  33. Which function sums values that meet criteria?
    A) SUMIF() B) COUNTIF() C) AVERAGEIF() D) ADDIF()
    Answer: A) SUMIF()

  34. The shortcut key for Find and Replace is:
    A) Ctrl + F B) Ctrl + H C) Ctrl + Shift + F D) Ctrl + R
    Answer: B) Ctrl + H

  35. To open the Find dialog box:
    A) Ctrl + F B) Ctrl + H C) F3 D) Ctrl + G
    Answer: A) Ctrl + F

  36. To create a table quickly, press:
    A) Ctrl + T B) Ctrl + Shift + T C) Alt + T D) F11
    Answer: A) Ctrl + T

  37. The Freeze Panes option helps in:
    A) Keeping rows/columns visible B) Hiding rows C) Locking workbook D) Protecting cells
    Answer: A) Keeping rows/columns visible

  38. Which tab contains the “Freeze Panes” option?
    A) View B) Data C) Review D) Insert
    Answer: A) View

  39. To protect a worksheet, go to:
    A) Review tab B) Data tab C) Home tab D) View tab
    Answer: A) Review tab

  40. The default row height in Excel is approximately:
    A) 15 B) 12 C) 10 D) 18
    Answer: A) 15

  41. The default column width in Excel is approximately:
    A) 8.43 B) 10 C) 9 D) 7
    Answer: A) 8.43

  42. Which shortcut key repeats the last action?
    A) F4 B) Ctrl + Y C) Both A and B D) Ctrl + Z
    Answer: C) Both A and B

  43. The shortcut to undo the last action is:
    A) Ctrl + Z B) Ctrl + Y C) Ctrl + X D) Ctrl + U
    Answer: A) Ctrl + Z

  44. The shortcut to redo the last undone action is:
    A) Ctrl + Y B) Ctrl + Z C) Ctrl + X D) Ctrl + R
    Answer: A) Ctrl + Y

  45. Which key combination closes Excel completely?
    A) Alt + F4 B) Ctrl + W C) Ctrl + F4 D) Shift + F4
    Answer: A) Alt + F4

  46. Which chart is best for showing part-to-whole relationships?
    A) Line chart B) Pie chart C) Column chart D) Bar chart
    Answer: B) Pie chart

  47. Which chart displays data comparisons in vertical bars?
    A) Column chart B) Line chart C) Pie chart D) Area chart
    Answer: A) Column chart

  48. Which chart shows cumulative totals over time?
    A) Area chart B) Scatter chart C) Line chart D) Pie chart
    Answer: A) Area chart

  49. Which chart is best for showing relationships between two numeric variables?
    A) Scatter chart B) Line chart C) Pie chart D) Bar chart
    Answer: A) Scatter chart

  50. To insert a Sparkline, go to which tab?
    A) Insert B) View C) Data D) Review
    Answer: A) Insert

Leave a Comment

Your email address will not be published. Required fields are marked *

You cannot copy content of this page

Scroll to Top