{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

12 Excel_Modeling_Problems

# 12 Excel_Modeling_Problems - Excel Modeling Problems Rev...

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

Excel Modeling Problems Rev: 10/13/08 Instructions: You may use the data in the Excel_Modeling_Data.xls file to help you work out the correct formulas for these practice problems. Note that data in that Excel file is in the different worksheets (tabs) within the workbook that correspond to each Excel function. 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 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: C4= C6= D4= 2. IF FUNCTION Dr. Craig works with many patients trying to control their weight. The patients were weighed on June 1, 2005 and also on August 1, 2005. Because she has so many patients, Dr. Craig would like to automate the process of determining the result (lost weight, gained weight, or no change) of her program. Use the IF function to create the appropriate text for the “Result” column.

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.

{[ snackBarMessage ]}

### Page1 / 3

12 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