Check your knowledge

1.

What is the highest endorsement type that can be applied to a dataset?

Promoted

Supported

Verified

Certified

2.

What formula can be used to reduce the scope of a table?

CUBEMEMBER()

FILTER()

XLOOKUP()

CUBEVALUE()

3.

What Office 365/Excel 2016 function can be used to look up a value in rows and columns, horizontally and vertically?

INDEX()

VLOOKUP()

XLOOKUP()

FILTER()

Answer the following questions to see what you've learned.