Priya Dogra – Certification | Jobs | Internships
Related Articles
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
