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
- 12795 Views
- Excel, Ignou, San, Softweb, I also Faced
- E-Mail Answers
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
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 |
Answer / sunny kumar
I would like to know the answer, please send me answer this
question.
| Is This Answer Correct ? | 6 Yes | 2 No |
What is Unallocated Space ?
Explain why do we use option explicit?
How to recover a failed RAID-5 Controlled HDD
Enumerate three message exchange patterns in the WCF model
Why to use DNS? DIfference between differtial backup and Incremental backup with example ? what is difference between arp and rarp ? What is difference beteen windows 2003 and windows 2008 server? What is diff betwen exchange server 2003 and exchange server 2007? Which protocol work behind active directory?
1 Answers Baidu, Precision, Titan,
What is the functionallity difference between radio/option buttons and a drop-down list box besides appearence? i.e. When it is better to use one instead of the other?
Can I delete microsoft onedrive?
How to use script on Domain ?
What is an example of a microsoft account?
Is microsoft visio viewer free?
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?
Why do we need xaml? : xaml
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
