Introduction to MS Excel
E-4 Top Selling Products
Unit 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.
E-4 Top Selling Products
Job Description:
You have been hired by Jazz My Wheels, Inc, to create spreadsheet consisting of collected sales data. The company will use the spreadsheet to compare the data and identify the top-selling products in ranking order. This spreadsheet will be used to plan inventory for the rest of the budgetary year.
Skills Covered in E-4 Employee Roster
-Saving a Spreadsheet
-Using AutoSum Function
-Using the AutoFill Feature to complete a number sequence
-Formatting Cells
A. Instructions:
e4_top_selling_products_instruction_sheet_v4.pdf | |
File Size: | 111 kb |
File Type: |
B. No Starter Document, Open a Blank Excel Workbook
How? See information below this line...
Help with Step 1:
How to Open a Blank MS Excel Worksheet:
On you computer's desktop there should be a shortcut to open MS Excel.
Once Excel is open, select the Blank workbook as it is pictured below...
Help with Step 3: Column Width
Help with Step 7: Auto Fill
Watch the video for help on how to auto fill as per the instruction in Step 7.