Question: Questions: Open the Excel File Project 1 Data 2023 and save it on your system as Project YourFirstName_YourLastName (Example: Project1_Zeinab_Karake.xlsx) 1. Change the name
Questions: Open the Excel File Project 1 Data 2023 and save it on your system as Project YourFirstName_YourLastName (Example: Project1_Zeinab_Karake.xlsx) 1. Change the name of the data sheet from Sheet1 to Transaction. (0. 5 Points) 2. It is expected that Unit Price will increase by 5 percent in 2023. Complete the table in range Q15:S20. Make sure to use a formula using both absolute and relative referencing to complete this task. (1 point) 3. Name the range Q15:S20 Price (1 point) 4. Compute Net Revenues in Column L. Format this column as currency with two decimal points. (Net Revenue is calculated as the Number of Items Sold minus the Number of Returns multiplied by the Unit Price [Column H]. (1 point) 5. In range Q3:R12 of the Transaction sheet, compute the following for Net Revenues: SUM, AVERAGE, COUNT, MAXIMUM, MINIMUM, VARIANCE, MEDIAN, COUNT, 6th SMALL, and 4th LARGE. Format the cells appropriately. (1 point) 6. Create a Profits Column in Column M. Compute Net Profits (Net Revenues minus Net Costs). (0.5 Points) 7. It is believed that the ErgoQueen beds in the SW region have a lower number of returns over the three-year period (2020-2022) than the ErgoQueen returns in the NW region. Does the data support this claim? Justify and support your answer. Record your answer to this question on a separate sheet named Question 7. Please create the appropriate functions on the Question 7 sheet and refer to the data in the Transaction sheet. (Do not copy the data into the new sheet). (1 point)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
