Wednesday , February 21 2024
Breaking News

Microsoft Advance Excel Free Certificate | Advance Excel Practice Question and Answers | Advance Excel MCQ Quiz Answers

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

Apply now

About Clear My Certification

Check Also

lakhpati didi yojana

Lakhpati Didi Yojana Scheme- Eligibility , Benefits , How to Apply Online ?

All of us know that a new government was formed in Rajasthan, and many schemes …

Leave a Reply

Your email address will not be published. Required fields are marked *