I need someone who is good in excel, it is for my data and computing course I will add an excel sheet for you to work also I will add the questions with files

Page 1 Excel Assignment 1 - Excel Basics Part 1 – The Basics Skills • Creating a new workbook • Entering data into a spreadsheet • Resizing columns to show all contents • Saving a spreadsheet Assignment 1. Open Assignment 1 workbook and apply the following instructions on the Excel Basics worksheet . 2. The workbook file should be s ave d as Excel file by using the following name YourName _YourSurname_Assignmen t1. (Ex: Ahad_Suleymanli_Assignment1) [1 point] 3. Enter the following information in cells A1 – C9. Replace yourname with your first letter of name and full last name . [1 point] Name Genre Number of Songs J Smith Blues 50 B Jhon Country 110 S Spade Jazz 200 F Z ack Blues 1400 F Zappa Alternative 2300 J Smith Jazz 150 B Boen Blues 75 Yourname Blues 800 4. Ensure that all the information is visible within the column boundaries . This will require you to resize columns. (One way to resize the column is to hover your mouse between the letter column headers (A and B) until your cursor looks like an arrow pointing left and right, then simply double click.) Your spreadsheet will look as follows in Excel. A B C 1 Name Genre Number of Songs 2 J Smith Blues 50 3 B Jhon Country 110 4 S Spade Jazz 200 5 F Za ck Blues 1400 6 F Zappa Alternative 2300 7 J Smith Jazz 150 8 B Boen Blues 75 9 A Suleymanli Blues 800 Page 2 Part 2 – Basic Formatting and Spreadsheet Manipulation Skills 1. Add row s and column s to an existing spreadsheet 2. Reformat data (center, currency style, bold, text color) 3. Work with a simple formula (product) Assignment 1. Continue to work on the Excel Basics work sheet . 2. As show n below: a. To enter new rows or columns, simply click on the row or column header to select the whole row or column. Then right click with the mouse and choose insert . b. Add the new row between the current 7th and 8th rows for S Walker with the data that’s shown below . c. Add a new column between the current A and B columns for displaying the gender of each person as shown below . Enter your gender in the last row. A B C D 1 Name Male/Female Genre Number of Songs 2 J Smith F Blues 50 3 B Jhon M Country 110 4 S Spade F Jazz 200 5 F Z ack M Blues 1400 6 F Zappa M Alternative 2300 7 J Smith F Jazz 150 8 S Walker M Alternative 1000 9 B Boen M Blues 75 10 Yourname M/F Blues 800 [1 point] 3. Apply Center Alignment to B , C, and D columns. Do this by selec ting the column s and clicking the Center Alignment command (button) on the ribbon. [1 point] 4. Make your data bold for the first row, the column headings (ensure that the data all remains visible within the column boundaries). [1 point] 5. Apply Blue/Accent 5, Lighter 40% as font color for the first row . [1 point] 6. Apply Comma style to th e format of the data in column D with no decimal places showing . [1 point] Page 3 7. Add two new columns right after the "Number of Song" column with the following names: "Unit Price" and "Total Cost". (will be in E and F columns.) Apply Azerbaijani manat to these two columns' data as currency type where the ( ₼ ) sign is shown . [1 point] 8. Actually, a ll tunes are ₼ 0.99, so enter that value for all rows in column E. You can copy quickly by using the AutoFill . Just, hold from fill handle (the right bottom corner of the active cell ) and drag it to down . [1 point] 9. Calculate Total Cost (column F) as column D times Column E . So, create the formula by using one of the arithmetic operators in Excel. Use the AutoFill to apply your formula to all available rows in Total Cost. (F1:F10) [1 point] 10. Add gridlines to only A1: F10 cell range by using All Borders option from Borders tool in the Fonts group on the Home Tab . [1 point] 11. Now you are going to c hange the page layout to landscape (it’s portrait by default) . Do this by clicking the Page Layout Tab on the ribbon and then click to the Orientation tool in Page Setup to c hoose Landscape instead of Portrait . (Only for Excel Basics worksheet .) [1 point] 12. Apply the relevant math function in cell F11 to get the total value for the Total Cost column . [1 point] 13. Ensure that the data is all visible within the column boundaries . Change the cell size if it’s needed. [1 point]