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.

Answers were Sorted based on User's Feedback

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

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

question.

 Is This Answer Correct ? 6 Yes 2 No

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

I would like to know the answer

 Is This Answer Correct ? 5 Yes 4 No

More Microsoft Related AllOther Interview Questions

What is UPS (Uninterruptible Power Supply)

what are the command utility 's using in fail over cluster?

What is Router ?

What is SDRAM (Synchronous Dynamic Random Access Memory) ?

How to restore deleted OU in DC ?

Hi, can anyone tell me what is the difference between SYSVOL and NTDS folder in AD? I know SYSVOL is for shared information between Domain controllers, but isn't AD database shared as well? Don't they use the same DB which is stored in NTDS folder? I know SYSVOL size is much smaller than NTDS', but what is it for? Does it contain a part of NTDS folder? If so, what namely? Thanks

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

What is Docking Station ?

What is Xeon Processor Technology?

What is the difference between Win2k Server and Win2k3?

What is Tunnel or Tunneling?

Categories