MS Excel Quiz Questions and Answers

Last Updated :
Discuss
Comments

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

Discuss it

Question 2

What is the keyboard shortcut for copying cells in Excel?

  • Ctrl + X

  • Ctrl + C

  • Ctrl + V

  • Ctrl + Z

Discuss it

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

Discuss it

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

Discuss it

Question 5

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

  • AVG()

  • MAX()

  • SUM()

  • TOTAL()

Discuss it

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

Discuss it

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"

Discuss it

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

Discuss it

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

Discuss it

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

Discuss it
Tags:
News

There are 25 questions to complete.

Take a part in the ongoing discussion
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy