05.2_Excel_Modeling_Problems

# 05.2_Excel_Modeling_Problems - Excel Modeling Problems Rev:...

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

Excel Modeling Problems Rev: 07/26/06 Instructions: You may use the data in the Excel_Modeling_Data.xls file to help you work out the correct formulas for this homework. Note that data in that Excel file is in the different worksheets (tabs) within the workbook that correspond to each Excel function. Deliverable Format: For each of the required cells below, type in the correct formula. Hint: A convenient way to do this would be to download the Excel file, debug the formulas in the Excel file, and paste in the formulas from the Excel file (formula bar) into a Word document. Print this document to hand in during class. Handwritten assignments will receive no points when the assignment is graded. 1. CELL REFERENCES Create the formulas necessary to produce to the Tax and Total amounts shown in columns C and D. A B C D 1 Sales Tax Rate 0.0725 2 3 OrderNo Subtotal Tax Total 4 1234 \$891.00 \$64.60 \$955.60 5 1235 \$543.00 \$39.37 \$582.37 6 1236 \$634.00 \$45.97 \$679.97 7 1237 \$231.00 \$16.75 \$247.75 Requirement: Create the formulas for the following cells:

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This homework help was uploaded on 04/17/2008 for the course ISYS 210 taught by Professor Ball during the Winter '08 term at BYU.

### Page1 / 3

05.2_Excel_Modeling_Problems - Excel Modeling Problems Rev:...

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

View Full Document
Ask a homework question - tutors are online