# Spreadsheets Sample Questions - 1 ) W rite the formula that...

This preview shows pages 1–3. Sign up to view the full content.

1 ) Write the formula that occurs in cell B6 =PMT(B3/12,B4,B2) PMT(interestrate, term, amount borrowed) 2) Write the formula that appears in B7 3) Write the formula that appear in B2

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
A B C F E 1 Total Features 10 Cost Multiplier 110% 2 Hours Per Feature 20 3 Cost/Hour F1 4 Base Hours 2000 5 Base Cost/Hour \$ 35.00 6 Total Hours F2 7 Total Cost F3 8 9 10 For this problem you will use a spreadsheet to determine how many features to include in a piece of software your company is developing. You will need fields and labels for Total Features (a number input), Hours/Feature (a number input), Cost/Hour ( F1 ), Base Hours (a number input), Base Cost/Hour (a currency input), Total Hours( F2 ) and Total Cost (F3). You will also need to have a static field labeled Cost Multiplier (a percentage input). Cost / Hour ( F1 ) is \$60.00 if Total Features is 10 or more, \$45.00 if Total Features is 5 or more, otherwise it is \$25.00 Total Hours (F2) is Hours/Features times Total Features plus Base Hours Total Cost (F3)
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 12/06/2010 for the course CS 170 taught by Professor Ganu during the Spring '09 term at Rutgers.

### Page1 / 6

Spreadsheets Sample Questions - 1 ) W rite the formula that...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online