You will analyze data from a fictional survey that asked 100 people about their favourite gourmet pizza
place in Winnipeg.
- Open the file Assignment 3 Starting File Part A.xlsx and save it as
Firstname Lastname Pizza.xlsx
- Review the document contents.
- In cell B3 of the Documentation sheet, type the date you started working on the assignment.
- In cell B4, type your Firstname Lastname. (Minimum one mark deduction per cell if not done.)
- Switch to the Results sheet.
- Freeze Panes so that you can still see the first three rows when you scroll to the bottom of the list.
- Convert the data on the Results sheet to an Excel table.
- Select a table style of your choice that is not the default.
- Name the table: FirstName_Results
- Adjust column width to match the screenshot. Note how table headers are wrapped.
You realize that one response was forgotten when the workbook was first created.
- Add the following record to the bottom of the table: Respondent ID 244 of St. James spent $65 at Pizza 21st Century.
- Use the Remove Duplicates tool to delete any duplicate records from the table. HINT: After
completing this task, 101 unique records should remain.
- Sort the data by Respondent's Part of the City (A to Z), then by Favourite Gourmet Pizza Place (A to Z),
then Amount Spent in Past Month (Largest to Smallest).
- Make a copy of the Results sheet, place it at the end of the workbook, and name it Filter.
- Use 2 Slicers to filter the records to show only respondents who live in East Kildonan or River Heights, who prefer Pizza 21st Century. Apply a slicer style of your choice to each.
- Next, use the filter arrow to further filter the results to display only those who spent $30 or more. Required: a number filter must be used.
- Use the Total Row tool to display both the number of respondents who meet these criteria as well as the total amount spent.
-Adjust functions and labels as required to match the screenshot .
You would like to use the Subtotal tool to summarize your data by Favourite Gourmet Pizza Place.
- First, copy the Results sheet, rename the copy Subtotals, and place the new sheet at the end of the workbook.
- Use the Subtotal tool to find total Amount Spent, broken down by Favourite Gourmet Pizza Place. Use the screenshot as a guide to help you, and remember that you must complete two preliminary
steps before you use the Subtotal command!)
- Display Level 2: all the Subtotals and the Grand Total.
- Resize the columns as needed to ensure no information is cut off.
- Using the data on the Results sheet, create a PivotTable to show average of Amount Spent by Favourite Gourmet Pizza Place.
- Place the PivotTable on a new sheet named Average. Move this sheet to the end of the workbook.
- Use the screenshot to help you set up your PivotTable.
- Complete all formatting to match the screenshot.
- Create a PivotChart (type 3-D Pie) which is based on the PivotTable that you created in the previous step.
- Size and position the chart on the same sheet, as shown in the screenshot.
- Remove the chart title.
- Apply Chart Style 3.
- Modify chart labels to match the screenshot.
- Delete the legend.
- Explode the piece of pie representing the largest %.
- IMPORTANT Final check: all formatting, spelling, other errors. Ensure column width and row height allows for all information to be properly displayed.
- This process should happen every time you create a finished product.
- Carefully check your work, referring frequently to the screenshots and instructions.
- While no marks are given for this requirement, as much as 10% of the overall mark may be deducted.
- Go to the Documentation sheet, and click in cell A1. Save and close your file.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
