> > >

Excel MCQs

You want a drop down list with a blank space between "apple" and "banana". How do you do this?

Create a Named Range with "apple" in the first cell, nothing in the second cell, and "banana" in the third cell. Then, point the list to that named range.

Go to data validation, list, source and type the following: "apple", "", "banana"

=list("apple","blank","banana")

Not possible.

Answer

Correct Answer: Create a Named Range with "apple" in the first cell, nothing in the second cell, and "banana" in the third cell. Then, point the list to that named range.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it