The default calculation in a PivotTable Report is to the num

The default calculation in a PivotTable Report is to the numeric data. Average subtract count sum If you change the underlying data on which a PivotTable report is based, you must also or update the PivotTable to reflect the new data. List reopen save refresh A Microsoft database stores data in rows and columns. In the PivotTable field section, you can rearrange existing fields by using which of the following areas in the layout section? ROWS Areas ROWS Values

Solution

Answer :

Q6)The default calculation in a PivotTable report is to ----------the numeric data.

Average

Subtract

Count

Sum

Answer :

The default calculation in a pivot table reports is to SUM the numeric data

.............................................................................................

Q7)If you change the underlying data on which a pivot tables report is based,you must also ......................or update the PivotTable to reflect the new data

        list

       reopen

       save

      refresh

Answer :

refresh

If you change the underlying data on which a pivot tables report is based,you must also refresh or update the PivotTable to reflect the new data.

....................................................................................................

A Microsoft..................database stores data in rows and columns

Answer :

SQL Server

A Microsoft SQL Server database stores data in rows and columns

..............