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?

What are Information Functions in Excel?

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?

Which of the Following is an Evolutionary Solving Method Option in Solver?

The shortcut for transpose is

Which worksheet function returns the inverse of the Student's t-distribution?