• Courses
  • Tutorials
  • Jobs
  • Practice
  • Contests

MS Excel Quiz Questions and Answers

Question 1

How do you insert a new worksheet in Excel?

  • Right-click on a sheet tab and choose "Insert"

  • Go to the "Home" tab and click "Insert Sheet"

  • Press Ctrl + N

  • Both A and B

Question 2

What is the keyboard shortcut for copying cells in Excel?

  • Ctrl + X

  • Ctrl + C

  • Ctrl + V

  • Ctrl + Z

Question 3

In Excel, what does the function COUNTA() do?

  • Counts the number of cells in a range that are not blank

  • Counts the number of cells in a range that are greater than zero

  • Counts the number of cells in a range that contain text

  • Counts the total number of cells in a range

Question 4

What does the term "cell" refer to in Microsoft Excel?

  • A group of worksheets

  • The intersection of a row and column

  • A type of chart

  • A formatting option

Question 5

Which function is used to sum a range of cells in Excel?

  • AVG()

  • MAX()

  • SUM()

  • TOTAL()

Question 6

What is the purpose of the AutoSum button in Excel?

  • It adds up a range of cells

  • It multiplies a range of cells

  • It calculates the average of a range of cells

  • It finds the maximum value in a range

Question 7

How do you change the width of a column in Excel?

  • Drag the column boundary

  • Use the "Format Painter"

  • Apply a cell style

  • Right-click and select "Column Width"

Question 8

How do you remove duplicate values in a column in Excel?

  • Use the "Remove Duplicates" feature

  • Apply a filter

  • Sort the column in ascending order

  • Manually delete duplicates

Question 9

How can you merge cells in Excel?

  • Use the "Merge & Center" button

  • Apply a cell style

  • Use the "Merge Cells" option in the Format menu

  • Both A and C

Question 10

What is the purpose of the IF function in Excel?

  • To perform mathematical calculations

  • To create conditional statements

  • To generate random numbers

  • To format cells

There are 25 questions to complete.

Last Updated :
Take a part in the ongoing discussion