MCQs > Finance & Management > Excel > Which formula will provide the same result as the following: =SUMPRODUCT(A1:A10,B1:B10)

Excel MCQs

Which formula will provide the same result as the following: =SUMPRODUCT(A1:A10,B1:B10)

Answer

Correct Answer: {=SUM(A1:A10*B1:B10)} (array formula)

Explanation:

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

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it