How do you is this in excel

• add a new row to the table that automatically shows the total number of bottles in stock. Use a technique that automatically adds the row to the bottom of the table and makes the calculation in one step.
• name the tableMedicines.
• make the table show only medicines that have at least 100 bottles in stock.
• sort the table bySpecialty, then sort each specialty byClinic.
• Change the orientation of the worksheet so it prints with the long edge of the paper at the top.

• Change the chart so it shows information about all three candidates.
• Make a newClustered Columnchart that shows all of the candidates and votes for the City Council B election. Position the new chart below theSchool Board Presidentchart and to the left of theMayorchart.
• Hide the legend of thea chart.
• Apply theStyle 3style to theMayorchart.
• In C22, use a function to return the highest number of votes received by any of the candidates.

• Apply theHeading 3style toB3:H3.
• InD4, use a function to combine the first name in B4 with the last name in C4, separated by a space. Copy the formula toD5:D13.
• InF4, use a function to show the last four digits of the social security number in E4. Copy the formula toF5:F13.
• SetB3:H13as aprint area.
• Make the width of column H automatically adjust to the size of the longest address.

• Extend the table to include the South and Southeast regions.
• Apply a setting that adds special formatting to theTotalcolumn.
• Format C4:G12 to be shown as dollars, and set the number of shown decimal places to zero.
• Change the table's style toTable Style Medium 7.
• AddSales Datato the workbook's category property.
• On the Overdue Fines worksheet, use a formula that theTotal Finecolumn uses to calculates each fine by multiplying the number of books checked out by the days overdue and 0.5. If there is no fine, it should display the wordsNo Fine.
• On the Books worksheet, delete the row forA Memory of Lightfrom the table. Do it in a way that doesn't leave a blank space and doesn't affect any data outside the table.
• On theBooksworksheet, useFind and Replaceto locate the ISBN containing the digits5843. Replace them with the digits4732.
• Remove both conditional formatting rules from theOverdue Finesworksheet.
• Save theBooksworksheet in theDocumentsfolder as a .csv file. Keep the default filename.

• Remove the table functionality from the table in a way that leaves the formatting intact.
• Use a function to make K4 show the total number of pies sold on Monday.
• Use a function to make K5 show the average number of Pecan Pies sold throughout the week.
• Move the chart to a new chart worksheet calledLemon Meringue Sales.
• Apply a setting to C4:G15 that formats all values 15 and lower asLight Red Fill with Dark Red Text. When completing this task, use a method that requires you to chooseLight Red Fill with Dark Red Textfrom a dropdown.
• On theAverage Highworksheet, fill in theHigh Fcolumn by multiplying the value in theHigh Ccolumn by theC_to_Fnamed cell, then adding32to the result.

• On theAverage Lowworksheet, make it so rows 1 and 2 remain visible when you scroll down.
• On theFive Largest Citiesworksheet, swap theFahrenheitchart's data over the axis.
• On theFive Largest Citiesworksheet, make aClustered Columnchart that shows theHigh CandLow Cvalues for each city. Make sure that the columns in the chart are labeled in a way that will update the chart if the values on the sheet are changed. Do not show values forHigh ForLow F.
• On theAverage Lowworksheet, make all values in theLow FandLow Ccolumns left-aligned with 1 indent.