Co-Authored By:

**Excel functions**thatyouwill be

**using**to complete these

**matrix**operationsare

**array functions**– returning more than one value atatime. To enter an

**array function**into aMicrosoft

**Excel**worksheet, you must hold down the CTRL andSHIFT keyswhile pressing the ENTER key:CTRL+SHIFT+ENTER.

Also question is, what does the Mmult function do in Excel?

**Excel MMULT Function**. The **ExcelMMULTfunction** returns the matrix product of two arrays. Thearrayresult contains the same number of rows as array1 and thesamenumber of columns as array2. If returning multiple results inanarray on the worksheet, enter as an array formula with control+shift + enter.

**a) Enter the matrices A into the Excel sheet as:**

- Notice that Matrix A is in cells B2:D4.
- b) We find the inverse of matrix A by Highlighting thecellswhere you want to place the.
- = MINVERSE(B2:D4)
- d) When the formula is entered, press the Ctrl key and theShiftkey simultaneously, then.
- press the Enter key.

Also Know, what is the matrix function?

**Matrix function**. From Wikipedia, thefreeencyclopedia. In mathematics, a **matrix function** isa**function** which maps a **matrix** toanother**matrix**.

The Microsoft **Excel MINVERSE** function returnstheinverse matrix for a given matrix. The **MINVERSE** functionisa built-in function in **Excel** that is categorized asaMath/Trig Function. It **can** be used as a worksheetfunction(WS) in **Excel**.