Excel BI Analytics

Excel Quiz 38

Posted on by Vijay A. Verma

Quiz 38

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

If A1=18-Aug-16, what would be the result of following

=TEXT(A1,"mmmm")

2 / 10

The minimum number of rows which a worksheet can contain

3 / 10

ALT+T+O is the shortcut for

4 / 10

Which of the following is a new function introduced in Excel 2016?

5 / 10

Which functionality can be used to summarize data from various ranges into a single output?

6 / 10

The default column width in Excel is

7 / 10

Which functionality within Conditional Formatting can generate the below

1

8 / 10

What does the following formula do -

=SUMPRODUCT((ROW(1:100)))

9 / 10

Below is one of the properties of Active Cell -

10 / 10

Which Excel functionality can be used to generate red zone in below picture

1

Your score is

LinkedIn Facebook Twitter

Exit

1 thought on “Excel Quiz 38”

  1. Question 2 has two red zones, although one is of a lighter red. Which item do you want the test participant to consider?
    Question 5: You don't say if the workbook is blank or not, but I assume the workbook is blank and the formula is not entered in any of the rows 1 to 100. When I entered the formula as =SUMPRODUCT((ROW(2:101))) (No values in rows 2:101) the answer is 5150.

    Reply

Leave a Reply

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