In Microsoft Excel 2016, data sorting in columns can be performed on which Of the given Options?

1. Values

2. Cell Color

3. Font Color

4. Cell icon

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

Consolidate Option is available under which of the following tabs?

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

Can we change the default font size of a new workbook in Excel 2016 from the Backstage view?

Which of the given statements are correct about the slicers in Microsoft Excel 2016? 1. They can be used to filter data in a table. 2. They can be used to f‌ilter data in a PivotTable. 3. They can only be connected to PivotTables that share the same data source.

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?

What formula permits the use of multiple lookup criteria?

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

What function is NOT considered a Math & Trig function?

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