Excel BI Analytics

Excel Quiz 54

Posted on by Vijay A. Verma

Quiz 54 - Dynamic Arrays

This is a quiz to test your knowledge on Dynamic Array functionality of Excel 365. 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

What does following function do?

=RANDARRAY(10,,1,99,TRUE)

2 / 10

Which function would you use to generate an unique list?

3 / 10

Which function can be used to populate random numbers in a grid?

4 / 10

What is the symbol for implicit operator?

5 / 10

Which function can be used to filter records?

6 / 10

What does following formula do?

=SORTBY(A2:A7, LEN(A2:A7))

7 / 10

What is the answer for following referring to below picture (here A1:A10 is spilled range)?

=@A1:A10

8 / 10

What is the new Error type introduced by Dynamic Array?

9 / 10

Dynamic Array formulas need not be entered with CONTROL+SHIFT+ENTER?

10 / 10

In below FILTER expression, which logical condition has been used?

=FILTER(A1:D20,(A1:A20="a")+(C1:C20=3))

Your score is

LinkedIn Facebook Twitter

Exit

2 thoughts on “Excel Quiz 54”

  1. Hello there I am so thrilled I found your blog, I really found you by mistake, while I was looking on Bing for something else, Anyhow I am here now and would just like to say thanks a lot for a incredible post and a all round exciting blog (I also love the theme/design), I don’t have time to browse it all at the moment but I have book-marked it and also added in your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the excellent job.

    Reply

Leave a Reply

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