If you want to limit the results further, add additional search terms that reflect the specific skills you want to test. Within its structured environment, students practice what they learn, test their understanding, and pursue a personalized study plan that helps them absorb course material and understand difficult concepts. This book covers introductory Word, Excel, Access, and PowerPoint, with an additional Windows 8 chapter. We provide you a detailed report that helps you to make better hiring decisions. The test checks application and functional skills of candidate related to excel. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time. Students go to college now with a different set of skills than they did years ago.
Sorts and Filters Sorting Table Data on One or Multiple Fields Creating, Modifying, and Removing Filters Hands-On Exercise 2: Sorts and Filters Access Versus Excel, and Relational Databases Knowing When to Use Access or Excel to Manage Data Understanding Relational Power Hands-On Exercise 3: Access Versus Excel, and Relationship Databases Access Database Creation Creating a Database Hands-On Exercise 4: Access Database Creation Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Two Tables and Queries in Relational Databases: Designing Databases and Extracting Data Objectives Case Study Bank Audit Table Design, Creation, and Modification Designing a Table Creating and Modifying Tables Hands-On Exercise 1: Table Design, Creation, and Modification Multiple-Table Databases Sharing Data Establishing Table Relationships Hands-On Exercise 2: Multiple-Table Databases Single-Table Queries Creating a Single-Table Query Specifying Query Criteria for Different Data Types Understanding Query Sort Order Running, Copying, and Modifying a Query Using the Query Wizard Hands-On Exercise 3: Single-Table Queries Multitable Queries Creating a Multitable Query Modifying a Multitable Query Hands-On Exercise 4: Multitable Queries Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions Objectives Case Study Housing Slump Means Opportunity For College Students Calculations and Expressions Creating a Calculated Field in a Query Formatting and Saving Calculated Results Hands-On Exercise 1: Calculations and Expressions The Expression Builder and Functions Creating Expressions with the Expression Builder Using Built-In Functions in Access Hands-On Exercise 2: The Expression Builder and Functions Aggregate Functions Adding Aggregate Functions to Datasheets Creating Queries with Aggregate Functions Hands-On Exercise 3: Aggregate Functions Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Four Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries Objectives Case Study Coffee Shop Starts New Business Form Basics Creating Forms Using Form Tools Using Form Views Working with a Form Layout Control Sorting Records in a Form Hands-On Exercise 1: Create and Modify forms Report Basics Creating Reports Using Report Tools Using Report Views Modifying a Report Sorting Records in a Report Hands-On Exercise 2: Report Basics Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Microsoft Office PowerPoint 2013 Chapter One Introduction to PowerPoint: Creating a Basic Presentation Objectives Case Study Be a Trainer Introduction to PowerPoint Using PowerPoint Views Typing a Speaker Note Saving As a Slide Show Hands-On Exercise 1: Introduction to PowerPoint Presentation Creation Planning a Presentation Assessing Presentation Content Reviewing the Presentation Hands-On Exercise 2: Presentation Creation Presentation Enhancement Inserting Media Objects Adding a Table Using Animations and Transitions Inserting a Header or Footer Hands-On Exercise 3: Presentation Enhancement Navigation and Printing Running and Navigating a Slide Show Printing in PowerPoint Hands-On Exercise 4: Navigation and Printing Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Two Presentation Development: Planning and Preparing a Presentation Objectives Case Study The Wellness Education Center Templates Creating a Presentation Using a Template Modifying a Presentation Based on a Template Hands-On Exercise 1: Templates Outlines Creating a Presentation in Outline View Modifying an Outline Structure Printing an Outline Hands-On Exercise 2: Outlines Data Imports Importing an Outline Reusing Slides from an Existing Presentation Hands-On Exercise 3: Data Imports Design Using Sections Examining Slide Show Design Principles Modifying a Theme Modifying the Slide Master Hands-On Exercise 4: Design Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Three Presentation Design: Illustrations and Infographics Objectives Case Study Illustrations and Infographics Mini-Camp Shapes Creating Shapes Applying Quick Styles and Customizing Shapes Hands-On Exercise 1: Shapes Smartart and Wordart Creating SmartArt Modifying SmartArt Creating WordArt Modifying WordArt Hands-On Exercise 2: SmartArt and WordArt Object Manipulation Modifying Objects Arranging Objects Hands-On Exercise 3: Object Manipulation Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Four PowerPoint Rich Media Tools: Enhancing with Multimedia Objectives Case Study Engagement Album Pictures Inserting a Picture Transforming a Picture Using the Internet as a Resource Hands-On Exercise 1: Pictures Video Adding Video Using Video Tools Hands-On Exercise 2: Video Audio Adding Audio Changing Audio Settings Hands-On Exercise 3: Audio Photo Albums Creating a Photo Album Setting Photo Album Options Hands-On Exercise 4: Photo Albums Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Application Capstone Exercises Word Excel Access PowerPoint Glossary Index Pearson learning solutions Nobody is smarter than you when it comes to reaching your students. The higher the percentage, the more questions you are likely to see on that content area on the exam. Newly designed in an easy-to-read bulleted format. Move students beyond the point-and-click. Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text. Note that you do not need this feature to use this site. Proficiency tests are designed to measure how well someone does at a certain task.
The items are numbered 1. Description This book offers full, comprehensive coverage of Excel. You can also create the custom excel skills test as per your requirement. This includes page numbers so students can skip between objectives where they feel they need the most help. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. We appreciate your input in ensuring the quality of the Microsoft Certification program. These questions cover the most essential concepts in the white pages required for students to be successful in working the Hands-On Exercises.
Do you have feedback about the relevance of the skills measured on this exam? Check with the seller before completing your purchase. Page numbers are included for easy reference to help students locate the answers. This requires students to work actively with this important vocabulary and prove conceptual understanding. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time. Simply share your course goals with our world-class experts, and they will offer you a selection of outstanding, up-to-the-minute solutions.
Your browser either does not support scripting or you have turned scripting off. You can also include skills content, your own material and brand it to your course and your institution. Include highly engaging bespoke games, animations and simulations to aid students' understanding, promote active learning and accommodate their differing learning styles. Field Object window Objects Record First principle of good database design Flat database Common field Table Second principle of good database design Normalization Data Database Navigation Pane Information Populate 1. Newly designed in an easy-to-read bulleted format.
All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. You might even provide a question or two that direct the user to create a worksheet to solve the question. We provide a certificate of completion for any that pass, and we also offer a free consolidated report for companies who want to test multiple staff members - you need to contact us to set that up. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know. The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. So, the Clear Answers and Start Over button below will not work.
For example, a proficiency test may indicate how well someone does at creating pie charts, but may not do well on PivotTables, lookup formulas, or conditional formatting. View video tutorials about the on Microsoft exams. Page numbers link the questions back to the white pages for review. Each chapter has approximately 12—15 exercises ranging from multiple choice questions to open-ended projects. Excel is a tool you can use to accomplish some tasks, but it isn't a task itself. Sometimes question from this category are asked as part of the computer operation general knowledge section of basic computer awareness test. Table of Contents Microsoft Office 2013 Chapter One Office Fundamentals and File Management: Taking the First Step 1 Objectives 1 Case Study: Spotted Begonia Art Gallery 1 Windows 8 Startup 2 Logging In with Your Microsoft Account 2 Identifying the Start Screen Components 3 Interacting with the Start Screen 4 Accessing the Desktop 4 Hands-On Exercise 1: Windows 8 Startup 6 Files and Folders 10 Using File Explorer 10 Working with Folders and Files 13 Selecting, Copying, and Moving Multiple Files and Folders 15 Hands-On Exercise 2: Files and Folders 17 Microsoft Office Software 22 Identifying Common Interface Components 22 Getting Office Help 28 Hands-On Exercise 3: Microsoft Office Software 31 The Backstage View Tasks 36 Opening a File 36 Printing a File 38 Closing a File and Application 39 Hands-On Exercise 4: The Backstage View Tasks 41 Home Tab Tasks 45 Selecting and Editing Text 45 Using the Clipboard Group Commands 49 Using the Editing Group Commands 52 Hands-On Exercise 5: Home Tab Tasks 55 Insert Tab Tasks 60 Inserting Objects 60 Review Tab Tasks 62 Reviewing a File 62 Page Layout Tab Tasks 65 Using the Page Setup Dialog Box 66 Hands-On Exercise 6: Insert Tab Tasks, Page Layout Tab Tasks, and Review Tab Tasks 68 Chapter Objectives Review 72 Key Terms Matching 73 Multiple Choice 74 Practice Exercises 75 Mid-Level Exercises 79 Beyond the Classroom 81 Capstone Exercise 82 Microsoft Office Excel 2013 Chapter One Introduction to Excel: What Is a Spreadsheet? It's the reason you always get the best out of them.
These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Move students beyond the point-and-click. Copyright © 1995 - 2015. Newly included in this is a Key Terms Matching exercise, a Collaboration Case, and Soft Skills Case for every chapter. If you prefer to not develop your own proficiency test, you should try doing a search on Google for what you need. Take only the most applicable parts of your favourite materials and combine them in any order you want.
Please use this preparation guide to prepare for the exam, regardless of its format. Students go to college now with a different set of skills than they did years ago. . You know how to convey knowledge in a way that is relevant and relatable to your class. The latest edition provides an easy-to-follow map through each chapter to help students learn, study, and review efficiently and be successful in this class and beyond. Answer choices in this exercise appear in a different order each time the page is loaded. Customise existing Pearson eLearning content to match the specific needs of your course.