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
? 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
? 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.
Answers were Sorted based on User's Feedback
Answer / j. wang
Fuel Required =C4*(VLOOKUP(A4,$A$16:$C$18,3))
Reserve Fuel =D4*$H$19
Total fuel =SUM(D4:F4)
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|
Answer / sunny kumar
I would like to know the answer, please send me answer this
|Is This Answer Correct ?||6 Yes||2 No|
Answer / k.ganesan
I would like to know the answer
|Is This Answer Correct ?||5 Yes||4 No|
What is the Drawback of DHCP?
1.How can data be developed on Microsoft excel 2. what is the importance of Microsoft Excel to the society
What authentication options do Windows 2000 Servers have for remote clients?
how to convert additional domain to primary domain controller on windows 2003 server
What is Standby ?
DOTNET -> WPF what is Freezable?
Enumerate the high level of the <bindings> and <binding> element.
How to confgiure sccm in AD for synchronization
What is Telnet
which is the best ineptitude for MSBI in hyderabad?
Types of DNS Servers?
What is WAN (Wide Area Network) ?