Page 258 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Function-arguments
Multi-Cell Array Formula
If you wish to perform the same calculation with more cells then you can use the multi-cell formula. You can
implement it in two ways. Functions like TRANSPOSE, TREND, FREQUENCY, LINEST, etc are used for the
multi-cell arrays. Implement the formula in single-cell by following the above steps. Now, drag the selection up to
the cells you want to implement the formula. Below is the implementation of doing that.

Multi-cell-array-formula
Alternatively,
Specify the range of cells and an operator between them. For example, =(B1:B7 + C2:C7) and press Ctrl+Shift+Enter.
Operator-in-multi-cell

Excel Array Constants
Excel array contacts are a set of static values and can’t be changed. These values remain constant regardless
of the operations performed on them. Now we will see how to create Array Constants in Excel and will perform
different actions on them. There are three types of array constant available:

245

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77