Hello! I need help figuring out where I went wrong with this assignment. I uploaded the steps to complete the project along with a screenshot of the excel file I uploaded. It's just telling me the sheet is blank, but I definitely have data entered.

Here are the steps:

Mark the steps as checked when you complete them.

Open the start file EX$2021-$SkillReview$-1-2.$ The start file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor and save it$.$

The new workbook opens with one sheet $($Sheet$1).$ Cell A$1$ is selected.

In cell A$1,$ type the title for the worksheet: Textbooks

Enter data in the worksheet as follows:

Table EX $1\mathrm{.}7$ displays different textbooks and their corresponding costs, values, and the difference for each book.

Table EX $1\mathrm{.}7$:

A$.$ B$.$ C$.$ D$.$

$3.$ Book Cost Value Difference

$4.$ Book$19555$

$5.$ Book$211090$

$6.$ Book$3285135$

$7.$ Book$4100\mathrm{.}9544\mathrm{.}50$

Use AutoFill to add two additional books to the list.

Click cell A$4,$ hold down the left mouse button and drag the mouse to cell A$7.$ Release the mouse button. The cell range A$4$ through A$7$ should now appear selected.

Click the Fill Handle $($located at the lower right corner of the selected cell range$).$

Drag down to cell A$9,$ and release the mouse button.

Excel adds Book$5$ and Book$6$ to the list.

Book$5$ cost $$135\mathrm{.}00$ and can be sold for $$65\mathrm{.}00.$ Book$6$ cost $$195\mathrm{.}00$ and can be sold for $$125\mathrm{.}00.$ Add these data to the worksheet.

Click cell B$8$ and type: $135$

Press Tab and type: $65$

Click cell B$9$ and type: $195$

Press Tab and type: $125$

Press Enter.

Modify the status bar to display the minimum value.

Right$-$click anywhere on the status bar.$$

Click Minimum to add a checkmark.$$Hint: You may need to click the arrow at the bottom of the status bar menu to scroll through the list.

Click anywhere to dismiss the menu.

Use the status bar to check the total value of the books and the minimum value.

Click cell C$4.$ Press and hold Shift and click cell C$9.$ Release the Shift key.

Look at the status bar and find the Sum value $(514\mathrm{.}50).$

Look at the status bar and find the Min value $(44\mathrm{.}50).$

Use AutoSum to calculate total cost and total value. The totals should be placed in cells B$10$ and C$10.$

Click cell A$10$ and type: Total

Press Tab.

Cell B$10$ should be selected. Press and hold Shift and click cell C$10.$ Release the Shift key.

On the Home tab, in the Editing group, click the AutoSum button.

Change the number format for the cost and value numbers to the Accounting Number Format.

Click cell B$4.$ Press and hold Shift. Click cell C$10.$ Release Shift.

On the Home tab, in the Number group, click the Accounting Number Format button.

Enter a formula in cell D$4$ to calculate the difference between the cost and the value for Book$1.$ The formula will use only relative references because in the next step, you will use AutoFill to copy the formula down the column.

Click cell D$4.$

Type: $=$

Click cell B$4.$

Type: $$

Click cell C$4.$

Press Enter.

Use AutoFill to copy the formula to calculate the difference for books $2$ through $6$ and the total.

Click cell D$4.$

Click the AutoFill handle. Hold down the left mouse button and drag to cell D$10.$ Release the mouse button.

Insert a pie chart representing the cost of books.

Select cells A$3$:B$9.$ Click cell A$3,$ hold down the left mouse button, and drag the mouse to cell B$9.$ Release the mouse button. The cell range A$3$ through B$9$ should now appear selected.

The cell range A$3$ through B$9$ should now appear selected.

Click the Recommended Charts button on the Insert tab.

Scroll down the menu and click Pie to insert a pie chart.

Observe how each book is assigned a color in the chart legend.

The size of each pie piece represents the cost of each book relative to the total cost of all the books. Book $3$ is the most expensive book and is represented by the largest piece of the pie.

Change the chart title.

Click the Cost chart title once to select it$.$

Type: Comparative Cost of Books

Press Enter.

Save the workbook. Do not close it or exit Excel.

Comparative Cost of Books