Module 8: Chapter 3.
I’m working on a Excel question and need guidance to help me study.
- Assessments 1, 2, 3
- Visual Benchmark 1
- Add a chart to a worksheet
NOTE: In Assessments 1, 2, 3. When creating the formulas for the Discount and Sale Price formulas, you must use cell references. For example =K5*J5. If you do not, Excel will use table heading references that will lead to incorrect results after you sort the table.
Submit the following files:
(3) Improve one of the worksheets by adding a chart
Pick one of the homework assignments and add a chart to it. Be sure that the chart fits the kind of data being reported. Be sure your chart is complete with a title, a legend, and axis labels. Please remember that you can create a summary table based on the main table in order to create a more meaningful chart. This is something you will be doing for your Dashboard project.
NOTE: Remember that although you do not turn in all of the Skills Checks, you MUST complete all of the Skills Checks listed under To Do. To complete Assessment 3 properly, you must complete Assessments 1 and 2. The assignments build on each other, so I only need the files listed.