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 12974Post New Softweb Microsoft Related AllOther Interview Questions
-
Softweb Microsoft Related AllOther Interview Questions (1)
Define standalone rowset?
What is the advantage of a random access file?
How do you prioritize ethical concerns when multiple conflicts arise?
What is Object Oriented model?
Where can I blog for free?
Why is mongodb used?
How do I update microsoft visual studio?
What can sensors measure?
What is pir planned independent requirement? : supply chain management
How to create a table in word 2016?
Define hash function?
What is Chain code?
What is a "pure virtual" member function?
SAP DEPRECIATION RUN ERROR: I have a problem with depreciation posting. I have searched the forum but did not find any answer. Net book value of $ 559,350 as on April 2012 was fully depreciated by 31 Mar 2017. Additions between April 2012 and March 2017 were correctly depreciated. However, additions from 01 Apr 2017 were fully depreciated when depreciation program was executed. For example, asset acquisition on 01 May 2017 $ 2400 was fully depreciated ($ 2400) which is not correct. It should be $ 2000*20%/12*11 = $ 440. Subsequently, in Jan 2018, on the acquisition of $ 207, the system has posted a positive depreciation of $ 47,469 on the base value of $ 1,640,423.72!!! More surprisingly, acquisition after that is correctly depreciated. For example, acquisition on Jan of $ 3,488.94 was correctly depreciated by $ 174.45 (3488.94*20%/12*3 months). Here are the details of the configuration of depreciation: · Depreciation method SLM · Base method 0014 · Useful life: 5 years (20% depreciation). · Period control 01/01/01/01 · Depreciation after the end of planned life – the box is “checked”. · There is only ordinary depreciation. · “Only negative values and zero allowed” checked in Rule for positive/negative sign for ordinary depreciation in Depreciation Area. · Fiscal year: April to March · SAP ECC 6.0 Can anybody suggest/help how to fix this?
How many normal and special peroids can be there in a fiscal year? What is the use of special periods?
