Excel 2

1^st Sheet

Retail Discount Create a spread sheet that will calculate all discounted prices given below. Use absolute and relative references to the discount percentages. (note: one mixed reference in cell C4 could be copied through the range.) report all numbers to two decimal places. Show dollar signs on the top row of numbers only.

Price with discount

Belt     Price 35.00    10%    15%    20%

Jacket Price 150.00 10%    15%    20%

Pants Price 90.00      10%    15%    20%

Shirt Price 25.00       10%    15%    20%

Suit Price 425.00      10%    15%    20%

2md Sheet

Projected v. Actual Expenses Create a spread sheet below that compares projected and actual expenses by calculating a percent difference between the two. Calculate totals for the first two columns and overall percent difference. Format to match the spread sheet below. Percents should show one decimal place

Rent: Expense: 4,000           Actual Expense: 4,000.00    Percent Diff

Electricity: Expense 2,400   Actual Expenses 3,245.15    Percent Diff

Supplies: Expense 7,500      Actual Expense 7,230.95     Percent Diff

Insurance: Expense 2,000   Actual Expense 2.150.00     Percent Diff

Consultants Expense 3,000Actual Expense 2,500.00     Percent Diff

Total