1 / 37

5+2 4

5+2 4. =5+2^4. =SQRT(a) =a^0,5 = a^(1/2 ). - Negative % percentage ^ power /, * div., multp. +, - sum, subtr. =5+2*3^1/2. =(5^3-4^3)/(105+8^(1/3)). 2,335548. 2,335548. A2=25 A3=4 B1= Write the formule below in C6 by using reference cell address:.

rae-garza
Télécharger la présentation

5+2 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 5+24 =5+2^4

  2. =SQRT(a) =a^0,5 =a^(1/2)

  3. - Negative % percentage ^ power /, * div., multp. +, - sum, subtr.

  4. =5+2*3^1/2

  5. =(5^3-4^3)/(105+8^(1/3))

  6. 2,335548

  7. 2,335548

  8. A2=25 A3=4 B1= • Write the formule below in C6 by using reference cell address:

  9. Write the formule by using relative cell references to write from 1 to 10 in cell range B2:B11.

  10. relative cell references.

  11. A2=1….. A11=10 • C2=5 • Write formule from 1 to 50 with 5 steps into cell range B2:B11 by using absolute cell reference.

  12. Absolute cell reference.

  13. Creating a Table of One Variable Function Y=x2 Z=x3 xi=1,2,3,...,10 Xi2=? Xi3=?

  14. Creating a Table of Two Variable Function x=1,2,3,...,5 Y=1,2,3,...,6 U(3,4)=? U(5,2)=?U(5,6)=?

  15. Prepare Multiplication Table by using Data Table Command X=1,2,3,...,10 Y=1,2,3,...,10

  16. CONSOLIDATE

  17. Ax=b A-1Ax=A-1b Ix=A-1b X=A-1b

  18. X=4 Y=2 Z=3

  19. y=x2-2x+1

  20. An airway firm has two different type of planes. DK-1 and BW-10. DK-1 can carry 40 passengers, 30 tons cargo. BW-10 can carry 60 passengers, 15 tons cargo. Airway firm has signed an agreement to carry minimum 480 passengers and minimum of 180 tons cargo for everyday. Fly costs for DK-1 is 500$ and for BW-10 is 600$. For minimum total cost how many flight must be done with each plane?

  21. DK-1  X BW-10  Y Z=500X+600Y 40X+60Y  480 passenger X  0 30X+15Y  180 cargos Y  0

  22. Type X= in C1 Y= in C2 Z= in E1 • =40*D1+60*D2 into C4 • =30*D1+15*D2 into C5 • =500*D1+600*D2 into G1

  23. A farmer has 100 acres on which to plant two crops: corn and wheat. To produce these crops, there are certain expenses, as shown in the table: After the harvest, the farmer must usually store the crops while awaiting favorable market conditions. Each acre yields an average of 110 bushels of corn or 30 bushels of wheat. The limitations of resources are: If the net harvest profit (after all expenses have been subtracted) per bushel of corn is $ 1,30 and for wheat is $ 2,00 how should the farmer plant the 100 acres to maximize profits?

  24. Transco, Inc. makes a deluxe and a standard model of a Global positioning System (GPS) –a handle device for navigating via a system of 24 Satellites. They are currently trying to determine the optimal number of each model to produce each day. Their profit is $ 120 for each deluxe model and $ 80 for each standard model. Transco has 80 working-hours per day available (that is, 10 people working 8-hours shifts per day) producing a deluxe model takes 2 hours, whereas producing a standard model takes 1 hour. No more than 30 deluxe models per day can be produced, and company policy is that the number of deluxe models produced must be at least half of the number of standard models. (For example, if 20 standard models are produced, the number of deluxe models must be at least 10.) The company can sell all of the GPS models it produces.

More Related