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

difference between windows 98, windows 2000 and windows XP

What authentication options do Windows 2000 Servers have for remote clients?

While server generating the patches . that time server pull or push the resources?

Diff.. between cursor and Reference Cursor?

What is Uninstall?

HOW TO DELETE THE SINGLE QUOTATION IN THE SOURSE TO LOAD THE DATA TO DESTINATION

what is stateless and statefull? why do we need to serialize an object?

How to synchronize two ms access files? I am using one Ms access file (access 2007 accdb file) in my system. the same file i have given it to another section for data entry. every day data entry is being done in that section and i am making reports in my access file. how do i synchronize both file because i need to update data entries from that system and update my new reports to that system. Plz help me how to do that? Network is not available between these systems and things can be done via storage devices only.

What is the maximum number of fields of data form, can be displayed in a worksheet of MS Excel Program? (a)16; (b)24; (c)32; (d)48.

In which scenario i can use stub zone and why if i have all information in my primary dns server?

What the difference between the request-response pattern and the duplex pattern?

What is USB (Universal Serial Bus) ?

Categories