Open   the Excel workbook To the right of column B, insert   two new columns to create new blank columns C and D. By using Flash Fill in   the two new columns, split the data in column B into a column for Item # in   column C and Category in column D. As necessary, type as the column title in column C   and as the column   title in column D. Delete column B. By using the Cut and Paste   commands, cut column C— and   paste it to column H, and then delete the empty column C. Apply AutoFit to   columns A:G. In cell B4, insert a function to   calculate the Total Items in Stock by summing the Quantity in Stock data, and   then apply Comma style with zero decimal places to the result. In each cell in the range B5:B8,   insert functions to calculate the Average, Median, Lowest, and Highest retail   prices, and then apply the Accounting Number Format to each result. Move the range A4:B8 to the   range D4:E8, apply the 40% – Accent4 cell style to the range, and then select   columns D:E and AutoFit.

In the given Excel workbook, certain actions are to be performed using various commands and functions. The first step is to insert two new blank columns, C and D, to the right of column B. This can be done by selecting column C and column D and then right-clicking to choose the “Insert” option. Next, the data in column B needs to be split into two separate columns. This can be achieved by utilizing Flash Fill in the two new columns, with the Item # being entered into column C and the Category being entered into column D. It may be necessary to type “Item #” as the column title in column C and “Category” as the column title in column D. Once the data has been properly split, column B can be deleted.

To move column C, the Cut and Paste commands can be used. First, the column C can be cut by selecting it and then right-clicking to choose the “Cut” option. Then, the column H can be selected, and the Paste command can be used to paste column C into column H. Once the data has been successfully moved, the empty column C can be deleted.

To ensure that the columns A:G have the appropriate width to display the data properly, the AutoFit command can be applied. This can be done by selecting columns A to G, right-clicking, and choosing the “AutoFit” option.

In cell B4, a function needs to be inserted to calculate the Total Items in Stock by summing the Quantity in Stock data. This can be achieved by typing “=SUM(B5:B8)” in cell B4. Additionally, to format the result in a desired way, the Comma style with zero decimal places can be applied.

For each cell in the range B5:B8, functions need to be inserted to calculate the Average, Median, Lowest, and Highest retail prices. The AVERAGE, MEDIAN, MIN, and MAX functions can be used respectively. To format the results in a specific format, such as the Accounting Number Format, this formatting can be applied to each result.

Next, the range A4:B8 needs to be moved to the range D4:E8. This can be done by selecting the range A4:B8, right-clicking, and choosing the “Cut” option. Then, the range D4:E8 can be selected, and the Paste command can be used to paste the data from the clipboard. Once the data has been moved, the 40% – Accent4 cell style can be applied to the range. To ensure that the columns D and E have the appropriate width, the AutoFit command can be applied by selecting columns D and E and right-clicking to choose the “AutoFit” option.

In summary, the given Excel workbook requires the insertion of new columns, the splitting of data, cutting and pasting of columns, applying formatting to cells, moving and pasting data, and applying cell styles and column widths. By following the provided steps and utilizing the appropriate commands and functions, these actions can be performed as required.