Question: Make the following modifications to the spreadsheet Basic Excel 09 spreadsheet.xlsx. 1. In Basic Excel 09 spreadsheet.xlsx, insert a row between rows 5 and 6.

Make the following modifications to the spreadsheet Basic Excel 09 spreadsheet.xlsx.

1. In Basic Excel 09 spreadsheet.xlsx, insert a row between rows 5 and 6. In this new row, enter "Accounts receivable" in cell A6 and "Accounts payable" in cell C6.

2. Highlight the cells B6 and D6 if they are not already highlighted.

3. Enter the following values in the following cells:

cell B6 enter 10

cell D6 enter 15

4. Replace the text in cell A1 with your name. You may work on this in groups of up to four people if you prefer, or you may work by yourself. If you work in a group, please put all the group members names in cell A1, separated by commas

5. This is the hard part (and worth most of the points). Determine which of the formulas need to be modified for the spreadsheet to function properly.

Please make the required modifications and submit the modified spreadsheet by the due date.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!