please help!

Objectives: 1. To find and review materials on the fundamentals of spreadsheets. 2. To practice preparing a useful Excel spreadsheet. Having the skill to prepare a spreadsheet is quite useful. While accountants do this routinely, all management professionals will find this useful for making calculations and performing 'what-if' analyses, as well as preparing documents to communicate in an effective, visually appealing, and professional manner. One common approach in creating a new spreadsheet is to use an existing one as a template and simply change words and values in cells to fit your situation. While this is effective and can save time, there are many times when a template does not exist, and a new spreadsheet must be created starting from a blank worksheet. This Skill Building activity focuses on preparing an Excel spreadsheet from scratch, or said another way, preparing it starting with a blank spreadsheet with no data. After completing the Skill Building activity "Making Changes to an Already Prepared Spreadsheet", which included viewing Excel videos available using Linkedin Leaming. you are ready to create a spreadsheet of your own. For this activity we will take images from pages in the footnotes of both Community Health Systems and HCA, Inc. from their financial statements for the years ended 12/31/21 and prior. Your task is to duplicate the Community Health Systems schedule and roplicate it in an Excel spreadsheet by inputting the words, numbers, and formulas into individual cells, and making it appoar as close to the original as you can. Here is the Community Health Systems schedule with which to make your first Excel tab in your created spreadsheet. You do not need to copy the words they have used below; you can simply use a simple four-line heading noting it is Community Health Systems; Revenue by Payer; For the Years Ended December 31; and ( $ in Millions). COMMUNITY HEALTH SYSTEMS, INC. AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS - (Centinued) The Company's net operating revenues during the years ended Decernber 31, 2021, 2020 and 2019 have been presented in the following table based on a allocation of the estimated transaction price with the putient between the primary patient classification of insurance coverage (in millions): After your first tab is completed, copy it an make a second identical tab with the Community Health Systems payer information, and modify that second tab to be in the format like HCA which adds a ratio column the right of each year's column that contains dollar amounts. Here is the format that HCA uses. The ratio column shows the amount of revenue from each payer as a \% of the total revenues. Use the formula feature in Excel to calculate that for each payer. From HCA Healtheare, Inc. 2021 Annual Financial Statement footnotes with $ in millions: After your first tab is completed, copy it an make a second identical tab with the Community Health Systems payer information, and modify that second tab to be in the format like HCA which adds a ratio column the right of each year's column that contains dollar amounts. Here is the format that HCA uses. The ratio column shows the amount of revenue from each payer as a % of the total revenues. Use the formula feature in Excel to calculate that for each payer. From HCA Healthcare, Inc. 2021 Annual Financial Statement footnotes with \$ in millions: Note that it is very possible that these schedules in the Community Health Systems and HCA filed reports were first prepared on a spreadsheet and then provided to the printer for printing. This is a common approach as it allows the author to communicate the image exactly as they intend. And, with the use of formulas in the cells instead of fixed numbers where appropriate, it lessens the chance of misprinting the information. In this leaming exercise, take the time to practice your spreadsheet skills. Here is checklist of the things you need to consider and incorporate in your spreadsheet: 1. Use the underlines as shown in the columns. Make sure they are the same width as the column. 2. Use the calculation formulas in the cells where appropriate. (This will also serve to ensure you understand the calculations on the schedule). Do this everywhere that there is a calculation. 3. Format the numbers and words as the author has done. This includes using the same (or very close) font and presenting numbers to the same decimal level. Use a " $ " and show as whole numbers using a comma. For " $ " and "\%" symbols, always be careful on noting when and how that is to be presented. This is true with "Words" as well. They should be centered or justified to the right or left were appropriate. 4. Set the column width to ensure the numbers and words are readable. 5. Use the "bold" formatting as appropriate to emphasize certain areas. 6. Prepare each of the spreadsheet tabs for printing by using the "file > print > page setup" commands and entering the appropriate fields to print. When your completed spreadsheet is printed by the reader, they should not have to make any formatting changes for it to print in the manner that you want. For this exercise. set the spreadsheet to print in Landscape on 1 page. 7. Save the file using a filename that includes your name and the date. Having useful information in a file name is very helpful to both the reader and you. 8. Run "spellcheck" (Review > ABC Spelling; or, use the "F7" key) to catch any misspellings. 9. Put your name as the preparer in a footnote on the spreadsheet. Get used to using the footnote field at the bottom of the spreadsheet. You can use your name, or page number, or date, or file name. All are useful things 10. Prepare the titie of the document as close to the original format as you can. 11. Use this checklist after you are done to check your work. Do not worry about improving on what the author has done. Work to match your spreadsheet to be as close to theirs as you can. When you have completed the two tabs on your spreadsheet, print each one and compare them to the original above. How did you do? Did each print on one page landscape as instructed? Make any adjustments until you are comfortable with your work. Upload your work as an Excel file, not a PDF file, in the appropriate place in the Assignment folder by the due date noted there. Remember, you will have two tabs on your Excel file. One in the format that Community Health Systems originally used, and a second tab that modifies the first one by adding a ratio percent to total column. Objectives: 1. To find and review materials on the fundamentals of spreadsheets. 2. To practice preparing a useful Excel spreadsheet. Having the skill to prepare a spreadsheet is quite useful. While accountants do this routinely, all management professionals will find this useful for making calculations and performing 'what-if' analyses, as well as preparing documents to communicate in an effective, visually appealing, and professional manner. One common approach in creating a new spreadsheet is to use an existing one as a template and simply change words and values in cells to fit your situation. While this is effective and can save time, there are many times when a template does not exist, and a new spreadsheet must be created starting from a blank worksheet. This Skill Building activity focuses on preparing an Excel spreadsheet from scratch, or said another way, preparing it starting with a blank spreadsheet with no data. After completing the Skill Building activity "Making Changes to an Already Prepared Spreadsheet", which included viewing Excel videos available using Linkedin Leaming. you are ready to create a spreadsheet of your own. For this activity we will take images from pages in the footnotes of both Community Health Systems and HCA, Inc. from their financial statements for the years ended 12/31/21 and prior. Your task is to duplicate the Community Health Systems schedule and roplicate it in an Excel spreadsheet by inputting the words, numbers, and formulas into individual cells, and making it appoar as close to the original as you can. Here is the Community Health Systems schedule with which to make your first Excel tab in your created spreadsheet. You do not need to copy the words they have used below; you can simply use a simple four-line heading noting it is Community Health Systems; Revenue by Payer; For the Years Ended December 31; and ( $ in Millions). COMMUNITY HEALTH SYSTEMS, INC. AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS - (Centinued) The Company's net operating revenues during the years ended Decernber 31, 2021, 2020 and 2019 have been presented in the following table based on a allocation of the estimated transaction price with the putient between the primary patient classification of insurance coverage (in millions): After your first tab is completed, copy it an make a second identical tab with the Community Health Systems payer information, and modify that second tab to be in the format like HCA which adds a ratio column the right of each year's column that contains dollar amounts. Here is the format that HCA uses. The ratio column shows the amount of revenue from each payer as a \% of the total revenues. Use the formula feature in Excel to calculate that for each payer. From HCA Healtheare, Inc. 2021 Annual Financial Statement footnotes with $ in millions: After your first tab is completed, copy it an make a second identical tab with the Community Health Systems payer information, and modify that second tab to be in the format like HCA which adds a ratio column the right of each year's column that contains dollar amounts. Here is the format that HCA uses. The ratio column shows the amount of revenue from each payer as a % of the total revenues. Use the formula feature in Excel to calculate that for each payer. From HCA Healthcare, Inc. 2021 Annual Financial Statement footnotes with \$ in millions: Note that it is very possible that these schedules in the Community Health Systems and HCA filed reports were first prepared on a spreadsheet and then provided to the printer for printing. This is a common approach as it allows the author to communicate the image exactly as they intend. And, with the use of formulas in the cells instead of fixed numbers where appropriate, it lessens the chance of misprinting the information. In this leaming exercise, take the time to practice your spreadsheet skills. Here is checklist of the things you need to consider and incorporate in your spreadsheet: 1. Use the underlines as shown in the columns. Make sure they are the same width as the column. 2. Use the calculation formulas in the cells where appropriate. (This will also serve to ensure you understand the calculations on the schedule). Do this everywhere that there is a calculation. 3. Format the numbers and words as the author has done. This includes using the same (or very close) font and presenting numbers to the same decimal level. Use a " $ " and show as whole numbers using a comma. For " $ " and "\%" symbols, always be careful on noting when and how that is to be presented. This is true with "Words" as well. They should be centered or justified to the right or left were appropriate. 4. Set the column width to ensure the numbers and words are readable. 5. Use the "bold" formatting as appropriate to emphasize certain areas. 6. Prepare each of the spreadsheet tabs for printing by using the "file > print > page setup" commands and entering the appropriate fields to print. When your completed spreadsheet is printed by the reader, they should not have to make any formatting changes for it to print in the manner that you want. For this exercise. set the spreadsheet to print in Landscape on 1 page. 7. Save the file using a filename that includes your name and the date. Having useful information in a file name is very helpful to both the reader and you. 8. Run "spellcheck" (Review > ABC Spelling; or, use the "F7" key) to catch any misspellings. 9. Put your name as the preparer in a footnote on the spreadsheet. Get used to using the footnote field at the bottom of the spreadsheet. You can use your name, or page number, or date, or file name. All are useful things 10. Prepare the titie of the document as close to the original format as you can. 11. Use this checklist after you are done to check your work. Do not worry about improving on what the author has done. Work to match your spreadsheet to be as close to theirs as you can. When you have completed the two tabs on your spreadsheet, print each one and compare them to the original above. How did you do? Did each print on one page landscape as instructed? Make any adjustments until you are comfortable with your work. Upload your work as an Excel file, not a PDF file, in the appropriate place in the Assignment folder by the due date noted there. Remember, you will have two tabs on your Excel file. One in the format that Community Health Systems originally used, and a second tab that modifies the first one by adding a ratio percent to total column