OPIM 3103 009 Final Project 2023

Written Use Case Follow the sample format shown in the attached photo.Sample have its label, while the one you should make a written use case is the one who have blue ovalsNOTE: YOU SHOULD MAKE THE WRITTEN USE CASE AS YOU CAN SEE IN THE SAMPLE TABLE. SOMEONE IS ANSWERING MY QUESTION WRONG!

Exercise 1 - Ms excel Insert Pivot Table: Your task is to bring up the pivot table. Then remove the grand total and edit the pivot table. Group Data by Year: The second task is to group the sales amount by the year or months. Find Running Total by Date: Your objective is to find the running total by date using the data. Insert a Pie Chart: You will create a pie chart from the data in this problem, you will need to insert slicer to the pivot table. Use the calculated Field to find the sales tax which is 5% of the total sales.

Ma3. Assume we have added new data to a dataset and would like to make sure our previously created PivotTables and PivotCharts are updated to reflect the newly added data. You can also assume that the cell range used within the PivotTable and PivotCha would capture this newly added data. Which of the following statements is TRUE?   A. To update the analysis after new data is added, the Format button in the Home tab must be clicked.   B. To update the analysis after new data is added, the Refresh All button in the Data tab must be clicked.   C. To update the analysis after new data is added, the Data Analysis button in the Data tab must be clicked.   D.The newly added data will automatically be updated within the previously created PivotTables and PivotCharts.

In the Media Posts worksheet, in column G of the Facebook table, apply the VLOOKUP function to categorize the size of each post, using the value Characters field for the lookup value, the Character_Lookup table as the lookup table, and the second column of the table as the return value.