*Excel Dynamic Array functions F*
Quiz Summary
0 of 10 questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Dynamic Array Formulas 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 10
1. Question
Combine tasks with appropriate function:
Sort elements
- XLOOKUP
- SUMIFS
- SUBTOTAL
- FILTER
-
Combine data from multiple sources
-
Aggregate values based on conditions
-
Aggregate values based on filters applied
-
Return multiple rows of data based on condition
CorrectIncorrect -
Question 2 of 10
2. Question
Can you use modern array functions as a source for data validation list, like in a picture below?
CorrectIncorrect -
Question 3 of 10
3. Question
How can we show a result of an array function in a data validation list?
CorrectIncorrect -
Question 4 of 10
4. Question
Which symbol do we need to use after referencing cell containing array formula to active its #SPILL feature?
CorrectIncorrect -
Question 5 of 10
5. Question
We wish to create a list of unique brands from Table1 sorted in ascending order.
Which function/functions are correct?
CorrectIncorrect -
Question 6 of 10
6. Question
Using the Excel file you can download here, answer the following question.
You wish to use the SORT function to sort the whole table by Brand column in descending order.
Which formula should you use?
CorrectIncorrect -
Question 7 of 10
7. Question
Using the Excel file you can download here, answer the following question.
You wish to use the SORT function to sort the whole table first by column Description eng, then by SalesValue€. Both columns need to be sorted in descending order.
Write the formula using table reference.
CorrectIncorrect -
Question 8 of 10
8. Question
Using the Excel file you can download here, answer the following question.
You wish to add a FILTER formula that will dynamically show all table rows with a date specified in cell M3.
Write the formula using table reference.
CorrectIncorrect -
Question 9 of 10
9. Question
Using the Excel file you can download here, answer the following question.
You wish to add a FILTER formula that will dynamically show all table rows with a date specified in cell M3, and category specified in cell M2.
Write the correct formula using table reference (all relative refences).
CorrectIncorrect -
Question 10 of 10
10. Question
What are the advantages of using modern Array formulas?
CorrectIncorrect
