Reference no: EM132242476
Assignment -
STUDY NOTES: In order to ensure your complete preparation for Microsoft Certification, you should complete all of the step-by-step projects throughout the textbook. Completing the entire textbook is how you will learn the work and be prepared when your certification time comes. However, we have limited time in our curriculum - so, even if a task is not explicitly assigned, you should take the time to review it.
These helpful tips will ensure you get started on the path to success!
- Before beginning, set your system to English (United States). This is because the textbook's instructions require a certain measurement format that will not work properly if set to English (Canada).
- As mentioned, do every task, on every page, even if not explicitly assigned. The instructors may ask to see your work at any time to ensure that you are getting the most out of your time.
- Do not skip steps, or you will find yourself confused and frustrated.
- Read and double-check each step carefully.
- Please see the Do & Submit section below for which In the Labs to submit.
- The required Data Files are available for download on the Course Page.
Practice - In addition to completing all of the required exercises and assignments below, you should review and attempt some or all of the Apply Your Knowledge, Extend Your Knowledge, and Expand Your World exercises at the end of each chapter ("Module"). These practice exercises will not be submitted or evaluated.
Data Files - For any data files that the textbook asks you to open, you can get these in the Resources section for this week. Please be sure to download these files to your computer, and then extract the folder before attempting to use the files. If you do not extract the folder first your work will not save properly.
In order to extract the files, right-click on the folder name and choose "Extract All" (please note: some extractors may say "Extract" or "Extract Here". These will do the same thing.)
DO & SUBMIT -
EXL-1
1. EXL-1 Projects. Upload the step-by-step projects that you have completed while reading along with each of the assigned chapters for this week. You will receive the correct answers upon submission. These assignments are evaluated on completion, not accuracy. It is your responsibility to review the chapter work solution files and contact your instructor if you need help or clarification. Page EX 1 to EX 48 - Project - Personal Budget Worksheet and Chart; Page EX 57 to EX 105 - Project - Worksheet with Formulas and Functions
2. EXL-1 In The Lab. Complete and submit the following:
Chapter 2 - Lab 1: Insurance Premium Worksheet: Aylin Insurance (pages EX 109 - EX 110)
3. EXL-1 Journal. Complete this week's educational journal to help review your progress so far.
Learning Objectives -
- Use a touch screen.
- Perform basic mouse operations.
- Start Windows and sign in to an account.
- Identify the objects on the Windows 10 desktop.
- Identify the apps in and versions of Microsoft Office 2016.
- Run an app.
- Identify the components of the Microsoft Office ribbon.
- Create folders.
- Save files.
- Change screen resolution.
- Perform basic tasks in Microsoft Office apps.
- Manage files.
- Use Microsoft Office Help and Windows Help.
- Describe the Excel worksheet.
- Enter text and numbers.
- Use the Sum button to sum a range of cells.
- Enter a simple function.
- Copy the contents of a cell to a range of cells using the fill handle.
- Apply cell styles.
- Format cells in a worksheet.
- Create 3-D pie chart.
- Change a worksheet name and sheet tab color.
- Change document properties.
- Preview and print a worksheet.
- Use the AutoCalculate area to display statistics.
- Correct errors on a worksheet.
Attachment:- Assignment File.rar