Assignments
Develop an Excel application support checklist based on the learning team discussion points. This activity should be completed in Microsoft Exceland submitted as an Excel spreadsheet.
Fill in your spreadsheet with content for each of the five issues, symptoms, and resolutions.
Format your assignment as an Excel spreadsheet as follows:
• Use three columns (A,B,C).
• Format each column width to 50.
• Format all cells in these columns as text.
• Set all cells to Wrap Text.
• In the first row, merge and center all cells to create your title.
o Bold text, Light Gray fill color for cell, and set text size to 16.
• In the second row, title your columns as follows in Bold text:
o Issue (Column A)
o Symptoms (Column B)
o Resolution (Column C)
Create the following charts based on the datasets in the exercise files in the Lynda.comvideo for this week. Required charts are listed below followed by the file name in the folder titled "2 An Overview of Chart and Graph Types" in the Exercise Files download section of the Lynda.com video.
• Column Chart - (2_1 Column.xlsx)
• Area Chart - (2-Area.xlsx)
• Pie Chart - (2-Pie.xlsx)
• Stock Chart - (2-Stocks.xlsx)
• Doughnut Chart - (Doughnut.xlsx)
• Radar Chart - (Radar.xlsx)