### 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)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial