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?

Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?

Where does the 'Track Changes' feature highlight changes?

You're separating a column of full names into a column of first names and a column of last names. Excel should treat the column as what type of data?

The quickest ways to save as:

If you want to make a text box transparent, you should:

What is the main difference between a Sumif equation and a Sumifs equation?