Computer Applications
Description: practice questions on Excel. | |
Number of Questions: 15 | |
Created by: Neema Pandya | |
Tags: computer Data Structure |
In the above security, payment made in each period is 100, and the present value and future value is 1000 and 10000 respectively. How can we calculate the period of investments?
A number has been entered into a cell of Excel sheet. The hyperbolic sine of the number has to be inversed. Which of the following should be used?
A security is issued on 1st March 2010, its first interest date is 31st August 2010 with a coupon rate of 10% and par value of 1000 rupees. Settlement date for security is 1st May 2010 with 30/360 basis value.If the initial cost of the asset value is changed to 5,00,000 with the lifetime of 10 years, which function can be used to calculate the depreciation in the first year with fixed decimal places?
A company purchased an asset at a cost of 2400 on 18/9/2012. The end of the first period of the asset is on 31/12/2012. The salvage value for the asset is 500 and the depreciation on the asset is 20%. Which function can be used to calculate the first period depreciation?
A security is issued on 1st March 2010, its first interest date is 31st August 2010 with a coupon rate of 10% and par value of 1000 rupees. Settlement date for security is 1st May 2010 with 30/360 basis value. Which function can be used to calculate the accrued interest for the security with the expected issue date, 5th March 2010?
A company purchased an asset at a cost of 2400 on 18/9/2012. The end of the first period of the asset is on 31/12/2012. The salvage value for the asset is 500 and the depreciation on the asset is 20%. Which function can be used to calculate the depreciation for each accounting period?
A client has shared its employee data to get the valuation done from ABC consulting company. Client has sent the raw data with the password in some codes. Which function can be used to convert the codes in the character?
A company has purchased an asset at a cost of 2400 on 18/9/2012. The end of first period of the asset is 31/12/2012. The salvage value for the asset is 500 and the depreciation on the asset is 20%. Which function can be used, if the results are needed in the flexible or floating decimals places?
Which shortcut key is used for the hyperlink function in Excel?
A client has shared its employee data to get the valuation done from ABC consulting company. ABC consultancy wants to send its liability calculation back to the client. The consultancy wants that the calculation should be password protected. Instead of using the write function, the consultancy by mistake converts the code in the specified language of the system. Which function is exactly used in this scenario?
A company provides its 20-digit alphanumeric raw data combining the employee ID of 5 characters and PF number of 7 digits and remaining digits as 0,0 in cell number A2. Which of the following functions can be used to extract the PF number for each employee?
year interest 2001 10% 2002 FALSE 2003 30% 2004 40% 2005 50% In the above provided data, if the MINA function is used, find the value obtained by the function.
A company while sending its data to consultancy, sent the salary in one file and rest of the information in other file. Which function can be used to make a consolidated data with salary and rest of the information?
Mr. A, while filling the form in excel, by mistake hits the space key several times and then fills the name in the name column. Which function can be used to remove the spaces from the cell?
A company named ABC limited is a Thai company, the global dealer for the company is in India. Now dealer has made an invoice for the company, but somehow the dealer missed to convert the numbers in Thai language. Which function can be used to convert the numbers in Thai?