CSCE 220 - Lab Assignment #5Lab date October 20Due November 2Learning Objectives:This lab will focus on Excel. At the end of this lab assignment, the student should feel comfortable with:a) creating charts for single and multiple data seriesb) creating 3-D charts for single and multiple data seriesc) using OLE, Integrating Word and Excel d) sorting tablese) creating a macro to automate tasksCheckbook register (continued) - Charting in Excel: 10 pointsStart with the checkbook register from Lab 4. To reduce clutter in the charts, changes the labels in C54, C55, and C56 to read "August", "September", and "Combined".For each chart follow requirements:a) Use legends when necessary to identify areas on your chart. Delete unnecessary legends when their information is available else where on the chart.b) Give each chart and each axis a title describing what it is trying to display.c) Make sure all the categories (x-axis) are visible. You may need to resize your chart to do this.d) Rename the sheet to reflect its contents.e) Add "Prepared by: your Name" to each printed sheet.Create the following charts:1. Create an embedded side-by-side horizontal bar chart that shows the expenses for August and September for each of the spending categories. Add a text box and arrow commenting that other expenses increased in September.2. An embedded 3-D pie chart showing the percentage of total expenses each category was showing the combined expenses for the two months. Rotate the chart 150 degrees so that the rent's pie slice is in front. (Hint: Ask for help on "pie charts, formatting".) Explode the pie slice for student loans.3. On a separate sheet create a 3-D stacked column chart show monthly expenses in August and September for each of the categories. Rename the chart sheet.Use print preview to make sure the first 2 charts will print on the same page. Print those two charts and then print the chart for part 3 on its own pageTurn in these sheets during the lab.OLE: Integrating Word and Excel. 10 pointsPractice 7, page 189, Excel Chapter 4.For this exercise you will write a memo with Word. Then you will add the Excel table and one of the charts you created. It will be helpful to save your memo frequently in case of major problems.1. Create a memo with Word:a) Start Word.b) Create a memo similar to the attached sample. Insert "Auto Date and Time". Add 3 blank lines where the table and chart will go.c) Save the memo on the same disk as your spreadsheet.2. Copy the table from the spreadsheet to the memo:a) Select the data table in the spreadsheet and "copy it".Page 2 CS220 - Lab Assignment # 5Due: November 2, 2000b) Switch to Word.c) Place the cursor at desired location for the table.d) Select Edit : Paste Special from the menu. Select "Paste Link" and "Microsoft Excel Worksheet Object" and click "OK". The table should be pasted into the memo.e) Test by double clicking on the table. An Excel window should appear. You should be able scroll around in the original spreadsheet. Then finished, click on the Word memo outside of the window to switch back to Word. (Save!)3. Copy the chart from the spreadsheet to the memo:a) Switch to Excel. b) Select the pie chart and "copy it".c) Switch back to Word. Following the procedure in 2. d). Be sure to use "Paste special" and the "Paste link". This time paste it as a "Microsoft Excel Chart Object". Test by double clicking on the chart and scrolling around the spreadsheet. (Save your work!)4. Spells check your memo.5. Print the memo:a) Use print preview to make sure the whole memo will fit on one page. If there is a problem, double click on the chart; resize the chart in Excel and switch back to Word.b) Center the chart on the page horizontally by dragging the chart sideways.c) After everything is perfect, print the memo. (Don't forget to save again.)Internet - Excel - Sorting 10 pointsCreate your own table with the names of Movies that you have seen (in Excel). For each movie, include the movie title, leading actor/actress, genre, year released, whether you liked it or not. If you can't think of any favorite movies, visit the Internet movie database or your local video store.Copy table twice on the same worksheet. a) Sort your second table by name of movie (alpha order)b) Sort your third table by genre (alpha order) and then by year (newest first) and then by Lead Actor/Actress (alpha order).Print one page (no gridlines). Add name, section, lab #, as a "footer".Excel - Macros 10 pointsFavorite MoviesMovie Title Lead Actor/Actress Genre Year Released Liked/Disliked?Shakespeare in Love Joseph Fiennes Romance 1998 DslikedBraveheart Mel Gibson Drama 1995 LikedBatman and Robin George Clooney Science Fiction 1997 DislikedEmpire Strickes Back Harrison Ford Science Fiction 1980 LikedIndependence Day Bill Pullman Science Fiction 1996 LikedMars Attacks! Jack Nickolson Science Fiction 1996 DislikedReturn of the Jedi Carrie Fisher Science Fiction 1963 LikedStar Wars Mark Hamill Science Fiction 1977 LikedTitanic Leonardo DiCaprio Romance 1997 LikedPage 3 CS220 - Lab Assignment # 5Due: November 2, 20001. Add the following records to the first table that you created above:2. Add "Prepared by: Your name" to the spreadsheet as a "footer".3. Create a macro to sort the table by Lead Actor/Actress (alpha order), then by genre (alpha order), then by year (newest first).4. Create a macro that prints the table.Important things to remember when creating your macros:- Save and make a backup copy of your spreadsheet before creating the macros.- Practice the steps you will record before creating the macro.- Use the default absolute cell (not relative) addressing when creating macros.5. Use your macros: In order to verify your macro is valid, sort your table on one of the columns. Then use your macro to sort by genre, etc., then use your print macro to print the sorted table.4. Print a copy of your macro module(s):From Tools: Macro:Macros… select a macro. In the dialog box click the edit button and print the Module code. If your macros are different modules, print both modules.What to turn in:For each lab assignment:- Type your name, section number and the assignment number on the every page- Staple multiple pages together- Clearly label your answers1. Checkbook register:Two printouts: one with two charts, one with 1 chart. : Turned in during the lab (completed or not completed)2. OLE: Turn in memo with table and chart (one page)3. Internet - Excel - Sort: