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

Now you’re on your own. include a short summary of this section with plots in your lab report. write a matlab script file to do steps (a) through (d) below. include a listing of the script file with your report. 1 the soundsc(xx,fs) function requires two arguments: the first one (xx) contains the vector of data to be played, the second argument (fs) is the sampling rate for playing the samples. in addition, soundsc(xx,fs) does automatic scaling and then calls sound(xx,fs) to actually play the signal. mcclellan, schafer, and yoder, dsp first, 2e, isbn 0-13-065562-7. prentice hall, upper saddle river, nj 07458. c 2015 pearson education, inc. 4 mcclellan, schafer and yoder, signal processing first. prentice hall, upper saddle river, new jersey, 2003. c 2003 prentice hall. (a) generate a time vector (tt) to cover a range of t that will exhibit approximately two cycles of the 4000 hz sinusoids defined in the next part, part (b). use a definition for tt similar to part 2.2(d). if we use t to denote the period of the sinusoids, define the starting time of the vector tt to be equal to t , and the ending time as ct . then the two cycles will include t d 0. finally, make sure that you have at least 25 samples per period of the sinusoidal wave. in other words, when you use the colon operator to define the time vector, make the increment small enough to generate 25 samples per period. (b) generate two 4000 hz sinusoids with arbitrary amplitude and time-shift. x1.t / d a1 cos.2