Enter a RIGHT function in cell I$2$ that will show the last two characters of the entry in cell A$2.$ Define the $$text$$ argument with cell A$2$ and define the $[$num$\_$chars$]$ argument with the number $2.$ The last two characters for the data shown in the District column is the abbreviation of the region. For example, district $10$NE is district $10$ in the Northeast region. The output of this function will allow the dataset to be summarized by region.

Copy cell I$2$ and paste it into all of the rows in the dataset by double clicking the Fill Handle.

In cell J$1,$ type the column heading $$Week$.$

Enter the WEEKNUM function in cell J$2$ that will show the week number related to the date in cell C$2.$ Define the $$serial$\_$number$$ argument with cell C$2.$ Define the $[$return$\_$type$]$ argument with the number $2,$ which assumes that Monday is the first day of the week. The output of this function will be useful if additional data is added to the dataset.

Copy cell J$2$ and paste it into all of the rows in the dataset by double clicking the Fill Handle.

In cell K$1,$ type the column heading $$Return Amount$.$

Enter an IF function in cell K$2$ that will show the absolute value of the returns in the Amount column. The logical test of the function should evaluate if cell F$2$ is less than $0.$ If the logical test is true, define the $[$value$\_$if$\_$true$]$ argument with the ABS function. Define the $$number$$ argument of the ABS function with cell F$2.$ If the logical test is false, the output of the IF function should be $0.$