Understanding And Demonstrating Excel

MS Excel Assignment PART I: In a 1-2 page paper explain the following in APA format: Explain the following in narrative form: How is excel used to manage and analyze data? What are your top tips for increasing efficiency when creating or editing Excel workbooks? Consider shortcuts, custom macros, and features like Quick Access Toolbar customization. What are the steps to rename a worksheet within a workbook? What are the methods for protecting a workbook or worksheet with a password? What is the difference between relative and absolute cell references in formulas? What are the basic steps to create a chart in Excel? PART II: Create an Excel worksheet: On Tab 1: Create one column with ten numbers Create a formula to sum the 10 numbers Create a formula to average the 10 numbers Create a chart to represent the data On Tab 2: Illustrate a column chart Illustrate a Line or Bar chart Illustrate a Pie chart For the above include titles and labels Submission instructions: You should submit both Excel and Word file for review. You should cite sources for the word submission. No need to cite information for excel file. Feel free to make the chart interesting and informative, including using pictures, graphs, colors, etc.