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!
Join my Whatsapp Group
Also Checkout :
Google I/O 2021 Program | Free Google Workshops | Earn Google Developer Badge
AICTE Opens 2,500 Virtual Internships for Everyone
Microsoft Free Cyber Security Course with Certification
Coursera Free Premium Courses | Intel | Google Cloud | AWS Free Courses with Certifications
Here are the Microsoft Advance Excel quiz questions and answers :
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
CMSB (Council for Media and Satellite Broadcasting )Government Certificate