Correct Answer: Use "SUMPRODUCT"
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
More Excel MCQ Questions
Which function, other than 'transpose', can be used to transpose the contents of an array of cells?
To change the color of a slice in a pie chart:
In which tab do you find Macros in Excel 2013?
Which keyboard shortcut selects all cells referenced by formulas in the selection?
To use the Subtotals feature, the list that has numbers you want to add must be:
=WEEKDAY(A1)=2 The above validation formula ensures that:
To restrict values entered in a range between 0 and 10 we can use?
To remove all non printing characters from a cell you can use the following function?
A #VALUE! error is very common and can occur under the following conditions:
To autofill month names you need to type __ and then drag the fill handle. (choose all that apply)