# Excel Word

1801 words 8 pages
-------------------------------------------------

-------------------------------------------------

-------------------------------------------------
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
…show more content…

Copy cell B6 to the range C6:G6.
In cell B8, enter the following formula: Year 1 Advertising (cell B8) = 500 + 8% * Year 1 Sales or =500 + 8% * B4. Copy cell B8 to the range C8:G8.
In row 9, enter the following data: Maintenance (row 9): Year 1 = 1,605,000; Year 2 = 4,378,000; Year 3 = 5,920,000; Year 4 = 5,050,000; Year 5 = 3,200,000; Year 6 = 4,250,000.
In cell B10, enter the following data: Year 1 Rent (cell B10) = 2,700,000
In cell C10, enter the following formula: Year 2 Rent (cell C10) = Year 1 Rent * (1+12%) or =B10 * (1+12%). Copy cell C10 to the range D10:G10.
In cell B11, enter the following formula: Year 1 Salaries (cell B11) = 17% * Year 1 Sales or =17% * B4. Copy cell B11 to the range C11:G11.
In cell B12, enter the following formula: Year 1 Shipping (cell B12) = 3.9% * Year 1 Sales or =3.9% * B4. Copy cell B12 to the range C12:G12.
In cell B13, enter the following formula: Year 1 Supplies (cell B13) = 1.3% * Year 1 Sales or =1.3%*B4. Copy cell B13 to the range C13:G13.
In cell B14, enter the following data: Year 1 Web Services (cell B14) = 250,000.
In cell C14, enter the following formula: Year 2 Web Services (cell C14) = Year 1 Web Services * (1+15%) or =B14*(1+15%). Copy cell C14 to the range D14:G14.
In cell B15, enter the following formula: Year 1 Total Expenses (cell B15) = SUM(B8:B14). Copy cell B15 to the range C15:G15.
In cell B17, enter the following formula: Year 1

## Related

• ###### Final Project Auto parts word and excel
2378 words | 10 pages
• ###### Course Project
2311 words | 10 pages
• ###### Report on Job Analysis
3572 words | 15 pages
• ###### Ged 155 English Exam Unit 3
978 words | 4 pages
• ###### Apple Innovation Strategy
2410 words | 10 pages
• ###### Comparative Analysis of Kohl and J.Cpenny
912 words | 4 pages
• ###### St Dismas
1286 words | 6 pages
• ###### Flirting with Risk
1240 words | 5 pages
• ###### Case Study
1365 words | 6 pages
• ###### 1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey
936 words | 4 pages