Question: For this problem you need to download data set Data Set # 2 a . xlsx . What is the Excel code to copy

For this problem you need to download data set "Data Set #2a.xlsx". What is the Excel code to copy the Status code column but replace and blank/missing values with "Missing".
Group of answer choices
=IF(OR(B12="",B12=""),"Missing",B12)
=IF(AND(B12="",B12=""),"Missing",B12)
=IF(B12="Missing","Missing",B12)
=IF("Missing",B12,"Missing")
=Vlookup(B12,"",Missing",B12)
None of these

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!