Autowe ON Assignment Winter(1). Search (At) net gay Home Insert Page Layout Formulas Data Review View Help X ft Data Entry worksheet A B D A Comma Sep Data Entry worksheet 1 Correct the spelling errors in cell B1. Find the last cell in the worksheet and enter the text it contains into cell B4. The last cell is the intersection 1 of the last row that contains data and the last column that contains data. Use Excel's Help system to look up how to correct an error. From the results you obtain, in cell B6 briefly explain in one sentence what a tot error indicates. The main goal of this question is to show that 1 you can use Excel's Help system - not your ability to explain the error. 1 Change the tab colour of the worksheet to Green Music Collection worksheet Import the Music Collection csv file beginning at cell A2 in the Music Collection worksheet. Note that the 2 csv file uses a comma delimiter and it includes a header row. 1 Set a Print Area so that only columns A, B, C, and D will print. 1 Add a Footer that will show Page 1 of ? In the bottom centre of each page. Structuring Data worksheet 1 Change the width of column A to 14. 1 Adjust the width of columns H through N to 14. 1 Insert one cell below each of the cells AS through F5. Do not insert an entire row in the worksheet. Enter the following data in the new cells: cell A6 - Pharmaprix, cell B6 - 100, cell C6 - 56789, cell D6 - 1 67890, cell E6-78901. 1 Copy the formula in cell F5 to cell F6. 1 Name the range C3 to F10 (C3:F10) Q1_Sales Instructions - Grading Data Entry Music Collection Structund LO 3 O Auto 11 Assignment Search Away Fle Bome Insert Page Layout Hoteles Data Renew ViewHelp Comments Sh 1 Correct the spelling errors in cell B1. D Correct the spelling errors in cell B1. There are a few spelling errers here - please fixe them. Remembr to save your werk when completeed. Find the last cell in the worksheet and type the data it contains into cell B4. The last cell is the intersection of the last column and last row that contains data Use Excel's Help system to look up how to correct a ### error. From the results you obtain, briefly explain in one sentence what and error indicates in cell B6. The main goal of this question is to show that you can use Excel's Help system - not your ability to explain the error tronding Dataty Music Collection Strong EN OLT SP Loe AutoSave OM H Assignment 1 Winter() Search AO) File Home Insert Page Layout Formulas Data Review View Help 614 1 D 1 Music Collection G H 2 10 structions Music Collection a e Edhe ET FZ B @ AutoSave of B Assignment 1_Winter(1) Search (Alto) View Help G H 1 2 File Home Insert Page Layout Formulas Data Review J11 .:X fx A B C D E F Get Well Soon Pharmaceuticals First Quarter Sales 3 Custome ID # January February March Total 4 Costco 109 176,953 145,689 167,459 5 London 125 33,489 27,865 29,757 91,111 6 Pharma 101 24,543 17,654 20,646 62,843 7 Rexall 145 77,865 86,765 76,412 8 Shoppe 132 257,843 296,589 309,754 ###### 9 Walmar 121 209,563 189,076 199,654 10 11 12 13 14 15 16 17 18 19 20 instructions - Grading Data Entry Music Collection Struguring Data Read AutoSave oft Music Collection() O Search (Alt+Q File Home Insert Page Layout Formulas Data Review View Help POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv for Xfx ID A1 G 1 ID 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 B C D E F Song Performer Album Genre 1 Snowbird Anne Mur Snowbird Country 2 Kashmir Led Zeppe Physical G Hard Rock 3 Stayin' Ali Bee Gees Saturday I Disco 4 Viva la Vic Coldplay Viva la Vic Alternative Rock 5 Blue Sued Elvis Presl Elvis Presl Rock 6 Riverboat David Wil My Eyes k Rock 7 Could I Ha Anne Mur Anne Mur Country 8 Yellow Coldplay Parachute Alternative Rock 9 Sweet Tal ELO Out of the Rock 10 Release N Engelbert Release Pop 11 Jammin Bob Marle Babylon b Reggae 17 18 19 20 23 22 23 HELEllette | OLI Autowe ON Assignment Winter(1). Search (At) net gay Home Insert Page Layout Formulas Data Review View Help X ft Data Entry worksheet A B D A Comma Sep Data Entry worksheet 1 Correct the spelling errors in cell B1. Find the last cell in the worksheet and enter the text it contains into cell B4. The last cell is the intersection 1 of the last row that contains data and the last column that contains data. Use Excel's Help system to look up how to correct an error. From the results you obtain, in cell B6 briefly explain in one sentence what a tot error indicates. The main goal of this question is to show that 1 you can use Excel's Help system - not your ability to explain the error. 1 Change the tab colour of the worksheet to Green Music Collection worksheet Import the Music Collection csv file beginning at cell A2 in the Music Collection worksheet. Note that the 2 csv file uses a comma delimiter and it includes a header row. 1 Set a Print Area so that only columns A, B, C, and D will print. 1 Add a Footer that will show Page 1 of ? In the bottom centre of each page. Structuring Data worksheet 1 Change the width of column A to 14. 1 Adjust the width of columns H through N to 14. 1 Insert one cell below each of the cells AS through F5. Do not insert an entire row in the worksheet. Enter the following data in the new cells: cell A6 - Pharmaprix, cell B6 - 100, cell C6 - 56789, cell D6 - 1 67890, cell E6-78901. 1 Copy the formula in cell F5 to cell F6. 1 Name the range C3 to F10 (C3:F10) Q1_Sales Instructions - Grading Data Entry Music Collection Structund LO 3 O Auto 11 Assignment Search Away Fle Bome Insert Page Layout Hoteles Data Renew ViewHelp Comments Sh 1 Correct the spelling errors in cell B1. D Correct the spelling errors in cell B1. There are a few spelling errers here - please fixe them. Remembr to save your werk when completeed. Find the last cell in the worksheet and type the data it contains into cell B4. The last cell is the intersection of the last column and last row that contains data Use Excel's Help system to look up how to correct a ### error. From the results you obtain, briefly explain in one sentence what and error indicates in cell B6. The main goal of this question is to show that you can use Excel's Help system - not your ability to explain the error tronding Dataty Music Collection Strong EN OLT SP Loe AutoSave OM H Assignment 1 Winter() Search AO) File Home Insert Page Layout Formulas Data Review View Help 614 1 D 1 Music Collection G H 2 10 structions Music Collection a e Edhe ET FZ B @ AutoSave of B Assignment 1_Winter(1) Search (Alto) View Help G H 1 2 File Home Insert Page Layout Formulas Data Review J11 .:X fx A B C D E F Get Well Soon Pharmaceuticals First Quarter Sales 3 Custome ID # January February March Total 4 Costco 109 176,953 145,689 167,459 5 London 125 33,489 27,865 29,757 91,111 6 Pharma 101 24,543 17,654 20,646 62,843 7 Rexall 145 77,865 86,765 76,412 8 Shoppe 132 257,843 296,589 309,754 ###### 9 Walmar 121 209,563 189,076 199,654 10 11 12 13 14 15 16 17 18 19 20 instructions - Grading Data Entry Music Collection Struguring Data Read AutoSave oft Music Collection() O Search (Alt+Q File Home Insert Page Layout Formulas Data Review View Help POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv for Xfx ID A1 G 1 ID 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 B C D E F Song Performer Album Genre 1 Snowbird Anne Mur Snowbird Country 2 Kashmir Led Zeppe Physical G Hard Rock 3 Stayin' Ali Bee Gees Saturday I Disco 4 Viva la Vic Coldplay Viva la Vic Alternative Rock 5 Blue Sued Elvis Presl Elvis Presl Rock 6 Riverboat David Wil My Eyes k Rock 7 Could I Ha Anne Mur Anne Mur Country 8 Yellow Coldplay Parachute Alternative Rock 9 Sweet Tal ELO Out of the Rock 10 Release N Engelbert Release Pop 11 Jammin Bob Marle Babylon b Reggae 17 18 19 20 23 22 23 HELEllette | OLI