Ms Excel _ Assignment
Click here for Excel file : Instructions: 1. Use the Excel file “Lab2Start v5.xlsx” for this exercise. 2. Make a copy of the worksheet data for your work. (Note: Do not copy the worksheet copy the data) 3. The first thing you need to do is to convert the data into an Excel table. Add a total row for the table, and use the Sum aggregation to show the total of the Revenue column and then filter the data only for United States. Q1. What is the total revenue for all the sales in the United States? a) 101990988 b) 27975547 c) 24606895 d) 12494351 Now, you need to add several columns, derived from existing columns in the data. First, let's add a "Month" column. Insert a new column to the left of the Customer ID column, and use formula to derive the month of sales from the Date column. HINT: Use the Text() function Q2. What is the total revenue for all the sales in the month of December? a) 9086931 b) 8801313 c) 6809175 d) 6494188 Next, let's add an ...