Exp22_Excel_Ch01_HOE_Souvenirs | Excel Chapter 1 Hand On Exercise Celebrity Musician's Souvenir Shop
#Exp22_Excel_Ch01_HOE_Souvenirs#Excel_Ch01_HOE_Souvenirs
#Ch01_HOE_Souvenirs#Excel Chapter 1 Hand On Exercise
#Excel Chapter 1 Hand On Exercise_Step_by_Step#Souvenirs
#Excel Chapter 1 Hand On Exercise_HOE_Souvenirs
#Exp22_Excel_Ch01#HOE_Souvenirs_Exp22_Excel_Ch01#HOE_Souvenirs
#exp22_excel_ch01_hoe_souvenirs#Excel_Chapter_1_Hands_On_Exercise_Celebrity_Musician's_Souvenir_Shop#HOE HOESouvenirs
#Exp22_Excel_Ch01_Souvenirs#Exp22_Excel_Souvenirs
#Excel Chapter 1_Souvenirs
Contact:
WhatsApp : +92 3261513851
Email : mypearson100@gmail.com
Direct WhatsApp link
[ Ссылка ]
1 Start Excel. Download and open the file named Exp22_Excel_Ch01_HOE_Souvenirs.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 You notice that the worksheet contains some spelling errors that need to be corrected.
Use Excel to check and correct the spelling errors in the worksheet.
2
3 You want to use Auto Fill to enter a series of codes to create the product numbers.
Enter 101 in cell B5 and use Auto Fill to complete the sequence for the range B6:B10 with a series. 3
4 To motivate customers to buy more products, you want to change the 5% (0.05) off to 10% (0.10) off.
Find all occurrences of 0.05 and replace them with 0.10. 2
5 Column C contains the cost of each product, and column D contains the markup rate. Using these values, you will calculate the markup amount for each product in column E.
In cell E5, enter a formula to calculate the markup amount, which is the result of multiplying the cost by the markup rate. Copy the formula to the range E6:E10. 5
6 Now that you have calculated the markup amount, you can calculate the retail price for each product in column F.
In cell F5, enter a formula to calculate the retail price, which is the sum of the cost and the markup amount. Copy the formula to the range F6:F10. 5
7 Each item is on sale this week. The sale price is X percent off the retail price. You need to calculate the sale price.
In cell H5, calculate the sale price. Copy the formula down the range H6:H10. 5
8 The profit margin is the ratio of the net profit as a percentage of revenue. The formula first calculates the net profit between the sale price and the cost and divides that by the sale price.
In cell I5, enter a formula to calculate the profit margin. Copy the formula to the range I6:I10. 5
9 You decide to add a column to display the profit. Because profit is a dollar amount, you want to keep the profit column close to another column of dollar amounts. You will insert a column for the profit amount and enter the column heading.
Insert a new column I and enter Profit Amount in cell I4. 2
10 Now you are ready to enter the profit amount formula.
In cell I5, enter a formula to calculate the profit, which is the difference between the sale price and original cost. Copy the formula to the range I6:I10. 5
11 You want to insert two rows for category names above their respective products. Then you want to delete the row containing the Soundtrack CD.
Insert a new row 5 and type Apparel in cell A5. Insert a new row 8 and enter Souvenirs in cell A8. Bold the words in cells A5 and A8. Delete row 11 containing the Soundtrack CD. 5
12 Column A is too narrow for the product names. You want to increase the width. In addition, you want to increase the height for the first row. Finally, you decide to hide the product code column.
Increase the width of column A to 23.00. Change the height of row 1 to 30. Hide column B containing the product codes. 3
13 The T-shirt product is below the Souvenirs heading. This product belongs in the Apparel section. You will move the T-shirt product row to be above the Souvenirs heading.
Select and cut the range A11:J11. Insert cut cells on row 8. 3
14 The travel mug product information is missing. Because it is similar to the mug data, you will copy and paste the mug data and then edit it for the travel mug.
