Question: Question 1 The worksheet in the sheet titled Answer 1 contains the Sonic Selection customer informati who register as subscribers have completed an online registration

 Question 1 The worksheet in the sheet titled Answer 1 contains

Question 1 The worksheet in the sheet titled Answer 1 contains the Sonic Selection customer informati who register as subscribers have completed an online registration form. The date that has b through this process is stored in this worksheet. Organise the data by applying the following sorting instructions to the worksheet: 1. Change the shading of the heading cells (i.e. Row 1) to a shade of your choice and make t 2. Change the "Customerld" column heading and Cell A2 to italics and use the paintbrush fo apply Cell A2's format to the rest of the cells in Column A. 3. Apply the "Freeze Pane" tool to ensure the heading row and Column A are always display down through the worksheet. 4. Sort the dataset according to the "LastName" column in ascending alphabetical order (A t 5. Remove the values from the "State", "PostalCode", "Phone", and "Fax" columns

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!