### Free Educational Resources

• > Excel Project CIS 110 Excel Final Version 3
+

# Excel Project CIS 110 Excel Final Version 3

##### Rating:
(0)
Author: matthew stock
##### Description:

http://homework.plus/excel-project-cis-110-excel-final-version-3/

CIS 110 Excel Final Version 3

Project Description:
<Project Description>

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

0.000

2

Save the file as an Excel 2010/2013 workbook named Excel Final 2

0.000

3

Create a new worksheet. Name the sheet Event Costs. Set the tab color to standard Yellow.

2.000

4

Enter the following data in the specified cells:Cell A1: Donors Appreciation EventCell A2: Event BudgetCell A3: Number of Guest:Cell C3: 60

3.000

5

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

2.000

6

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.

4.000

7

Insert a row above Miscellaneous, the new row should be row 8. Type Refreshments in cell A8.

1.000

8

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.

3.000

9

Type Total per Company in cell A10. Set cell A10 to Wrap text and the text align to right.

2.000

10

In cell B10 enter a Function to add all the values for the company Signature Events. Copy the formula into cells C10 and D10.

2.000

(more)

### Analyze this: Our Intro to Psych Course is only \$329.

Sophia college courses cost up to 80% less than traditional courses*. Start a free trial now.

Tutorial