Excel Word
-------------------------------------------------
-------------------------------------------------
-------------------------------------------------
Shelly Cashman Excel 2010
-------------------------------------------------
Chapter 3: Lab 1
Six-Year Financial Projection
Skills
Save a workbook with a new name
Apply a theme to a worksheet
Select all cells in a worksheet
Apply bold
Enter text in cells
Change the font
Change font size
Create a formula using the NOW function
Apply the date number format
Modify column width
Modify row height
Fill a range of cells with a series
Center cell contents
Italicize text
Rotate text
Use the Format Painter
Add borders
Indent cell contents
Enter numbers with format symbols
Apply underline
Apply a custom number format
Enter formulas
Use absolute cell references
Fill adjacent cells with formulas
Copy cell contents
Create a formula using the SUM function
Create a formula using the IF function
Create a sparkline for a range of numeric cells
Change fill color
Select non-adjacent cells
Create a column chart
Move a chart to a new worksheet
Edit a chart
Insert a chart title
Format a chart
Rename worksheets
Reorder worksheets
Format worksheet tabs
Use Goal Seek
Project overview
Your supervisor in the Finance department at Med Supply Online Warehouse has asked you to create a worksheet that will project the annual gross margin, expenses, total expenses, operating income, income taxes, and net income for the next six years based on a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.
STUDENT start FILE
SC_Excel2010_C3_L1a_FirstLastName_1.xlsx (Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions
Open the file SC_Excel2010_C3_L1a_FirstLastName_1.xlsx and save the file
-------------------------------------------------
-------------------------------------------------
Shelly Cashman Excel 2010
-------------------------------------------------
Chapter 3: Lab 1
Six-Year Financial Projection
Skills
Save a workbook with a new name
Apply a theme to a worksheet
Select all cells in a worksheet
Apply bold
Enter text in cells
Change the font
Change font size
Create a formula using the NOW function
Apply the date number format
Modify column width
Modify row height
Fill a range of cells with a series
Center cell contents
Italicize text
Rotate text
Use the Format Painter
Add borders
Indent cell contents
Enter numbers with format symbols
Apply underline
Apply a custom number format
Enter formulas
Use absolute cell references
Fill adjacent cells with formulas
Copy cell contents
Create a formula using the SUM function
Create a formula using the IF function
Create a sparkline for a range of numeric cells
Change fill color
Select non-adjacent cells
Create a column chart
Move a chart to a new worksheet
Edit a chart
Insert a chart title
Format a chart
Rename worksheets
Reorder worksheets
Format worksheet tabs
Use Goal Seek
Project overview
Your supervisor in the Finance department at Med Supply Online Warehouse has asked you to create a worksheet that will project the annual gross margin, expenses, total expenses, operating income, income taxes, and net income for the next six years based on a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.
STUDENT start FILE
SC_Excel2010_C3_L1a_FirstLastName_1.xlsx (Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions
Open the file SC_Excel2010_C3_L1a_FirstLastName_1.xlsx and save the file