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 10506Post New Excel Microsoft Related AllOther Interview Questions
- Excel C Interview Questions (12)
- Excel OOPS Interview Questions (1)
- Excel COM DCOM Interview Questions (1)
- Excel Networking Security Interview Questions (4)
- Excel Networking AllOther Interview Questions (2)
- Excel C Sharp Interview Questions (2)
- Excel ASP.NET Interview Questions (1)
- Excel Dot Net Framework Interview Questions (4)
- Excel Dot Net Remoting Interview Questions (2) Excel Microsoft Related AllOther Interview Questions (1)
- Excel Oracle General Interview Questions (1)
- Excel SQL Server Interview Questions (1)
- Excel Unix AllOther Interview Questions (2)
- Excel QTP Interview Questions (2)
- Excel Test Documents Reporting Interview Questions (1)
- Excel EJB Interview Questions (6)
- Excel HR Questions Interview Questions (2)
- Excel Botany Interview Questions (1)
- Excel Chemical Engineering Interview Questions (1)
- Excel Engineering AllOther Interview Questions (1)
- Excel Banking Finance Interview Questions (2)
- Excel Accounting AllOther Interview Questions (1)
- Excel Call Centre AllOther Interview Questions (4)
- Excel General Knowledge_Current Affairs Interview Questions (3)
- Excel Placement Papers Interview Questions (1)
- Excel C Code Interview Questions (1)
What is the use of Strftime function?
Tell me can include files be nested?
Explain the difference between a list and the tuple?
What is the difference between a standard controller and a custom controller? : salesforce crm
Does avg work on linux?
what is a unique key ? : Sql dba
how do you reference the variable unblock file formats from cobol programs
What is MRO area & MRP group & some difference
What are the prerequisites in order to customize a document in sap?
Explain the operation reduce() in Spark?
Does spring boot use tomcat?
What is transport network substrate (tns) in oracle?
How can we add an event handler for a ASP.NET function executed on MouseOver for a certain button.
What is system level testing?
I have an excel sheet with multiple ID's in a column. Now i need fetch those ID's in an application and check whether if it already exist in the DB. If not then i have to go with the process of inserting them in the DB. If it exists then i need to skip that ID and move to the next ID and check the same and proceed. How can i do that with for loop and if condition?
