Class 7 - Excel (revision)

 

1. To get the answer after adding the given numbers 

 

you could use

•  autosum
• =sum(E4:E6)
• =E4+E5+E6
• =sum(45,69,28)

Same way other functions can be used.
2. Difference between today( ) and now( )

3. The following are the different types of errors.

Find the reason for the above errors.



 4. Autosum

It is one of the widely used functions. If you have many numbers to add, don't bother to write the formula for addition, just select the range and select autosum button in the Home menu. Bingo...
If you want select non adjacent cells, press Ctrl key and select the cells you want.    

5. Cell Referencing
 By now   you must be knowing each cell has a unique address or a cell reference. The cell address is nothing but the column letter followed by the row number.

• Relative Reference

           This is the widely used reference. Here excel adjusts and changes the cell address for the new location , when you copy a formula.

    

In the above picture the values at cells A1 and A2 are added using sum function. If you copy the formula and paste it at c3, the cell address in the formula automatically changes to C1 and C2.

• Absolute Reference

      Sometimes we do not want the cell address to change, when we copy the formula. So we need to make it absolute cell reference.
This is done by adding a $ before the column letter and row number. To make C20 an absolute reference, introduce a $ symbol. Then it will be $C$20.

The second answer should be 900 if I copy the formula in cell A3 and paste in C3. But there is a twist in the story, I do not want the second value to change, so I introduce $ symbol in the second cell address making it fixed. 

 

• Mixed Reference

       In mixed reference either the column or the row remain fixed. So the formula would be $L2 or L$2.

In $F46 , the row number is allowed to change not the column.

In E$70, the column is allowed to change not the row.