Home Certification Microsoft Advance Excel Free Certificate | Advance Excel Practice Question and Answers...

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

microsoft advance excel free certificate

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?

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


Please enter your comment!
Please enter your name here