Instructor’s Manual Materials to Accompany EXPLORING MICROSOFT® OFFICE 2013, VOLUME 1 EXCEL CHAPTER 4: Datasets and Tables: Managing Large Volumes of Data Available Instructor Resources Resource File Name Found Student Data various Online Instructor Resource Center Solution Files various Online Instructor Resource Center Answer Keys Online Instructor Resource Center Matching e04_answerkey_match Multiple Choice e04_answerkey_mc Concepts Checks e04_answerkey_concepts Scorecards e04b1Tips_scorecard Online Instructor Resource Center Scoring Rubrics e04b1Tips_rubric Online Instructor Resource Center Annotated Solution File e04b1Tips_annsolution Online Instructor Resource Center Scripted Lecture (Script) e04_script Online Instructor Resource Center Scripted Lecture Solution e04_script_solution Scripted Lecture Data e04_script_data PowerPoint Presentation e04_powerpoints Online Instructor Resource Center Testbank e04_testbank Online Instructor Resource Center Instructor's Manual (lesson plans incl.) e04_instructormanual Online Instructor Resource Center Assignment Sheet e04_assignsheet Online Instructor Resource Center Prepared Exam (Chapter & App) Online Instructor Resource Center Prepared Exam-Chap instruction e04_exam_chap_instruction Prepared Exam-Chap solution e04_exam_chap_solution Prepared Exam-Chap Data e04_exam_chap_data Prepared Exam-Chap Annotated Sol. e04_exam_chap_annsolution Prepared Exam-Chap Scorecard e04_exam_chap_scorecard Prepared Exam-App instruction e04_cumexam_instruction Prepared Exam-App solution e04_cumexam_solution
Prepared Exam-App Data e04_cumexam_data Prepared Exam-App Annotated Sol. e04_cumexam_annsolution Prepared Exam-App scorecard e04_cumexam_scorecard File Guide e04_file_guide Online Instructor Resource Center Instructor Resource Card e04_ircard Online Instructor Resource Center Objective Map e04_objectivesmap Online Instructor Resource Center Online Chapter Review e04_chapt_checklist Companion Website for Students Grader Project Grader-instruction e04_grader_instruction Online Instructor Resource Center Grader-solution e04_grader_solution Grader-data e04_grader_data Grader-annoted. Solution e04_grader_annsolution Grader-scorecard e04_grader_scorecard Additional Projects (Practice & Mid Level) Online Instructor Resource Center Additional Proj-Practice instruction e04_p_addproject_instruction Additional Proj- Practice solutions e04_p_addproject_solution Additional Proj-Practice Data e04_p_addproject_data Additional Proj-Practice Ann Sol. e04_p_addproject_annsolution Additional Proj-Practice Scorecard e04_p_addproject_scorecard Additional Proj-Mid Level instruction e04_ml_addproject_instruction Additional Proj-Mid Level solutions e04_ml_addproject_solution Additional Proj-Mid Level Data e04_ml_addproject_data Additional Proj-Mid Level Ann Sol. e04_ml_addproject_annsolution Additional Proj-Mid Level Scorecard e04_ml_addproject_scorecard CHAPTER OBJECTIVES When students have finished reading this chapter, they will be able to: Freeze rows and columns Print large datasets Design and create tables a table style Sort data Filter data Use structured references and a total row Apply conditional formatting Create a new rule CHAPTER OVERVIEW The students will learn how to work with large datasets and how to filter data or apply conditional formatting.