The formula EXACT("Fish","fish") returns:

What is the function to display only the current date?

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

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

Which worksheet function returns a value along a linear trend?

When using a Lookup to extract data, what is the meaning of the true/false argument?

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?

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

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

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?

Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?