Excel Homework

All the information will be in the files

Independent Challenge 2
You volunteer several hours each week with the Assistance League of San Antonio, and you are in charge
of maintaining the membership list. You’re currently planning a mailing campaign to members in certain
regions of the city. You also want to create renewal letters for members whose membership expires
soon. You decide to format the list to enhance the appearance of the worksheet and make your
upcoming tasks easier to plan.
1. Start Excel, open the file EX 3-4.xlsx from the location where you store your Data Files, then save
it as EX 3-Memphis Assistance League.
2. Remove any blank columns.
3. Create a conditional format in the Zip Code column so that entries greater than 38249 appear in
light red fill with dark red text.
4. Make all columns wide enough to fit their data and labels. (Hint: You can use any method to size
the columns.)
5. Use formatting enhancements, such as fonts, font sizes, font styles, and fill colors, to make the
worksheet more attractive.
6. Center the column labels.
7. Use conditional formatting so that entries for Year of Membership Expiration that are between
2021 and 2023 appear in green fill with bold black text. (Hint: Create a custom format for cells
that meet the condition.)
8. Adjust any items as necessary, then check the spelling.
9. Change the name of the Sheet1 tab to one that reflects the sheet’s contents, then add a tab
color of your choice.
10. Enter your name in an empty cell, then save your work.
11. Preview the worksheet, make any final changes you think necessary, then submit your work to
your instructor as directed. Compare your work to the sample shown in Figure 3-30.
Figure 3-30
12. Close the workbook, then exit Excel.
Assistance League of Memphis
Member
MT’s Candy Shop
Chip Technology
Computer Attic
Deluxe Auto Shop
Dental Associates
Dr. Mary Terese
Dunkin’ Donuts
Earl’s Restauraant
First Federal Bank
Frieendly Chevy
From Office
General Hospital
Grande Table
Holiday Inn
Ken’s Florist Shop
Lisa’s Photo Studio
Meineke Muffler
Midas Muffler
Mill Shope
Mobile One
Red Roof Inn
Reservation Innn
State University
Number of Year of Membership
Zip Code Employees Expiration Code
38256
23
2023
3
38251
175
2024
3
38263
14
2021
2
38245
17
2020
1
38287
15
2021
5
38263
12
2024
2
38238
10
2021
4
38235
45
2022
3
38267
36
2024
3
38286
17
2026
3
38211
25
2025
5
38225
538
2023
4
38246
31
2022
4
38221
75
2021
4
38241
10
2020
2
38202
5
2023
4
38256
24
2022
1
38221
22
2026
3
38205
165
2023
2
38271
11
2027
3
38210
70
2025
2
38257
42
2025
2
38212
422
2024
3
Year
2017