Sign Up Login


  1. Categories >> Software >> Microsoft Related >> Microsoft Related AllOther
  2. Suggest New Category

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.

Question Posted / indianhunk

Answers were Sorted based on User's Feedback



Perform the following tasks using MS-EXCEL: FUEL ESTIMATES COMPUTATIONS: This project is to compute..

Answer / 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

Perform the following tasks using MS-EXCEL: FUEL ESTIMATES COMPUTATIONS: This project is to compute..

Answer / sunny kumar

I would like to know the answer, please send me answer this
question.

Is This Answer Correct ?    6 Yes 2 No

Perform the following tasks using MS-EXCEL: FUEL ESTIMATES COMPUTATIONS: This project is to compute..

Answer / k.ganesan

I would like to know the answer

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More Microsoft Related AllOther Interview Questions

Enumerate the high level of the <bindings> and <binding> element.

0 Answers  

What is Unallocated Space ?

0 Answers   Baidu, CMS,

wt r the tools of remote function which is the best one

0 Answers  

DOTNET -> WPF what is Freezable?

1 Answers  

Axapta interview in wipro: join types? delete actions? posting for sales order what class used? write method? insert ,update methods? diff between inner join and exist join? diff between doupdate and update method? ,, ,, validate write and validate field method?

0 Answers   Wipro,

How to remotely administer ms iis?

0 Answers  

What is difference between microsoft and windows?

0 Answers  

What is XT (eXtended Technology)

0 Answers   Baidu, CMS,

What was the first microsoft product?

0 Answers  

How to generate sequence diagrams in visual studio?

0 Answers  

How do I get the microsoft edge icon on my desktop?

0 Answers  

i face a big prob in ms outlook 2k3 when i send a mail to others person but when go to sent itms there not show cc & To format whats prob how to trouble it?Plz reply hurry

4 Answers  

For more Microsoft Related AllOther Interview Questions Click Here
Categories