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.
Insert a row above Miscellaneous, the new row should be row 8. Type Refreshments in cell A8.
In cell B8 type a formula that multiplies the number of guests in cell C3 by 8.In cell C8 type a formula that multiplies the number of guests in cell C3 by 8.25.In cell D8 type a formula that multiplies the number of guests in cell C3 by 7.55.
Type Total per Company in cell A10. Set cell A10 to Wrap text and the text align to right.
In cell B10 enter a Function to add all the values for the company Signature Events. Copy the formula into cells C10 and D10.