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