Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help me know the step by steps more clearly and how to apply them 1 Start Excel. Download and open the file named Excel _

Help me know the step by steps more clearly and how to apply them 1 Start Excel. Download and open the file named Excel_Ch06_Assessment_VideoGameSales.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 The data on the VideoGameSales worksheet includes sales (in millions) for several video games on various platforms and from various genres. On the VideoGameSales worksheet, insert a table with headers using the data. 4
3 Apply the Light Blue, Table Style Medium 27 to the table and with the table selected, including the headers, create a SalesDatabase named range to be used in database functions later. 5
4 Add a Total Row to the table to have the sales values in the NorthAmerica, Europe, Japan, Other, and GlobalSales columns summed. 5
5 Slicers are an easy way to explore data in a table.
Insert slicers for Platform, Year, and Genre. 5
6 Move the Platform slicer so that its top-left corner is just inside the border of cell K1. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer. 2
7 Move the Genre slicer so that its top-left corner is just inside cell N1. Modify its Layout property so that it has 2 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer. 2
8 Move the Year slicer so that its top-left corner is inside cell K13. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Modify the setting so that the caption reads Release Year. Apply the White, Slicer Style Other 2 style to the slicer. 2
9 Using the slicers, filter the Table to only show records where the Platform is PS3 and DS and the Genre is either Adventure or Action. Select the filtered data, including column headings and the Total row, and paste the data on the SelectData worksheet, starting in cell A1. Adjust the column widths as necessary so that all data are visible. 6
10 Clear the filters applied to the VideoGameSales data. Copy the headings and paste them onto the DatabaseTotals worksheet, starting in cell A1 to begin to setup and create database functions to further analyze the data. If necessary, adjust the column widths so that all data are visible. 5
11 Complete the DatabaseTotals worksheet using the appropriate database functions using the SalesDatabase named range, use GlobalSales as the field in your calculations, and only calculate games that meet the following criteria:
In row 2, specify the criteria for games on the Wii platform with a release year of newer than 2006
In row 3, specify the criteria for games on the DS platform in the Adventure genre. 20
12 Using the data on the VideoGameSales worksheet, create a PivotTable on a new worksheet and rename the worksheet, PivotAnalysis. Do not add the data to the Data Model. Be sure the Report Layout is in Compact Form. 5
13 Structure the PivotTable on the PivotAnalysis worksheet according to the following:
Filters: Publisher
Rows: Platform and Year
Columns: Genre
Values: Sum of GlobalSales
6
14 Configure the PivotTable on the PivotAnalysis worksheet according to the following:
Create a custom name for Sum of GlobalSales to be Total GlobalSales (in millions)
Format Total GlobalSales as Accounting with 2 decimal places
Change Row Labels in cell A4 to Platform and Year
Change Column Labels in cell B3 to Genre
Apply Light Blue, Pivot Style Light 9
Adjust the column widths, if necessary. 6
15 Using the data on the VideoGameSales worksheet, insert a PivotChart on a new worksheet. Rename the worksheet with the PivotChart and PivotTable, NorthAmericanSalesByPlatform. 5
16 Structure the PivotChart on the NorthAmericanSalesByPlatform worksheet according to the following:
Filters: Genre
Axis (Categories): Platform
Values: Sum of NorthAmerica 6
17 Configure the PivotChart on the NorthAmericanSalesByPlatform worksheet according to the following:
Change the Chart Type to Clustered Bar.
Apply a Style 4 Chart Style
Apply a Layout 1 Quick Layout
Edit the chart title to North American Sales by Platform
Delete the Legend
Move the PivotChart to a new worksheet with the name SalesByPlatformPivotChart 6
18 Using the PivotTable on the NorthAmericanSalesByPlatform worksheet, create a drill-down of the DS sales and rename the worksheet created NorthAmericanSalesDS. 5
19 Using the PivotChart on the SalesByPlatformPivotChart worksheet, modify the Genre filter to only show data for Action, Adventure, and Fighting genres.
If using a Mac, use the PivotTable filter on the NorthAmericanSalesByPlatform worksheet (the source of the PivotChart) to apply the filters. 5
20 Save and close Excel_Ch06_Assessment_VideoGameSales.xlsx. Exit Excel. Submit the file as directed. 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Structured Search For Big Data From Keywords To Key-objects

Authors: Mikhail Gilula

1st Edition

012804652X, 9780128046524

More Books

Students also viewed these Databases questions

Question

Write a short reflective piece on research ethics.

Answered: 1 week ago

Question

a. Did you express your anger verbally? Physically?

Answered: 1 week ago