GK QUESTION#1880

In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula without changing the formula itself.

AINDIRECTCorrect answer
BVLOOKUP
CTRANSPOSE
DMATCH

Show AnswerHide Answer

Answer

A. INDIRECT

Show ExplanationHide Explanation

Explanation

INDIRECT converts a text reference into a cell reference. If A1 contains the text B2, =INDIRECT(A1) uses B2; changing A1 to B3 changes the referenced cell while the formula remains =INDIRECT(A1).

Menu

Game modes

Account

In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula without changing the formula itself.

Answer

Explanation

In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula without changing the formula itself.

Answer

Explanation

Explore this topic