Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. o.. AutoSave OFF AC -- Basic Excel Project 1 a Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Calibri (Body V 16 " = = = ab Wire Text General HP IV IIX AYO Pasto Ay Ay + - = - - - Warun & Center S - % Delic Insert Conditional Format Del Formatting as Table Styles Format Sort & Filter Find Scleat Analyze Data Create and Share Adobe PDF F1? X A HI C D I G H K I M N P 5 T DJ V w 2 3 Example: Application of the MAX, MIN, and SUM functions 4 Assets Financing s Excess cash Revolver Accounts Receivable 10 Accounts Payable 7 Other ST assets 75 Other debt 2 Long term assets 425 Equity 140 15 160 Note: ST = short term * 200 9 20 Total assets 510 Total financing 515 Total assets without 12 excess cash Total financing 500 without revolver 360 14 15 17 H 20 21 Ch 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. o.. AutoSave OFF AC -- Basic Excel Project 1 a Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Calibri (Body V 16 " = = = ab Wire Text General HP IV IIX AYO Pasto Ay Ay + - = - - - Warun & Center S - % Delic Insert Conditional Format Del Formatting as Table Styles Format Sort & Filter Find Scleat Analyze Data Create and Share Adobe PDF F1? X A HI C D I G H K I M N P 5 T DJ V w 2 3 Example: Application of the MAX, MIN, and SUM functions 4 Assets Financing s Excess cash Revolver Accounts Receivable 10 Accounts Payable 7 Other ST assets 75 Other debt 2 Long term assets 425 Equity 140 15 160 Note: ST = short term * 200 9 20 Total assets 510 Total financing 515 Total assets without 12 excess cash Total financing 500 without revolver 360 14 15 17 H 20 21 Ch
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started