Lab Activity

1. Create the following data.

1.1. Return the rate, qty and total of the “dvd”.
1.2. Return the qty of the “led”.
1.3. Return the total of the “mouse”.
1.4. Return the rate of the “pen drive”.

2. Create the following data.

2.1. Return the value from the 4th row of the “Bearings”.
2.2. Return the value from the 3rd row of the “Bolts”.
2.3. Return the value from the 2nd row of the “Axles”.
2.4. Return the value from the 2nd row of the “Bearings”.

3. Execute these functions and see the output.

=abs(-90)
=ceiling(78.23,1)
=floor(78.23,1)
=power(4,2)
=product(2,3,4)
=sum(9,10,100)
=round(678.456,2)
=round(678.456,0)
=round(678.456,-2)
=sqrt(16)