The source range for a Pivot table may not contain:

The definition of the array formula {=SUM((C90:C93)*(D90:D93))} is:

What function is NOT considered a Math & Trig function?

In the formula '=VLOOKUP(A3,$J$3:$K$12,2,TRUE)', the 4th argument of the VLOOKUP function, 'TRUE', indicates

What formula permits the use of multiple lookup criteria?

You want to pick a winner from a set of names in A:6 to A:34. Which methodology will allow you to perform this?

In Excel 2016, which function returns an aggregated value from the cube?

Consolidate Option is available under which of the following tabs?

In Microsoft Excel 2016, which of the following Engineering functions tests the equality Of two numbers?

Data sorting in columns can be performed on which Of the given Options? 1. Values 2. Cell Color 3. Font Color 4. Cell icon

Which of the given types Of pivot charts can be used in Microsoft Excel 2016? 1. Pie chart 2. Waterfall chart 3. Treemap chart