Question: 1. Create a plvot table in this worksheet using the data supplied below that shows for each Format the number of movies and the average

the average running time. ( 3 marks) 2. Remove the Computer format

from the table. (1 mark) 3. Add a filter to show results

for only Horror movies. (2 marks) File Home Insert Page Layout formulas

1. Create a plvot table in this worksheet using the data supplied below that shows for each Format the number of movies and the average running time. ( 3 marks) 2. Remove the Computer format from the table. (1 mark) 3. Add a filter to show results for only Horror movies. (2 marks) File Home Insert Page Layout formulas Data Review View Automate Help (1) PRoTECItD view secoreful-files from the internct can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing File Home Insert Page Layout Formulas Data Review View Automate Help PROTECIEO VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View, Enable Editing A1 Assignment \#1 (Excel, Part 2) 1. Create a plvot table in this worksheet using the data supplied below that shows for each Format the number of movies and the average running time. ( 3 marks) 2. Remove the Computer format from the table. (1 mark) 3. Add a filter to show results for only Horror movies. (2 marks) File Home Insert Page Layout formulas Data Review View Automate Help (1) PRoTECItD view secoreful-files from the internct can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing File Home Insert Page Layout Formulas Data Review View Automate Help PROTECIEO VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View, Enable Editing A1 Assignment \#1 (Excel, Part 2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

City of Somerville, MA: Transaction Analysis (Financial Accounting) Learning objectives Create a pivot table in Excel Format a pivot table Apply filters to a pivot table Create sum, count, and...

Use data in worksheet named Q1-4 to answer questions 1 4. Assume the sample data was published in a business magazine. 1) Which of the following is true about the data? A. Class is qualitative and...

15. Hwan needs to identify the location of each project. Add a slicer to the PivotTable as follows: a. Add a slicer based on the State field. b. Move and resize the slicer so it covers the range...

You have been asked by the Sales Manager to do analysis for a company that sells three products (JT1252, NX900, RJ52) in four regions (North, South, East, and West). The data you have been given is...

1 Use data in Worksheet Q1-9 to answer questions 1 to 9. The data is for a sample of dealerships and was collected for the second week of August 2016. Which variables are qualitative? A. New Car...

our supervisor met with Mr. Z and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project. Document process activity using BPMN. After...

Management Information System- need help with step 6 and 7 For this assignment each team is required to create a fictitious stock portfolio by investing a total of $100,000 (paper money, of course! -...

Describe what types of delivery systems for music you think we will see in the future, and how we will listen and store our music.

Nonstandard Definitions: In Problems 1-2 we explore the possibility of defining a new vector space whose vectors are the familiar pairs (x, y) of real numbers but for which different operations are...

The market for loans or borrowed money is called the

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...