# 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
Indent cell contents
Enter numbers with format

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