Question: PROJECT STEPS 1. Emma Demitros is a direct sales representative for ExpressBuy, an online marketplace for consumer products, headquartered in Yonkers, New York. She has
PROJECT STEPS 1. Emma Demitros is a direct sales representative for ExpressBuy, an online marketplace for consumer products, headquartered in Yonkers, New York. She has created a worksheet comparing the profits of two office product lines, and has asked you to help complete the analysis. Go to the Profit Analysis worksheet. Enter the text ExpressBuy Office Products in cell A1 to provide a title for the worksheet. 2. In cell A2, enter the text Profit Analysis to provide a subtitle. 3. Clear everything from cell G2 to remove the redundant information. 4. In cell A3, change the text "2020" to 2022 so that the cell contains the correct text, "ExpressBuy Office Supplies 2022-2024 Profit". 5. In cell D9, enter the value 48050 to provide the profit amount for storage products in 2024. 6. Use the Fill Handle to fill the range E6:E10 with the formula in cell E5 to find the total profit for each type of office supply. 7. Emma wants to calculate the total profit in office supplies for each year and for all types. Enter this information as follows
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
