Reference no: EM132244580

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 submissions, 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 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-2

1. EXL-2 Project. 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. Pages EX 113 to EX 172 - Project - Financial Projection Worksheet with What-If Analysis and Chart; Pages EX 185 to EX 232 - Project - Mortgage Payment Calculator with Data Table and Amortization Schedule; Pages EX 241 to EX 295 - Project - Consolidated Expenses Worksheet.

2. EXL-2 In the Lab. Complete and submit the following: Chapter 3 - Lab 1: Eight-Year Financial Projection: August Online Technology (pages EX 177 - EX 181)

3. EXL-2 Journal. Complete this week's educational journal to help review your progress so far.

SUBMISSION NOTES:

• Read every word of all instructions carefully.
• For EXL-2 Projects you will upload the following files: Kaitlyn's Ice Cream Shoppe Financial Projection; NCU Mortgage Payment Calculator; and 2018 Consolidated Expenses, Concert Venues Consolidated, Durat Theater Projected Expenses, Stage Xanadu Expenses Worksheet, Truman House Expenses Worksheet
• For EXL-2 In The Lab you will upload the following files: Lab 3-1 August Online Technology Eight-Year Financial Projection; Lab 3-1 August Online Technology Eight-Year Financial Projection Case 1, Lab 3-1 August Online Technology Eight-Year Financial Projection Case 2, Lab 3-1 August Online Technology Eight-Year Financial Projection Case 3, Lab 3-1 August Online Technology Eight-Year Financial Projection GS.

Learning Objectives -

• Use Flash Fill.
• Enter formulas using the keyboard.
• Enter formulas using Point mode.
• Apply the MAX, MIN, and AVERAGE functions.
• Verify a formula using Range Finder.
• Apply a theme to a workbook.
• Apply a date format to a cell or range.
• Add conditional formatting to cells.
• Change column width and row height.
• Check the spelling on a worksheet.
• Change margins and headers in Page Layout view.
• Preview and print versions and sections of a worksheet.
• Rotate text in a cell.
• Create a series of month names.
• Copy, paste, insert, and delete cells.
• Format numbers using format symbols.
• Enter and format the system date.
• Use absolute and mixed cell references in a formula.
• Use the IF function to perform a logical test.
• Create and format sparkline charts.
• Change sparkline chart types and styles.
• Use the Format Painter button to format cells.
• Create a clustered column chart on a separate chart sheet.
• Use chart filters to display a subset of data in a chart.
• Change the chart type and style.
• Reorder sheet tabs.
• Change the worksheet view.
• Freeze and unfreeze rows and columns.
• Answer what-if questions.
• Goal seek to answer what-if questions.
• Use the Smart Lookup insight.
• Understand accessibility features.
• Assign a name to a cell and refer to the cell in a formula using the assigned name.
• Determine the monthly payment of a loan using the financial function PMT.
• Understand the financial functions PV (present value) and FV (future value).
• Create a data table to analyze data in a worksheet.
• Create an amortization schedule.
• Control the color and thickness of outlines and borders.
• Add a pointer to a data table.
• Analyze worksheet data by changing values.
• Use range names and print sections of a worksheet.
• Set print options.
• Protect and unprotect cells in a worksheet.
• Hide and unhide worksheets and workbooks.
• Use the formula checking features of Excel.
• Format a consolidated worksheet.
• Fill using a linear series.
• Use date, time, and rounding functions.
• Apply a custom format code.
• Create a new cell style.
• Copy a worksheet.
• Drill to add data to multiple worksheets at the same time.
• Select and deselect sheet combinations.
• Enter formulas that use 3-D cell references.
• Use the Paste gallery.
• Format a 3-D pie chart with an exploded slice and lead lines.
• Save individual worksheets as separate workbook files.
• View and hide multiple workbooks.
• Consolidate data by linking separate workbooks.

Attachment:- Assignment File.rar