Apply the following tasks to the attached “Sales V2.xlsx” 1. On the “Age” Worksheet, format the table so that every other row is
shaded. Use technique that updates the formatting if you insert a new
row.
2. On the “Age” Worksheet, enter a formula in cell L2 that uses an
Excel function to return the average age of the customers based on
the values in the “CurrentAge” column.
3. On the “Age” Worksheet, sort the table to order the records by the
“CountryOrRegion” field with customer in the United States first
and customers in Canada Second. Then sort the customers in each
country alphabetically (from A to Z) by the “StateOrProvince” field.
Finally, sort the customers in each state or province in ascending
order by the “PostalCode” field.
4. On the “Category” worksheet, apply a number format to display the
number in the “Weight” column to three decimal places.
5. In Cell J3 of the “Info” worksheet, enter a formula that return the
total
OrderTotal of all “MTVH” item even if rows are added or their order
is changed.
6. On the “Info” worksheet, modify the cell formatting of cell H7 to
display the text on two lines
7. Change Authors of the current workbook to your name’s.
Best Regard