SOLVED: While working on an excel sheet, Joe used a formula which returns him “#NA” in s ...

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://grateful.prepflix.in/infy-lex-pdfs