- Courses
- Tutorials
- Practice
- Jobs
MS Excel Quiz Questions and Answers
Question 1
How can you create a drop-down list in Excel?
- A
Using the AutoFill feature
- B
Applying conditional formatting
- C
Using the Data Validation feature
- D
Applying a filter to a column
Question 2
What is the purpose of the FORMULATEXT function in Excel?
- A
Returns the formula of a cell as text
- B
Converts a formula to a numerical result
- C
Rounds a number to the nearest integer
- D
Checks for errors in a range of cells
Question 3
What does the term "Array Formula" mean in Excel?
- A
A formula that returns an array of values
- B
A formula entered into multiple cells simultaneously
- C
A formula that performs operations on an entire range of cells
- D
A formula that uses the ARRAY function
Question 4
What is the purpose of the PMT function in Excel?
- A
Converts a number to text with a specified format
- B
Returns the payment for an investment based on periodic, constant payments
- C
Finds the present value of an investment
- D
Calculates the difference between two dates
Question 5
What is the purpose of the DATEDIF function in Excel?
- A
Calculates the difference between two dates
- B
Converts a date to a specific format
- C
Checks if a date falls on a weekend
- D
Rounds a date to the nearest month
Question 6
How can you create a dynamic named range in Excel?
- A
Use the "Define Name" feature
- B
Apply a filter to a column
- C
Use the "Paste Special" option
- D
Both A and B
Question 7
How can you protect a worksheet in Excel from being edited?
- A
Apply a password to the sheet
- B
Use the "Protect Worksheet" option in the Review tab
- C
Lock individual cells
- D
All of the above
Question 8
What is the purpose of the N function in Excel?
- A
Rounds a number to the nearest integer
- B
Converts a value to a number
- C
Finds the nth largest value in a range
- D
Counts the number of cells that contain numbers
Question 9
In Excel, what does the term "Data Series" refer to in a chart?
- A
The title of the chart
- B
The labels on the x-axis
- C
The numeric values plotted on the chart
- D
The legend of the chart
Question 10
How can you group worksheets in Excel?
- A
Select multiple sheets, right-click, and choose "Group Sheets"
- B
Use the "Group" option in the Home tab
- C
Drag and drop sheet tabs into a new group
- D
All of the above
There are 25 questions to complete.
