You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?  

Excel can publish a workbook to the server only in ________ or ________ format.

Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?

Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true?

Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members to be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?

State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).

Which worksheet function returns the average of its arguments, including numbers, text, and logical values?

Which Function should be used to count all the cells which are not empty?

What is the function to display only the current date?

The formula EXACT('Fish''fish') returns:

To share your workbook with another user, what must they have?