Students will also prepare to take the MOS Excel Associate (MO-200) exam. Teachers and students will still be able to see the results from the assignments and access the submitted assignments. Students can download guided instruction from LabSim to execute the tasks within Microsoft Excel. Unlike other assignments, these live projects are done using an installed version of Microsoft Excel where students can practice what they have learned from the simulated labs. Ch 6: MO-200 (Excel Associate) Practice ExamsĬhapter 6 introduces the auto-graded live projects within Excel. This chapter explains how to customize tables, and format tables based on conditions using the conditional formatting tool. Tables are an effective way to organize data within Excel and students will learn how to use them effectively. Ch 5: Simple Data AnalysisĬhapter 5 explores data analysis by introducing charts, their different types, and how to format charts to effectively present data. This chapter concludes by covering error messages within Excel. This chapter also explores advanced functions like relative and absolute references, named cells and ranges, logical functions, and the IF function. Ch 4: Formulas and FunctionsĬhapter 4 discusses the effectiveness of basic formulas and functions, instructing students to use AutoFill options, mathematical operator functions, text functions and concatenation. This chapter concludes by discussing cell formatting options, including numbers, cells, styles, colors, and borders. Students will learn how to change properties for protection, data validation, and document printing. It covers how to organize and enter data, use copy and paste and work with larger data sets. Ch 3: Excel BasicsĬhapter 3 teaches how to manage worksheets in excel workbooks, build spreadsheets using templates and themes, and import external data. This chapter concludes with practicing how to insert and format objects such as shapes and images. Students will learn to print files as well as navigate and search documents within Microsoft Office. It also covers how to customize the user's view and options. Ch 2: Common Office FeaturesĬhapter 2 explores common features across Microsoft office products such as the ribbon and the backstage view. It also introduces keyboard shortcuts as well as tips for Mac and Chromebook users. It discusses the course objectives, and how to use the lab simulations for effective learning. Chapter 1 introduces the TestOut Excel Pro course, starting with an introduction to Microsoft Office and Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |