- You have imported the following information into Excel from your customer relations management system (CRM)
|Jim Jones firstname.lastname@example.org 1123 East Street Reno, NV 55434 500|
|Catherine Ford email@example.com 3432 West Street Lansing, MI 233423 600|
|Jules Brown firstname.lastname@example.org 4322 North Lane Marietta, GA 53234 1200|
- Using the data function of excel, organize the data and add it to the following header groups.
- First & Last Name
- Email Address
- Quantity (last number)
- Sort the data from the largest quantity to the smallest
- Add a Data Validation column to the right of quantity with the heading “Shipped”? Make the options available only “Yes” “No” or “NA”
- Format the data as a table.