At first rehabilitation psychologist assesses a patient$$s cognitive strengths and deficiencies as well as emotional or behavioral problems and adjustment problems. To inform future interventions, they assess family coping while keeping track of a patient$$s functions improvements. On this basic, they collaborate with the patient$$s family to ensure that the patient will adapt as best as possible to TBI by teaching behaviour management techniques. To maximize healing, they also adjust treatment strategies with the help of the team. Additionally, they take actions to address behavioral issues, emotional disorders and cognitive difficulties to speed rehabilitation.

ASSISTANT $$

It's great that you highlighted the crucial role of a rehabilitation psychologist in assessing cognitive strengths, emotional issues, and family coping in traumatic brain injury cases. Their collaboration with families and adjustment strategies are indeed vital for the patient's adaptation and recovery. The tailored treatment plans and focus on behavioral, emotional, and cognitive aspects play a significant role in speeding up the rehabilitation process.

ME

Open the NP$\_$EX$\_6-4.$x$/$sx workbook located in the Excel$6>$ Casel folder included with your Data Files. Save the workbook as NP$\_$EX$\_6\_$Seacation in the location specified by your instructor.

$2.$ In the Documentation sheet, enter your name and the date in the range B$3$:$4.$

$3.$ Alana is concerned that the list of inventory items contains duplicate records. In the Inventory worksheet, use the Remove Duplicates tool to remove records for which every field value is duplicated. Verify that Excel reports that five duplicates are removed.

$4.$ Convert the data range in the Inventory worksheet to an Excel table. Rename the table using Inventory$\_$Tbl as the table name.

$5.$ Sort the table by ascending order of the Warehouse, Bin, and Part ID fields.

$6.$ Insert a new field named Inventory Value between the Stock Qty and Reorder Qty fields.

Unit Cost ted venter value by usingy field es oter the sary, a hat mutipies thing

the Currency format and resize the column to fit the data.

$7.$ Click cell J$4$ and add a new field named Restock that you'll use to determine which items need to be restocked. Use your mouse to enter an IF function that displays a value of "Yes" if the Stock Qty field $($cell F$5)$ is less than or equal to the Reorder Qty field $($cell H$5)$ and $"$No$"$ if it is not.

$8.$ Click cell K$4$ and add the Restock Indicator field. Use your mouse to enter a formula that uses the IF function to display the value $1$ if the Restock field $($cell J$5)$ equals "Yes" and the value $0$ otherwise. Resize the column to fit the data.

$9.$ Click cell L$4$ and add the Restock Qty field. In this field, determine the number of items to order for products that need to be restocked. Use your mouse to enter a formula equal to the Restock Indicator field $($cell K$5)$ times the difference between the Restock Level and Stock Qty fields

$(15-$ F$5).$ Resize the column to fit the data.

$10.$ Click cell M$4$ and add a new field named Restock Cost to calculate how much it will cost to restock the items that need restocking. Use your mouse to enter a formula that multiplies the Restock Qty field $($cell L$5)$ by the Unit Cost field $($cell E$5).$ Format the calculated values as currency and resize the column to fit the data.

$11.$ Filter the Inventory$\_$Tbl table to show only records where the Restock field equals "Yes." Copy the filtered table and paste it into the Restock List worksheet at cell A$4.$

$12.$ In the Restock List worksheet, add subtotal rows at each change in the Warehouse field, showing the sum of the Restock Qty and Restock Cost fields.

$13.$ Add a freeze pane to the Restock List worksheet at cell E$5.$

$14.$ Return to the Inventory worksheet and clear the filter to redisplay all the records in the table.

$15.$ Insert slicers for the Warehouse and Bin fields. Move the slicers to the Report worksheet. Place the Warehouse slicer over the range A$4$:A$7$ with $4$ columns in the button layout. Place the Bin slicer in the range A$9$:$16$ with $3$ columns in the button layout.

ASSISTANT $$