Page 413 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

• After that, press ENTER.

Note: Check the image carefully until you see a light blue line around the cells in Column E. This
is because they are in an array. We didn’t use the Fill Handle or anything like that to fill these
cells.

Here, we’re using Microsoft Excel 365 version. So, we can run the array formula by pressing ENTER. But, in the
older version do the following steps.
• So, first select E5:E14 and type the above formula in cell E5.
• After that, press CTRL + SHIFT + ENTER at a time.

Note: After pressing these buttons, a pair of curly brackets will automatically be applied within
two sides of the formula. You don’t have to write them manually.

Also, you can’t make any changes inside the cell of an array. Excel will not allow you to do this. If you ever try to
do this kind of thing, the following phenomena will happen.

• Here, go to cell E8 and change the cell element to 5.
• After that, press ENTER.
Immediately, Excel will show a warning box on the display like the image below.

398
CITS : IT & ITES - Computer Software Application - Exercise 68