Excel Matrix Function Quiz
Question 1
Which function is used to calculate the 'Matrix Determinant' of a square array?
Question 2
What is the primary requirement for a matrix to be compatible with MINVERSE or MDETERM?
Question 3
Which function generates an 'Identity Matrix' with 1s on the diagonal and 0s elsewhere?
Question 4
In the function MMULT(Array1, Array2), what is the 'Conformability Rule' for the dimensions?
Question 5
What error does Excel return if you attempt to use MINVERSE on a matrix with a determinant of zero?
Question 6
Matrix multiplication is 'Non-Commutative.' What does this mean professionally?
Question 7
Which operator is used in modern Excel to reference an entire dynamic spill range (e.g., =A1#)?
Question 8
What is the resulting dimension of MMULT if you multiply a 3x2 matrix by a 2x4 matrix?
Question 9
Which function allows you to flip the orientation of a matrix (converting rows to columns)?
Question 10
What numeric value is returned by MMULT(A, MINVERSE(A)) where A is a valid square matrix?
Question 11
If a matrix formula returns #VALUE!, what is the most likely structural cause?
Question 12
Why should you use the ROUND function when checking if a determinant (MDETERM) is zero?
Question 13
Which function is best for solving systems of linear equations using Cramer's Rule?
Question 14
What happens if a MINVERSE formula tries to spill into cells that already contain data?
Question 15