1
LAB ASSIGNMENT -6
MATRIX OPERATIONS IN EXCEL
8.1 ARRAYS IN EXCEL:
Excel uses arrays to store a collection of variables. These arrays can be used to perform
matrix operations. To declare a bunch of numbers as an array, you select the numbers that make
up the matrix and type the name of the array in the “Name Box” as shown in the Figure 8.1.
Figure 8.1 Naming arrays
Alternately, we can name an array by selecting the numbers and clicking on the
“Formulas” ribbon and choosing “Define name”. Using named arrays ensures that we can use the
names instead of the cell range in array formulas. It is not necessary to name the arrays for
matrix operations in Excel but this helps in keeping the spreadsheet organized and easy to
understand.
8.2 BASIC MATRIX OPERATIONS:
8.2.1 ADDITION:
Before performing the addition, you should ensure that the matrices to be
added are of the same size. Name the two matrices as arrays A and B using the method described
above.
Figure 8.2 Matrix addition using array math in excel
In the above example, A and B are both square matrices of size 3x3.
The resulting matrix (A+B)
would also be of the order 3x3. When using array math in Excel, we should always indicate the

This ** preview** has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*