Interested to Buy Any Domain ? << Click Here >> for more details...
Perform the following tasks using MS-EXCEL:
FUEL ESTIMATES COMPUTATIONS: This project is to compute the
fuel needed for two types of airplanes, and the cost of the
fuel. You must do all computations using formula, and do a
chart. Use Page Setup to make the left margin 0.5 and the
right margin 0.5 also. Put your name in the Title line,
after "Fuel Estimates".
Note the following:
? Col. D - H: You must enter correct formulas under
Columns D through H (Flying Fuel, Reserve Fuel, Holding
Fuel, Total Fuel Needed and Estimated Fuel Cost)!! Read and
compute carefully!
? Cells C12, C13, C14, H13 or H14: When you use these
cells in a formula, you must make them absolute cell
references (F4 key after your type the cell reference, or
enter the $ sign manually)
? Graph/Chart: Select cells A3:B8 (Plane and Flight).
Hold down the "Control" key and select D3:D8. Hold down
the "Control" key and select G3:G8. Create a chart (Insert-
Chart, Finish) and position it in a pleasing way under the
data for the flight. Print it on one sheet, in landscape
mode.
? Print again, but with Formulae: There are two ways
to show formulas:
1) Enter Control+` (the key with the ~ at the top left)
or 2) Tools-Options, and under "Window Options" put a check
mark beside "Formulas", then close the window.
- 3 Answers
- 12797 Views
- Excel, Ignou, San, Softweb, I also Faced
- E-Mail Answers
Answer Posted / j. wang
Fuel Required =C4*(VLOOKUP(A4,$A$16:$C$18,3))
Reserve Fuel =D4*$H$19
Holding Fuel=D4*$H$20
Total fuel =SUM(D4:F4)
Cost =IF(G4>=$H$16,G4*$H$17,G4*$H$18)
After you filling-out row 4 for column D-H, Simply copy the
formulas to the end of the table required.
Hope this help.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do I repair microsoft edge?
look into my data in sheet1- A-1,2,3,4,5,6 sheet2-2,4,7,8,9 compare the data get result like sheet2: 2-yes(present in sheet1) 4(present in sheet1) 7(not present in sheet2) 8(not present in sheet2) 9(not present in sheet2)
While server generating the patches . that time server pull or push the resources?
How does xaml relate to e-speak? : xaml
What is CPU (Central Processing Unit)
How do I get the microsoft edge icon on my desktop?
What is the purpose of krne32.dll?
What is Workstation ?
what is 'macro' in excel? how to make use of it ?
what is the capacity of MS outlook and Outlook Express?
What does microsoft blend do?
What replaced microsoft paint?
Does microsoft have a virus protection?
Server Got down ..what are the primary steps need to take initially ? mail me asap?
What is microsoft compatibility telemetry?
