Microsoft Excel Basic and Advance 5

Question 1

What does the MATCH function return?

Accepted Answer

The relative position of a value within a range

Answer

MATCH returns the relative position (1-based number) of a lookup value within a one-dimensional range.

Question 2

Which Excel data tool removes duplicate rows from a selected range or table?

Accepted Answer

Remove Duplicates

Answer

The Remove Duplicates command on the Data tab deletes rows where every selected column's value is identical to another row.

Question 3

What is the function of Data Validation in Excel?

Accepted Answer

It restricts the type or range of data a user can enter in a cell

Answer

Data Validation sets rules (whole numbers, dates, list choices, etc.) that limit what values can be entered into a cell.

Question 4

In Excel, what is a named range?

Accepted Answer

A descriptive name assigned to a cell or range for use in formulas

Answer

A named range assigns a meaningful label to a cell or range so formulas can reference it by name instead of cell address.

Question 5

Which function calculates the payment for a loan based on constant payments and a constant interest rate?

Accepted Answer

PMT

Answer

PMT(rate, nper, pv) calculates the fixed periodic payment required to pay off a loan over a set number of periods at a given interest rate.

Excel Practice Test