MS Excel Quiz Questions and Answers

Using the AutoFill feature

Applying conditional formatting

Using the Data Validation feature

Applying a filter to a column

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

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

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

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

Use the "Define Name" feature

Apply a filter to a column

Use the "Paste Special" option

Both A and B

Apply a password to the sheet

Use the "Protect Worksheet" option in the Review tab

Lock individual cells

All of the above

Rounds a number to the nearest integer

Converts a value to a number

Finds the nth largest value in a range

Counts the number of cells that contain numbers

The title of the chart

The labels on the x-axis

The numeric values plotted on the chart

The legend of the chart
 

Select multiple sheets, right-click, and choose "Group Sheets"

Use the "Group" option in the Home tab

Drag and drop sheet tabs into a new group

All of the above