56 total views, 1 views today

## Activity : 02

- Which types of data can you enter in the cells of an Excel sheet?

Answer:

- What is the Order & Precedence of following Operations in Excel?

Answer:

3. Write down the answers by simplifying the formula below.

- =50*(20/2^2) = ………………………..
- =60+3*6-12 = ………………………..
- =34-12*2/2 = ………………………..
- =100+100/50*3^2 = ………………………..
- =(25/5*2)+5^2 = ………………………..

Answer:

- Answer the questions using only cell references in the worksheet below.

- What is the formula that can be used to display the gross price of pens for
**E4**.

Answer:

- What is the formula that can be used to display the discount value of pens for
**G4**.

Answer:

- What is the formula that can be used to display the net price of pens for
**H4**.

Answer:

- After calculating the gross value for one item, write down how to get it for the other items.

Answer:

- Write a formula to get the bill value to be paid for all the items supplied for
**H12**.

Answer:

5. The following are the two methods used to calculate the value of the following bills. What are the advantages of using formulas using cell addresses like D10 instead of G3?

Answer:

6. Write the final result of following formulas according to given worksheet.

=A2*A3/B1 =…………………..

=B2+A1*(B1^C2) =…………………..

=((B3+A3)^C2)-A1/C1 =…………………..

=(B3^A3)*C3+A2-A1/C2 =…………………..

Answer:

7. The following are the two methods used to calculate the total of the following bills. What are the advantages of writing formulas using functions similar to G10 instead of cell addresses as in G3?

Answer: