Excel Quiz

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

What is the keyboard shortcut for copying cells in Excel?

• Ctrl + X

• Ctrl + C

• Ctrl + V

• Ctrl + Z

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

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

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

• AVG()

• MAX()

• SUM()

• 
  TOTAL()

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

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"

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

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

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