ISDS 2000 Chapter : EX2013 ChallengeYourself 3 3 Instructions 1
Document Summary
Chapter 3: using formulas and functions challenge yourself 3. 3. In this project, you will complete a vehicle-shopping workbook to compare the purchase of several vehicles. After completing the project, you can make a copy of the file and use it to compare vehicle purchases you are considering for yourself. Using the function arguments dialog to enter functions. Calculating loan payments using the pmt function. Creating formulas referencing data from other worksheets. Finding errors using trace precedents and trace dependents. Updating named ranges with the name manager. Editing and deleting names with the name manager. Download start file: open the start file ex2013-challengeyourself-3-3. The file will be renamed automatically to include your name. Use only one argument: copy the formula to the appropriate cells for the other vehicles, excel will detect a possible error with these formulas. Hint: use the smarttag while cells c11:f11 are selected and the error will be ignored for all the selected cells.