Anytime when you return more than a single cell, you should be using array formula. Array formulas are special formulas that work on an array of numbers and it will work effectively if you press the following keys combination?
Correct Answer: Ctrl+Shift+Enter
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More Excel MCQ Questions