Spreadsheets Sample Questions

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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)
Background image of page 2
Image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online