Page 452 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Step 2: Use Index Formula
Using the INDEX function, find the sales value of “Item B” in February.

Result:
The result of the formula is the sales value of “Item B” in February, which is 90.

Related Exercises:

1 Create a data range in cells A1 to D10. Use the INDEX function to retrieve the value located in the 4th row and
3rd column.
2 Create a dataset in column A, starting from A1. Create a formula using INDEX to create a dynamic range that
automatically expands as new data is added in column A.

437
CITS : IT & ITES - Computer Software Application - Exercise 72