The Exce $\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 )$ will calculate
A) the number of multiples found in the ranges A1 through C3 and E1 through E3.
B) the smallest value in the ranges A1 through C3 and E1 through E3.
C) the largest value in the ranges A1 through C3 and E1 through E3.
D) the product of the matrices in ranges A1 through C3 and E1 through E3.

Question

Quizplus · Accepted Answer

The MMULT function in Excel calculates the matrix product of two arrays, in this case, the arrays in ranges A1:C3 and E1:E3.

The Exce formula = MMULT (A1:C3,E1:E3)\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 ) formula = MMULT (A1:C3,E1:E3)

The Exce $\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 )$