Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Jay Abramson

1st Edition

9781938168345

Students also viewed these General Management questions