Electronic Spreadsheet 02

  • by

 56 total views,  1 views today

Activity : 02

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

Answer:


  1. 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:


  1. 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:


0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments