Exp22_Excel_Ch04_HOE - Toy Store 1.1 | Exp22 Excel Ch04 HOE ToyStore | Exp22 | ‪@PearsonSolution‬

#Exp22_Excel_Ch04_HOE - Toy Store 1.1 #HOE_Toy_Store_1.1 #Exp22_Ch04 #Exp22_HOE #Exp22_Excel_Ch04_HOE_ToyStore.xlsx #Exp22_Excel_Ch04 #Ch04_ToyStore #HOE #Exp22_Excel_Ch04_HOE_Toy_Store #Excel_Ch04_HOE_Toy_Store #Excel #Toy_Store #Exp22_Excel_Ch04_HOE_ToyStore.xlsx #Toy_Store #HOE #Exp22 #Exp22_HOE_ToyStore #Exp22_Excel #Exp22_Excel_Ch04 #Homes #HOE_ToyStore #Toy_Store #ToyStore #Exp22_Excel_Ch04_HOE_ToyStore #Exp22_Excel_Ch04_HOE_ToyStore #Excel_Ch04_ToyStore #Excel_2022_Project #Excel_Ch04_HOE_ToyStore #Exp22_Excel_Ch04_HOE_ToyStore #Exp22_Excel_Ch04_HOE_ToyStore.xlsx Contact WhatsApp 1: +923137183201 WhatsApp 2: +923458962216 Email:: : pearsonsolutions653@gmail.com Direct WhatsApp link Link : https://wa.me/923137183201 #Exp22_Excel_Ch04_HOE - Toy Store 1.1 #HOE_Toy_Store_1.1 #Exp22_Ch04 #Exp22_HOE #Exp22_Excel_Ch04_HOE_ToyStore.xlsx #Exp22_Excel_Ch04 #Ch04_ToyStore #HOE #Exp22_Excel_Ch04_HOE_Toy_Store #Excel_Ch04_HOE_Toy_Store #Excel #Toy_Store #Exp22_Excel_Ch04_HOE_ToyStore.xlsx #Toy_Store #HOE #Exp22 #Exp22_HOE_ToyStore #Exp22_Excel #Exp22_Excel_Ch04 #Homes #HOE_ToyStore #Toy_Store #ToyStore #Exp22_Excel_Ch04_HOE_ToyStore #Exp22_Excel_Ch04_HOE_ToyStore #Excel_Ch04_ToyStore #Excel_2022_Project #Excel_Ch04_HOE_ToyStore #Exp22_Excel_Ch04_HOE_ToyStore #Exp22_Excel_Ch04_HOE_ToyStore.xlsx Exp22_Excel_Ch04_HOE - Toy Store Project Description: You work for the owner of Trinkets Toys & Games LLC. All merchandise is categorized into one of five departments for inventory records and sales. You downloaded June 2024 data from the sales system into an Excel workbook. Because the dataset is large, you will convert the data into a table, sort, filter, and utilize conditional formatting to complete your analysis. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named Exp22_Excel_Ch04_HOE_ToyStore.xlsx. ‪@PearsonSolution‬ ‪@PearsonSolution‬ ‪@PearsonSolution‬ Modify the existing page breaks to ensure the 6/13 and 6/24 transaction dates print on the same page. 3 3 Create a copy of the June Totals worksheet and name it June 1st Totals. Set the titles in row 5 and columns A:B to repeat when printed. Additionally set the print order to print over then down. Convert the range A5:K110 to a table. Be sure to include column labels. Name the table Totals and apply the table style Light Yellow, Table Style Light 19. Delete the Sales_First column from the table. Type Rebate in cell K5 and Owed in cell L5. Set the width of columns I:J to autofit. Insert a row in the table at row 73 and row 112. Enter the following records. Row 73 - 2024-068, 6/22/2024, Shah, Collectibles, 1014, Mattel, Store Credit, Standard, 4, $16.99 ‪@PearsonSolution‬ ‪@PearsonSolution‬ ‪@PearsonSolution‬ Remove all duplicate values from the Totals table. Enter an IF statement in cell K6 to determine the customers rebate. If the value in cell H6 = Promotion the customer receives a 10% rebate on the total purchase (Purchase Price * Quantity*Rebate) if they are not eligible the function should return 0. Be sure to use the appropriate structured references Enter a formula using structured references in cell L6 to calculate the total owed. The total owed is the purchase price * quantity - rebate. Add a total row to the existing table and set the Rebate and Quantity subtotals to Sum. For the last level of the sort add a custom list for the department column. The list should use the following order Electronics, Collectibles, Infants, Action Figures, and Board Games. 6 14 Apply a filter to the table to only display only electronics department sales from sales rep Radomanski. Create a new conditional formatting rule to highlight the name Rodriguez in column C with Green Fill with Dark Green Text. 4 18 Create a new conditional formatting rule to highlight the top 3 sales amounts in column L with light red fill and dark red text. 4 19 Add Blue Data Bars conditional formatting to column K. 4 ‪@PearsonSolution‬ ‪@PearsonSolution‬ ‪@PearsonSolution‬ 20 Create a conditional formatting rule that highlights any transaction in column A that is completed by the sales rep Rodriguez with a value over $500. Ensure the formatting applies Bold font with Orange Accent 2 background color. 6 21 Filter column A based on color. 4 22 Save and close Exp22_Excel_Ch04_HOE_ToyStore.xlsx. #Exp19_Access_Ch04_HOEAssessment_Conference.accdb #Exp19_Access_Ch02_HOEAssessment_Drama #Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb #Exp19_Access_Ch04_HOEAssessment - Leadership Conference 1.1 #Exp22_Excel_AppCapstone_IntroAssessment_Travel #Exp19_Access_Ch03_CapAssessment_Retirement_Accounts.accdb #Excel_2F_Bonus #Excel_2E_Dessert_Inventory #Exp22_Excel_Ch06_Cumulative_AutoSales #Excel_2E_Plants #Exp22_Excel_Ch02_CumulativeAssessment_Inland_Jewelers