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 ___ is similar to a data bar in that it compares the relative values of cells in a range. Instead of bars in each cell, you see cell shading, where the shading color reflects the cell’s value?

A worksheet range is as following?

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?