Page 181 - IT_V1.0_Class10
P. 181
Cell Referencing Using Keyboard
Total Sales of individual items must be automatically calculated and stored in Quarter Sales sheet through
cell referencing using keyboard.
To calculate Total Sales of Pen, i.e., to make the cell reference in cell B2:
Step 1: Type the given formula in the cell B2 =SUM(January.B2;February.B2;March.B2)
1
Step 2: Use Autofill to calculate the Quarter sales of rest of items.
Cell Referencing Using Mouse
Now, let us learn how to create cell referencing using mouse.
Step 1: Type = sign in the Formula Bar.
Step 2: Type the desired mathematical function. Here, SUM function is used, so we type =SUM(
2
Step 3: Select cell B3 from January sheet tab.
Step 4: Type , (comma) after January.B3 in order to take more cells for referencing from different sheets.
Step 5: Select similarly for cell B3 from February sheet tab.
Linking Spreadsheet Data 179

