Exp25_Excel_Ch01_HOE_Souvenirs | Exp25 Excel Ch01 HOE Souvenirs | Complete | ‪@PearsonSolution‬ ​

#Exp25_Excel_Ch01_HOE_Souvenirs #Excel_Ch01_HOE_Souvenirs #Excel_Ch01 #Ch01_HOE_Souvenirs #Souvenirs #Exp25_Excel_Ch01_HOE_Souvenirs.xlsx #Exp25 #Exp25_Ch01_HOE_Souvenirs #Ch01_HOE_Souvenirs #HOE #Exp25_Excel_Ch01_HOE_Souvenirs #Ch01 #Ch01_HOE_Souvenirs #Exp25 #Exp25_Excel_Ch01_HOE_Souvenirs #Excel_Ch01_HOE_Souvenirs #Excel_Ch01 #Ch01_HOE_Souvenirs #Souvenirs #Exp25_Excel_Ch01_HOE_Souvenirs.xlsx #Exp25 #Exp25_Ch01_HOE_Souvenirs #Ch01_HOE_Souvenirs #HOE #Exp25_Excel_Ch01_HOE_Souvenirs #Ch01 #Ch01_HOE_Souvenirs #Exp25 Contact WhatsApp 1: +923137183201 WhatsApp 2: +923066092459 Email:: : pearsonsolutions653@gmail.com Direct WhatsApp link Link : https://wa.me/923137183201 #Exp25_Excel_Ch01_HOE_Souvenirs #Excel_Ch01_HOE_Souvenirs #Excel_Ch01 #Ch01_HOE_Souvenirs #Souvenirs #Exp25_Excel_Ch01_HOE_Souvenirs.xlsx #Exp25 #Exp25_Ch01_HOE_Souvenirs #Ch01_HOE_Souvenirs #HOE #Exp25_Excel_Ch01_HOE_Souvenirs #Ch01 #Ch01_HOE_Souvenirs #Exp25 #Exp25_Excel_Ch01_HOE_Souvenirs #Excel_Ch01_HOE_Souvenirs #Excel_Ch01 #Ch01_HOE_Souvenirs #Souvenirs #Exp25_Excel_Ch01_HOE_Souvenirs.xlsx #Exp25 #Exp25_Ch01_HOE_Souvenirs #Ch01_HOE_Souvenirs #HOE #Exp25_Excel_Ch01_HOE_Souvenirs #Ch01 #Ch01_HOE_Souvenirs #Exp25 Exp25_Excel_Ch01_HOE_Souvenirs Project Description: As the assistant manager of Celebrity Musician’s Souvenir Shop, you want to calculate the retail price, sale price, and profit analysis for selected items on sale this month. In addition, you will adjust column and row settings, move and copy data, format the worksheet, and apply Page Setup options. Use Excel to check and correct the spelling errors in the worksheet. Enter 101 in cell B5 and use Auto Fill to complete the sequence for the range B6:B10 with a series. 3 Find all occurrences of 0.05 and replace them with 0.10. 2 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 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 In cell H5, calculate the sale price. Copy the formula down the range H6:H10. 5 In cell I5, enter a formula to calculate the profit margin. Copy the formula to the range I6:I10. Insert a new column I and enter Profit Amount in cell I4. 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 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 Increase the width of column A to 23.00. Change the height of row 1 to 30. Hide column B containing the product codes. Select and cut the range A11:J11. Insert cut cells on row 8. 3 Copy the range A10:J10 and paste it in cell A12. In cell A12, enter Travel Mug. In cell C12, enter In cell A1, apply bold, select 14 pt font size, and select Dark Red font color. Copy the range A1:J12 and paste it in cell A20 as Values & Source Formatting. Select the range A1:J1 and apply Heading 1 cell style, merge and center the data, and apply Middle Align vertical alignment. Select the range A4:J4. Horizontally center, apply bold, and wrap text for the headings. Select the ranges A6:A8 and A10:A12. Indent twice the product names. Select the range A4:J4. Apply Blue-Gray, Text 2, Lighter 80% fill color (second row, fourth column). Select the range G4:H12 and apply the Thick Outside Borders. On a Mac, apply Thick Box Border. Select the ranges C6:C12, E6:F12, and H6:I12 and apply Accounting Number Format. 3 Select the ranges D6:D12 and J6:J12. Apply Percent Style and increase the decimal points to show one digit to the right of the decimal point. Select the range G6:G12, apply Percent Style, and horizontally center the data. Select both worksheets and change the orientation to landscape. With both sheets selected, set a 1-inch top margin and select the option to horizontally center the data on the page. Select the scaling option to fit data on each worksheet on one page. With both sheets selected, insert a header with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. Click the September sheet to make it active. 3 29 Save and close Exp22_Excel_Ch01_HOE_Souvenirs.xlsx. Exit Excel. #Exp25_Access_Ch04_HOEAssessment_Conference.accdb #Exp25_Access_Ch02_HOEAssessment_Drama #Exp25_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb #Exp25_Access_Ch04_HOEAssessment - Leadership Conference 1.1 #Exp25_Excel_AppCapstone_IntroAssessment_Travel #Exp25_Access_Ch03_CapAssessment_Retirement_Accounts.accdb #Excel_2F_Bonus #Excel_2E_Dessert_Inventory #Exp25_Excel_Ch06_Cumulative_AutoSales