12 Excel_Modeling_Problems

12 Excel_Modeling_Problems - Excel Modeling Problems Rev:...

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

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

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/22/2011.

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 Right Arrow Icon
Ask a homework question - tutors are online