Excel BI Analytics

Excel Quiz 40

Posted on by Vijay A. Verma

Quiz 40

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

In the below formula, what is Revenue

=SUM(Revenue)

2 / 10

SHIFT+F11 is shortcut key for what?

3 / 10

What is the name of this chart?

1

4 / 10

To generate whole random numbers, which function can be used

5 / 10

Which of the following is 7-Aug-45 in Excel?

6 / 10

What is the example of Long Date in Excel date formatting?

7 / 10

Which feature of Excel recognizes the pattern and fills in the entries below?

8 / 10

What is the answer for following formula

=MAX(56,MIN(SUM(A1:D1),100))

1

9 / 10

Which of the following is not a valid worksheet function?

10 / 10

To copy only format from one cell to another, you can use

Your score is

LinkedIn Facebook Twitter

Exit

1 thought on “Excel Quiz 40”

  1. Question 6: I think you have concept of flash fill and autofill reversed. My impression is flash fill fills in the remainder of text in a cell. Autofill fills the items in the column below the last cell. The only reason why I think this is that you use the word "below" which to me indicates that you are referring to the cells below the active cell.

    Reply

Leave a Reply

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