# 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

• ###### Shaped by the Word
2221 words | 9 pages
• ###### Word Order in a Noun Phrase and English Anaphors
898 words | 4 pages
• ###### Microsoft Office and Word
3054 words | 13 pages
• ###### COUN 711 biblical word study
2172 words | 9 pages
• ###### The Sacred Words: Elements of Poetry
1515 words | 7 pages
• ###### The Word History Transformation of Marriage - Answers
1969 words | 8 pages
• ###### Excel Logistics
2289 words | 10 pages
• ###### Final Project Auto parts word and excel
2378 words | 10 pages
• ###### The F Word
934 words | 4 pages
• ###### Marketing Planning for Surf Excel in Pakistan
3765 words | 16 pages