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
Get step-by-step solutions from verified subject matter experts
