25 Multiple Choice Questions on Microsoft Excel

Basic Questions

  1. What is the default file extension of an Excel workbook?
    a) .docx
    b) .xlsx
    c) .pptx
    d) .xlsm

    • Answer: b) .xlsx
  2. Which shortcut key is used to save a workbook in Excel?
    a) Ctrl + S
    b) Ctrl + P
    c) Ctrl + X
    d) Ctrl + V

    • Answer: a) Ctrl + S
  3. What is the intersection of a row and a column called?
    a) Box
    b) Cell
    c) Table
    d) Grid

    • Answer: b) Cell
  4. Which symbol is used to start a formula in Excel?
    a) #
    b) @
    c) =
    d) &

    • Answer: c) =
  5. What does the SUM function do in Excel?
    a) Counts the number of cells
    b) Finds the highest value
    c) Adds a range of numbers
    d) Finds the lowest value

    • Answer: c) Adds a range of numbers

Formulas and Functions

  1. Which of the following is NOT a function in Excel?
    a) AVERAGE
    b) COUNT
    c) SUM
    d) COMBINE

    • Answer: d) COMBINE
  2. Which function is used to find the largest number in a range?
    a) MAX
    b) MIN
    c) AVERAGE
    d) LARGE

    • Answer: a) MAX
  3. Which function is used to count the number of numeric values in a range?
    a) COUNTA
    b) COUNT
    c) SUM
    d) COUNTIF

    • Answer: b) COUNT
  4. What does the IF function do?
    a) Formats text
    b) Adds numbers
    c) Performs a logical test
    d) Converts numbers into text

    • Answer: c) Performs a logical test
  5. What will =ROUND(25.678,2) return?
    a) 25.6
    b) 25.68
    c) 25.67
    d) 25.7

  • Answer: b) 25.68

Formatting and Editing

  1. Which shortcut key is used to bold text in Excel?
    a) Ctrl + B
    b) Ctrl + U
    c) Ctrl + I
    d) Ctrl + Shift + B
  • Answer: a) Ctrl + B
  1. What feature allows you to apply a format to multiple cells based on a condition?
    a) Data Validation
    b) Conditional Formatting
    c) AutoFill
    d) Data Filter
  • Answer: b) Conditional Formatting
  1. Which tab in the ribbon contains the Merge & Center button?
    a) Home
    b) Insert
    c) View
    d) Data
  • Answer: a) Home
  1. How can you remove all formatting from a cell?
    a) Press Delete
    b) Use Clear Formats
    c) Use Find and Replace
    d) Use AutoFill
  • Answer: b) Use Clear Formats
  1. Which option is used to change the background color of a cell?
    a) Font Color
    b) Fill Color
    c) Conditional Formatting
    d) Borders
  • Answer: b) Fill Color

Data Management and Analysis

  1. Which feature allows you to quickly fill a series of cells with data or a pattern?
    a) AutoFormat
    b) AutoFill
    c) Data Validation
    d) Sorting
  • Answer: b) AutoFill
  1. What does the Filter feature do?
    a) Sorts data
    b) Highlights duplicates
    c) Hides non-matching rows
    d) Merges cells
  • Answer: c) Hides non-matching rows
  1. Which tool is used to summarize and analyze data in Excel?
    a) Pivot Table
    b) AutoSum
    c) VLOOKUP
    d) COUNTIF
  • Answer: a) Pivot Table
  1. Which function is used to search for a value in a column and return a value from another column?
    a) VLOOKUP
    b) HLOOKUP
    c) INDEX
    d) MATCH
  • Answer: a) VLOOKUP
  1. Which function helps in finding the position of a value within a range?
    a) FIND
    b) SEARCH
    c) MATCH
    d) INDEX
  • Answer: c) MATCH

Shortcuts and Special Features

  1. Which shortcut is used to insert a new worksheet in Excel?
    a) Ctrl + N
    b) Shift + F11
    c) Alt + Shift + N
    d) Ctrl + Shift + N
  • Answer: b) Shift + F11
  1. Which key is used to edit a selected cell?
    a) F2
    b) F4
    c) Enter
    d) Esc
  • Answer: a) F2
  1. What happens when you press Ctrl + Z in Excel?
    a) Redo the last action
    b) Undo the last action
    c) Save the file
    d) Copy the text
  • Answer: b) Undo the last action
  1. Which key combination is used to apply or remove filters?
    a) Ctrl + Shift + L
    b) Ctrl + L
    c) Alt + F4
    d) Ctrl + Alt + L
  • Answer: a) Ctrl + Shift + L
  1. Which of the following is NOT a valid Excel data type?
    a) Text
    b) Number
    c) Formula
    d) Paragraph
  • Answer: d) Paragraph


 

No comments:

Post a Comment

post deatails

What is a Prompt Engineering Course?

  🌟 What is a Prompt Engineering Course? The Prompt Engineering Course is designed to teach individuals how to craft effective prompts fo...

Popular Posts of this Blog