Monday , June 17 2024
Breaking News

This Excel Test is designed to help you assess your knowledge of basic Excel functions and formulas. This is also a useful resource for employers to examine the technical Excel knowledge of the candidates during a finance interview or for applicants who want an Excel practice test. If you pass this test with 80% or above (16 questions or more), it is likely that you have pretty solid fundamental knowledge of Excel!

Also Checkout:

1) Statistical calculations and preparation of tables and graphs can be done using: Excel

2) Which function returns the current date?: NOW

3) Which function is used to return the number of cells in a range that meet a condition set forth in the formula?: CountIF

4) What function will result in the total number of entries in the cell range B5 to B14: Count

5) What type of chart is useful for comparing values over categories?: Column Chart

6) The Software which contains rows and columns is called __: Spreadsheet

7) What is the keyboard shortcut key to lock cell references in a formula?: F4

8) What are the shortcut keys for AutoSum?: ALT and =

9) Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?
=IF(B2>=\$E\$2,”Accept”,”Reject”)

10) Assuming cell A1 is displaying the number “12000.7789”. What formula should be used to round this number to the closest integer?: =ROUND(A1,0)

11) What are the keyboard shortcut keys to edit formula in a cell?: F2

12) What is the best practice for financial modeling in excel?: Use blue font for hard-coded numbers and black font for formulas

13) The shortcut keys to increase the number of decimal places are: ALT+H+0

14) Which of the following is not a valid MS-Excel function?: Calculation

15) Which of the following is oldest spreadsheet package?: VisiCalc

16) Which menu option can be used to split the worksheet in MS-Excel?: Window > split

17) The minimum and maximum zoom in MS-Excel XP?: 25, 200

18) Which of the following is not a type of cell referencing in MS-Excel?: Trigonometric

19) The text and numeric information in MS-Excel is also called?: Constant value

20) Which menu can be used to turn on or turn off the formula and status bar?: View Menu