While working on an excel sheet, Joe used a formula which returns him “#NA” in some rows. Which function can be used to convert it to “NA”.

IFNA

IFERROR

IF(C1==“#NA”, “NA”,C1)

All of the above

Verified Answer
Correct Option - a

To get all Self Assessment for Exploring Excel Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Thu, 11 Dec 2025