Open a blank Excel workbook and bring in the FactSales data from the ContosoSales Access database as
Question:
Open a blank Excel workbook and bring in the FactSales data from the ContosoSales Access database as follows. Select DATA > Get External Data > From Access. Browse to the ContosoSales Access database. When the Select Table box appears, select the FactSales table and click OK. When the Import Data box appears, select PivotTable Report and click OK.
a. Create a PivotTable report with the ChannelKey field as the rows and SalesAmount field as the values. Change the number format of the SalesAmount field to currency and rename the column to Total Sales.
b. Insert a bar pivot chart and change the name of the chart to Total Sales by Channel.
c. Insert a slicer to allow selection of one or more ChannelKey. Change the slicer style to Light 2 and change the number of columns in the slicer to 2.
Step by Step Answer:
Accounting Information Systems
ISBN: 978-1260153156
2nd edition
Authors: Vernon Richardson, Chengyee Chang, Rod Smith