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

The value of the matched cell

Answer

TRUE or FALSE depending on whether a value exists

Answer

The address of the matched cell

Question 2

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

Accepted Answer

Remove Duplicates

Answer

Filter

Answer

Text to Columns

Answer

Consolidate

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

It checks formulas for syntax errors

Answer

It encrypts cell contents

Answer

It auto-formats numbers as you type

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 range that has been formatted with a border

Answer

A range that spans multiple worksheets

Answer

A range locked with a password

Question 5

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

Accepted Answer

PMT

Answer

FV

Answer

PV

Answer

NPV

Question 6

What happens to a PivotTable when the underlying source data changes?

Accepted Answer

It must be manually refreshed to reflect the new data

Answer

It updates automatically in real time

Answer

It deletes and must be recreated

Answer

It displays a #REF! error

Question 7

Which Excel feature records a sequence of actions so they can be replayed automatically on demand?

Accepted Answer

Macro

Answer

Conditional Formatting

Answer

Quick Analysis

Answer

Goal Seek