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?

Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?

Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value, lookup_vector, result_vector) The values in the lookup_vector must be placed in ________ order.

State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false. An Absolute cell reference consists of the column letter and row number.

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

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

True or False: The print area cannot be set to discontinuous ranges.

What does the 1 represent in this formula: =Now()+1

Which feature allows you to display multiple copies of your worksheet in side-by-side windows?