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. 

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

Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?

Which among the following settings is the default macro security setting

Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?

What is the purpose of time stamping a digital signature in Microsoft Excel 2010?

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

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

Cell C3 contains a value 100, what formulla you will use to make it 10% smaller in Cell C1

You can undo several recent actions at once.

Which worksheet function extracts from a database a single record that matches the specified criteria?