Excel Assignment

1. Add your name in empty cells of the first record, don’t change others
2. Use Format Painter to change all cells to normal format, as cell A3
3. Clear all “Not Available” texts ONLY in the Phone Number column
4. Make Full Name column after Middle Initial column and calculate all full names by merging First Name, Middle Initial, and Last Name with a space in between, no double spaces, convert to UPPERCASE
5. Make Address column after Full Name and calculate all mailing addresses by merging House Number, Pre-directional, Street, Street Suffix, and Post-directional with a space in between, no double spaces, convert to UPPERCASE
6. Insert a drop-down list to each cell in the City column. The list includes all unique city names in the City column (Hints: Copy/Paste the City column to a new sheet, use menu Data > Remove Duplicates, then sort that list A to Z; Select all cells in City column; Data > Data Validation > List and point to the list)
7. Custom sort whole table by Last Name A to Z, then by First Name A to Z
8. Copy the current sheet to two new sheets, named Excel 2A and Excel 2B
9. Find a list of whom have income less than $50,000 and live in Zip Code from 77065 to 77090
   • Filter Excel 2A sheet follow above request
   • Select and Copy data from Excel 2A sheet, then Paste to a new Excel workbook
   • Save the new workbook in .csv file format, named DIGM2325_LastFirst_Excel2A.csv
     
10. Find a list of whom occupy more than 50% at home, like Cooking and Cruises
    • Filter Excel 2B sheet follow above request
    • Select and Copy data from Excel 2B sheet, then Paste to a new Excel workbook
    • Save the new workbook in .csv file format, named DIGM2325_LastFirst_Excel2B.csv
      
11. Save your working Excel file and exit Excel

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."

"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"