MS Excel Quiz Questions and Answers

Question 21

How can you create a dynamic named range in Excel?

• Use the "Define Name" feature

• Apply a filter to a column

• Use the "Paste Special" option

• Both A and B
  

Question 22

What is the purpose of the DATEDIF function in Excel?

• Calculates the difference between two dates

• Converts a date to a specific format

• Checks if a date falls on a weekend

• Rounds a date to the nearest month

Question 23

What is the purpose of the PMT function in Excel?

• Converts a number to text with a specified format

• Returns the payment for an investment based on periodic, constant payments

• Finds the present value of an investment

• Calculates the difference between two dates

Question 24

What does the term "Array Formula" mean in Excel?

• A formula that returns an array of values

• A formula entered into multiple cells simultaneously

• A formula that performs operations on an entire range of cells

• A formula that uses the ARRAY function

Question 25

What is the purpose of the FORMULATEXT function in Excel?

• Returns the formula of a cell as text

• Converts a formula to a numerical result

• Rounds a number to the nearest integer

• Checks for errors in a range of cells