While creating a PivotTable in Excel 2016, where can a user place the PivotTable report? It is always placed in a new worksheet. It is always placed in an existing worksheet. It can either be placed in a new worksheet or in an existing worksheet. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?

Which of the following functions checks whether all the arguments are TRUE, and returns TRUE if all the arguments are TRUE?

In relation to building out the PivotTable, which of the following fields are added to the COLUMNS area?

What formula would you use to find and replace the second occurrence of a hyphen with a colon for the cells in column A:

An Excel workbook is a collection of ?

Which of the following are advantages of range names?

A sales worksheet shows all sales for the year. Customer name in column A, sale status in column B and sale value in Column C. What value will the formula '=SumProduct(--(B3:B70='pending'))' return?

Which menu option can be used to split a window?

To print a page number on the bottom of every printed page:

Which of the following is not a style of conditional formatting for value based rule for cells?

Which Solver Solving Method will solve non-smooth problems?