Please give steps for all 30 instructions. Relevant files have been posted as well. Thank you.

Project Description: You have recently become the CFOlfor Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly import data from another source. Steps to Perform: 7 Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee 3 is full-time and has at least one dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format. \begin{tabular}{c|l|c} \hline 8 & ApplyconditionalformattingtotherangeC5:C34thathighlightsanydependentsthataregreaterthan3withLightRedFillandDarkRedText. & 4 \\ \hline 9 & ClickcellH10,andenteranAVERAGEIFSfunctiontodeterminetheaveragesalaryoffull-timeemployeeswithatleastonedependent.FormattheresultsinAccountingNumberFormat. & 3 \\ \hline 10 & UseAdvancedFilteringtorestrictthedatatoonlydisplayfull-timeemployeeswithatleastonedependent.PlacetheresultsincellA37.UsethecriteriaintherangeH24:M25tocompletethefunction. & 2 \\ \hline 11 & EnsurethattheFacilitiesworksheetisactive.UseGoalSeektoreducethemonthlypaymentincellB6totheoptimalvalueof$6000.CompletethistaskbychangingtheLoanamountincellE6. & 5 \\ \hline \end{tabular} Created On: 11/18/2022 1 Exp19_Excel_AppCapstone_CompAssessment- Manufacturing 1.12 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. \begin{tabular}{c|l|l|} \hline 18 & EnterafunctionincellH12,basedonthepaymentandloandetails,thatcalculatestheamountofcumulativeprincipalpaidonthefirstpayment.Besuretousetheappropriateabsolute,relative,ormixedcellreferences. \\ \hline 19 & Enterareferencetotheremainingbalanceofpayment1incellB13.Usethefillhandletocopythefunctionscreatedinthepriorstepsdowntocompletetheamortizationtable. \\ \hline 20 & EnsuretheSalesworksheetisactive.EnterafunctionincellB8tocreateacustomtransactionnumber.ThetransactionnumbershouldbecomprisedoftheitemnumberlistedincellC8combinedwiththequantityincellD8andthefirstinitialofthepaymenttypeincellE8.UseAutoFilltocopythefunctiondown,completingthedataincolumnB. \\ \hline 21 & EnteranestedfunctionincellG8thatdisplaysthewordFlagifthePaymentTypeisCreditandtheAmountisgreaterthanorequalto$4000.Otherwise,thefunctionwilldisplayablankcell.UseAutoFilltocopythefunctiondown,completingthedataincolumnG. \\ \hline \end{tabular} Created On: 11/18/2022 2 Exp19_Excel_AppCapstone_CompAssessment - Manufacturing 1.12 Grader - Instructions Excel 2019 Project \begin{tabular}{|c|l|c|} \hline Step & \multicolumn{1}{|c|}{ Instructions } & \multicolumn{1}{|c|}{PointsPossible} \\ \hline 22 & CreateadatavalidationlistincellD5thatdisplaysQuantity,PaymentType,Amount(inthatorder).Donotusecellreferencesasthesourceofthelist.Besuretoenterablankspaceaftereachcommawhenenteringthevalues. & 5 \\ \hline \end{tabular} Home Insert Draw Page Layout Formulas Data Review view Q Tell me Dalyze Data A14x=fx in C M N 0 T w w x 1 i Facility Amortization Table Proment Beginning Porment Number Balsence Amount Principal Pemsining Cumalative Cumulative Interest Pald Repayment Balance Interest PTrelpal \begin{tabular}{|} 1 \\ 2 \\ \hline 3 \\ 4 \\ \hline \end{tabular} \begin{tabular}{r|} 17 \\ 18 \\ 19 \\ 20 \\ 21 \\ 22 \\ \hline \end{tabular} \begin{tabular}{lllll} Item & \multicolumn{2}{l}{ Quantity } & Total Value & Warehouse \\ 1001 & 5000 & 40000 & A & \\ 2002 & 3500 & 35000 & A & \\ 3003 & 2500 & 30000 & B & \\ 4004 & 4000 & 22000 & C & \\ 5005 & 1000 & 18000 & D & \end{tabular}