Step through each of these bullets to format the data in the homework Excel file

By admin

Step through each of these bullets to format the data in the homework Excel file. Use Excel’s “tell me” and “help” features for support in formatting IS’ download:
Autofit the column width, all columns.
Remove duplicates.
Hide these columns:
EmployeeID
EmployeeRegionID
EmployeeRole
EmployeeSSN
CustomerT.CustomerID
CustomerT.CustomerNotes.
Rename all column headers so they are easier to read.
Cut the region name column and move it to the first column via insert cut cells.
Apply borders to the entire data range.
Apply boldface to all column names.
Fill all column header cells with yellow.
Freeze the top row of the spreadsheet.
Sort customer last name within employee last name within region name using Custom Sort (Hint: the first level is region name, the second level is employee last name and the third level is customer last name).
Format all telephone numbers with a custom format either this mask with the option Format Cells, Custom, Type: ###-###-#### or using Format Cells, Special, Phone Number.
Format the postal (zip) code with a custom format using this mask with the option, Format Cells, Customer, Type: 0#### or using Format Cells, Special, Zip Code.
Format sales as currency displaying two decimal places.
Provide an autosum of the product unit costs and add the prompt “Total:” in boldface in the column to the left of the total.
Apply a conditional format to highlight the all product unit costs greater than $500.00.
Remove gridlines.
Add this comment to row 2, employee last name, “This sales rep is doing well.”
Apply the autofilter to all columns.
Step 4: Save this spreadsheet with this title, Your Last Name – Excel Homework 1 and submit it.

Exit mobile version