Excel keeps the changed history of a workbook for ________ days by default

Which of the following sorting options is NOT available under the Sort On option while sorting the data of a table in an Microsoft Excel 2010 worksheet?

Which of the following statements is NOT true regarding import of data into PowerPivot?

How would you assign a macro to a graphic?

Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value, lookup_vector, result_vector) Which of the following arguments of the LOOKUP function is optional?

You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?

The difference between the COUNT function and the COUNTA function is:

How can you shift a cell's value into the center of a group of cells, without merging it?

What does COUNTA () function do?

What Tab do you use to create a background Graphic?

Where does the 'Track Changes' feature highlight changes?