Excel BI Analytics

Excel Quiz 13

Posted on by Vijay A. Verma

Quiz 13

This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly.

Please fill in your Name & Email to take the Quiz

(Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass)

1 / 10

11

The answer to =VLOOKUP("R",$A$1:$B$10,2,0) will be

2 / 10

A2 = -56
If A2 = --A1, what is the value in A1?

3 / 10

What would be the answer for =TRUNC(46.78905,1)

4 / 10

What would be the answer for =SIGN(-45)

5 / 10

What is the answer for following formula -
=ROUNDUP(4567.703,1)

6 / 10

What would be the answer for =MOD(-74,13)

7 / 10

What would be the answer for =EVEN(45.77)

8 / 10

What is the maximum precision of number in Excel?

9 / 10

The short cut to open Pivot Table Wizard is

10 / 10

What would be the answer for =CEILING(1401,50)

Your score is

LinkedIn Facebook Twitter

Exit

5 thoughts on “Excel Quiz 13”

  2. Hi. Question 9 – Shouldn't the answer be A127 and note E? The formula =VLOOKUP("A127",$A$1:$B$8,1,0), the 1 is referring to Column 1 which is Column A since the range has columns A & B and B being column 2? If you wanted the letter as an answer then replace 1 with 2. Correct me if I am wrong!

    Reply

Leave a Reply

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