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

  • 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