Cell A1 contains the string "tom jones". To transform the contents to "Tom Jones" the formula is:

Which worksheet function returns the k-th largest value in a data set?

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

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

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

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

Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?

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.

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.

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?

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