Array Functions
Advanced

MMULT Function

Multiply two matrices using MMULT.

Task:

Multiply the two matrices to get the product matrix.

Learning Objectives:

  • Learn MMULT function
  • Understand matrix multiplication
  • Practice linear algebra
Hints

Solve without hints for +5 XP

Interactive Spreadsheet

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

ABCD
1Array 1Array 2
21234
33456
4Result
5
What this exercise teaches (contains the answer)

MMULT returns the matrix product of two arrays, following matrix multiplication rules.