通晓信息技术技能、概念与能力教参chapter.pptxVIP

Learning Objectives;Designing a Spreadsheet;Design Guidelines;Focus on Form;Focus on Form;Explain Everything;The Trip Sample Spreadsheet;Applying the Rules;Applying the Rules;Initial Spreadsheet;Applying the Rules;Applying the Rules;Applying the Rules;Conditional Formatting;Conditional Formatting;Distinguish Between Names;Conditional Formulas;Figuring the Amount Paid;Figuring the Amount Paid;Cost in One Currency;Cost in One Currency;Defining Names;Defining Names;Defining Names;“What If” Analysis;“What If” Analysis;“What If” Analysis;“What If” Analysis;Reusing Scenarios;Scenarios;Trip Log Table