Page 259 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

1 Horizontal or Row Array constant
A horizontal constant is present in a row. To create a horizontal constant we have to type multiple values separated
by a comma in the enclosed braces. To enter a row array follow these steps below:

Step 1: Select the cells you want to work with.
Step 2: Go to the formula bar and start with an equal sign.
Step 3: Now enter the array you want to create in braces {}, separated by commas(,). Ex:- ={1,2,3,4,5}
Step 4: Now press Ctrl+Shift+Enter.

Horizontal-or-Row-Array-constant

2 Vertical or Column Array
Vertical array constants are generally present in Column Array. To create a vertical constant we have to type
multiple values separated by a semicolon in the enclosed braces. To enter a column array follow these steps
below:
Step 1: Select the cells you want to work with.
Step 2: Go to the formula bar and start with an equal sign.
Step 3: Now enter the array you want to create in braces {} separated with termination sign(;). Ex:- ={“Coding”;”
GFG”;”GeeksforGeeks”}
Step 4: Now press Ctrl+Shift+Enter.
Vertical-or-Column-Array

246

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