Which formula returns the sum of the three smallest values in a range named Data?
Correct Answer: =SUM(SMALL(Data,{1,2,3}))
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
To convert fluid ounces to milliliters you can use the following function:
A ____ is essentially a dynamic summary report generated from a database.
Which of the following is true for dates and times (choose all that apply)
What will be displayed in the cell if the following formula is typed? =SUM({1,2,3,4}*{5,6,7,8})
Which option would you to use visualize the relative value of cells in a range?
Which is the proper vba naming convention for a macro?
Which of the following will be true to add only positive numbers in a column.
In print preview, what is selected/displayed?
How can you format one sparkline separately from all the others?
How may criteria can the SUMIF function have?