Question: 4: You have several tasks for this question: 1. Sort this table by alphabetical order by first name. 2. There are some duplicated rows in

4: You have several tasks for this question: 1. Sort this table by alphabetical order by first name. 2. There are some duplicated rows in this table. a. Remove the duplicates using an Excel operation. Do not delete them manually. b. Insert a text box and place it beneath the data rows. c. In the box, explain how you removed the duplicate rows with screenshots. Describe which menus you used, boxes you checked, and which buttons you pushed. 3. Freeze the first row so that it does not move when we scroll up and down. This is helpful if we want to add lots of rows of data. 4.Inserting a new column: a. Insert a new column before column A. b. Name the column "DATE". Fill the column cells with the current date. Do not type the date into all the cells manually. Use Excel to make it faster. c. Make the font, font size, and background color match the other columns. Also center the text in the column

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 Databases Questions!