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
Get step-by-step solutions from verified subject matter experts
