Question

Excel help?

Answer 1

In this assignment, you are going to add filtering to the spreadsheet you used in the previous assignment to answer the questions below.

Save this assignment document as Mobsters_2_Your_Name. Open the spreadsheet Mobster_1_Your_Name. Highlight cells A2:D165 and apply the Auto Filter command. Answer the following questions, using the filter commands. Remember to Select All after you answer each question, so all of the data is included in the next filter.

How many crimes were committed during the month of October?

How many crimes were committed during the month of June that were extortion?

How many crimes were committed that had a take of less than $60,000?

How many extortion crimes were committed by mobsters whose last name starts with B?

Answer 2

Working on it rn

Answer 3

I'm having trouble adding the auto filter lol

Answer 4

I'm having a hard time opening it with this slow WiFi, but I'll see what I can do once it opens... whenever that is.

Answer 5

alrighty

Answer 6

How many crimes were committed during the month of October?

12 crimes were committed during the month of October.

How many crimes were committed during the month of June that were extortion?

5 extortion crimes were committed during the month of June.

How many crimes were committed that had a take of less than $60,000?

10 crimes were committed that had a take less than $60,000.

How many extortion crimes were committed by mobsters whose last name starts with B?

3 mobsters were charged with extortion with the last name starting with the letter B.

Answer 7

Not sure if I'm supposed to do the other ones