Introduction to Excel
Post - Assessment Activity
Essential Question:
How will understanding the fundamentals (basic skills) of MS Excel help me improve as a student?
Objective for MS Excel:
Students will become familiar with the fundamentals of MS Excel, its tools functions and how it can be used for classroom projects and in business.
E6 Sales Forescast Chart
Job Description:
As an account executive at Squeaky Clean, you have been using the sales forecast spreadsheet in presentations and planning meetings. However, you are fining that some people digest information more easily if they see it in a more visually appealing format, such as a chart or a graph.
You will apply your skills using MS Excel to use the spreadsheet data to create a column bar chart.
Skills Covered in E-6 Sales Forecast Chart
- Saving a Spreadsheet
- Using Basic Formulas
- Using the AutoFill Feature (review)
- Creating a Column Graph
- Aligning text in a Table/Chart
- Editing a Chart/Graph
Instructions:
A. Download the E-6 Sales Forecast Chart Starter Document (below).
B. Save the file to your Excel Folder in the Comp Apps Folder.
|
Downloadable Instructions:
e6_sales_forecast_chart_instruction_sheet_v3.pdf | |
File Size: | 200 kb |
File Type: |