Fiver Test

  01. John inserts a PivotTable in a worksheet, as shown in figure 1 of the given image. There are three columns in the data source: Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 2 of the given image. Where should he double-click on the PivotChart in figure 1, so that he should be able to select the Product column? On the header of the Employee column. On the values of the Sum of Sales column.  On the values of the Employee column.   On the header of the Sum of Sales column. 02. In Excel 2016, the & Reference Option is available under which Of the following tabs? Insert Page Layout Formulas  Review 03. In Microsoft Excel 2016, what does the VALUE function do? It is used for converting a text argument to a number.  It counts the cells that contain numbers in an Excel sheet. It is used for adding numeric values. It is used for calculating the ASCII values of a text string. 04. In Micro...