CIS 110 Excel Final Version 3
For the purpose of grading the project you are required to perform the following tasks:
Start Excel. Download and open the file named DonorsFile.xls
Save the file as an Excel 2010/2013 workbook named Excel Final 2
Create a new worksheet. Name the sheet Event Costs. Set the tab color to standard Yellow.
Enter the following data in the specified cells:Cell A1: Donors Appreciation EventCell A2: Event BudgetCell A3: Number of Guest:Cell C3: 60
Type the data from the following figure into the range A4:D8 as shown:Cell A4: CompanyCell A5: SiteCell A6: DecorationsCell A7: EntertainmentCell A8: MiscellaneousCell B4: Signature EventsCell B5: 350Cell B6: 250Cell B7: 260Cell B8: 250Cell C4: Small World EventsCell C5: 430Cell C6: 200Cell C7: 340Cell C8: 230Cell D4: Martin EventsCell D5: 325Cell D6: 250Cell D7: 270Cell D8: 300
Set the width of column A to 13 characters.Set the width of columns B thru D to 90 pixels.Wrap text cells in range A4:D4.Set height of rows 5 through 8 to 18 characters.