Step 1 Formatting a Cell

Step 1 – Formatting a Cell

Click on A1 cell; write Inside Washington Publication [font Stencil; size 14]

Click on A2 cell; write Three Month Projected Revenue,Expenses, and Net Income [font Times New Roman; size 12]

Insert thick box border around 2 cells

Step 2 – Insert Data in Cell

In B4 cell, write July, followed by August, and then September

In A5 cell, write Revenue and so forth as illustrated below.

Step 3 – Calculate Formula

Click on E5 cell; click AutoSum icon; Enter

Repeat the same steps for the remaining expenses; OR drag the lower right handle to calculate the Sum

Calculate the sum for all the expenses for July, August, and September

Calculate the difference between the Revenue and Total Expenses

Click the =sign and type the word Sum

Type the formula =Sum(B5-B12)

Repeat the same steps for the Net Income for August, September, and Total

Step 4 – Adding Borders to a Spreadsheet

Highlight the spreadsheet as illustrated below

Click on Outside Border icon on the Formatting toolbar

Click the All Borders button

Repeat the same steps for July, August, September, and Total

Highlight the spreadsheet and add a thick border

Step 5 – Formatting a Column

Click on the A column; drag the column to the right until all the letters in the cell are shown in its entirety

Do the same for all the columns

Step 6 – Format a Spreadsheet by Adding Colors

Highlight the entire spreadsheet

Click on Fill Color icon on the Formatting toolbar

Select White

Fill a Yellow color to the Heading, Revenue, Expenses, Total Expenses, & Net Income

Bold the words Revenue, Expenses, Total Expenses, & Net Income

Add a thick border around the words Revenue, Expenses, Total Expenses, & Net Income

Align Right the words Administrative, Marketing, Commission, and Technical Support

Step 7 – Format Column Headings

Click on July, August, September

Go to FormatCellsAlignment

Move the text arrow to 45 degrees

Highlight the cells with numbers

Click Currency Style ($) icon on the Formatting Toolbar

Highlight the column headings and Fill the color to Light Yellow

Step 8 – Add a Chart

Highlight the column headings; hold the Control key; highlight the Net Income totals for July, August, September

Click on the Chart Wizard icon on the Standard toolbar

Select the highlighted Column chart; click Next

Select Rows in the Data Range; Next button

Type the Chart title [Net Income]; Next button

Place Chart in Sheet 2; Next button

Enlarge chart by dragging the lower right selection handle to the right

Step 9 – Renaming Spreadsheets

Double click Sheet 1

Type FY02

Double click Sheet 2

Type Net Income Chart