Home › Quizzes › Excel Functions Practice

Excel Functions Practice

Practice questions on Excel functions including financial, text, and data manipulation functions.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

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?

  1. INPER function
  2. B. PMT function
  3. C. FV function
  4. D. VDB function
  5. Both 2 and 3
Question 2 Multiple Choice (Single Answer)

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?

  1. ASIN function
  2. ABS function
  3. ATAN function
  4. ASINH function
  5. None of the above
Question 3 Multiple Choice (Single Answer)

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?

  1. DDB function
  2. DB function
  3. DISC function
  4. DGET function
  5. None of the above
Question 4 Multiple Choice (Single Answer)

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?

  1. ACCRINT function
  2. AMORLINC function
  3. ATAN function
  4. ACCRINTM function
  5. None of the above
Question 5 Multiple Choice (Single Answer)

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?

  1. ACCRINTM and DATE function
  2. ACCRINT function
  3. AMORLINC function
  4. ACCRINT and DATE function
  5. None of the above
Question 6 Multiple Choice (Single Answer)

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?

  1. AMORLINC function
  2. DURATION function
  3. AMORDEGRC function
  4. ABS function
  5. None of the above
Question 7 Multiple Choice (Single Answer)

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?

  1. CODE function
  2. EXACT function
  3. TEXT function
  4. CHAR function
  5. Both 1 and 2
Question 8 Multiple Choice (Single Answer)

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?

  1. DB function
  2. B. DISC function
  3. C. DDB function
  4. DGET function
  5. All of the above
Question 9 Multiple Choice (Single Answer)

Which shortcut key is used for the hyperlink function in Excel?

  1. CTRL+ K
  2. CTRL+T
  3. CTRL+ B
  4. CTRL + ALT + SHIFT + TAB
  5. CTRL + ALT + TAB
Question 10 Multiple Choice (Single Answer)

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?

  1. JIS function
  2. CODE function
  3. KURT function
  4. MATCH function
  5. MISMATCH function
Question 11 Multiple Choice (Single Answer)

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?

  1. MID(A2,5,7)
  2. MID(A2,1,7)
  3. MID(A2:A30,6,14)
  4. MID(A2,6,12)
  5. MOD(A2,6,20)
Question 12 Multiple Choice (Single Answer)

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.

  1. 0
  2. FALSE
  3. 50%
  4. 10%
  5. 1
Question 13 Multiple Choice (Single Answer)

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?

  1. HLOOKUP function
  2. VLOOKUP function
  3. GETPIVOTDATA function
  4. GET function
  5. GOT function
Question 14 Multiple Choice (Single Answer)

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?

  1. TRANSPOSE function
  2. TRIM function
  3. TYPE function
  4. VALUE function
  5. DATA function
Question 15 Multiple Choice (Single Answer)

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?

  1. BHATTEXT function
  2. CHAR function
  3. PROPER function
  4. DOLLAR function
  5. None of the above
← Back to Quizzes