Spreadsheets
Exercise #6 | Exercise #7 | Exercise #8 | Exercise #9 |Microsoft Office includes a spreadsheet application called Excel. In this series of exercises you will explore the capabilities of this program.
6. What If Questions - Scenario Manager -Watch the Lynda.com video - Excel 2013: Essential Training with Dennis Taylor - Chapter 14 - Data Analysis Tools - Using Scenario Manager
Open the Condo Costs file and create four scenarios, one at 5%, one at 10%, one at 20% and one at 5% but a 40 year term. What is the monthly payment for each scenario? Show the scenarios to your instructor using the scenario manager for teacher check.7. Using Goal Seek - Watch the Lynda.com video - Excel 2013: Essential Training with Dennis Taylor - Chapter 14 - Data Analysis Tools - Using Goal Seek
Create the following table in excel and use the goal seek tool to find out how many yes votes are needed to pass this issue with a 2/3rds vote (66%).
% of Votes Votes YES 4478 63.90% NO 2530 36.10% Total 7008 100.00%
8. Creating a Macro - Watch the Lynda.com video - Excel 2013: Essential Training with Dennis Taylor - Chapter 15 - Introduction to Macros - Creating a Simple Macro
Use one of the excel files you have already created and create a macro that is activated using a key combination. The macro should perform several steps, not just one. Demonstrate the use of the macro you created.9. Pivot Tables - Watch the Lynda.com video - Excel 2013: Essential Training with Dennis Taylor - Chapter 13 - Pivot Tables - Creating Pivot Tables and Manipulating Pivot Table Data. Open the exercise file called Pivot Table, after you download it, then create your own pivot table of the data and include a pivot chart of the data as well. Use the Creating tab as your data. Demonstrate your ability to modify the pivot table layout in order to answer the following questions: Who was the top sales person in each region? Which sales person sold the most Captain Recliners? Which region had the highest sales? What item put this region at the top of sales?