Array Functions
Advanced
MDETERM Function
Calculate the determinant of a matrix.
Task:
You need to find the determinant of a matrix. Calculate the determinant of the matrix in A2:B3 using the MDETERM function and display the result in B4.
Learning Objectives:
- Learn MDETERM function
- Understand matrix determinant
- Practice linear algebra
Hints
Solve without hints for +5 XP
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.
| A | B | |
|---|---|---|
| 1 | Matrix | |
| 2 | 4 | 7 |
| 3 | 2 | 6 |
| 4 | Determinant |
What this exercise teaches (contains the answer)
MDETERM calculates the matrix determinant, a scalar value used in linear algebra.