CIT 010 Index
>
Spreadsheet

The object of this assignment is to learn the basic features of spreadsheet software.

You will start with a spreadsheet that has some data entered in it already. Here is a picture of the spreadsheet. You should download this spreadsheet and use it as your starting point.

Now do the following. Whenever you are asked to do a calculation,
you *must* use a formula. Don’t just do the calculation
by hand and type the result into the spreadsheet!

Delete column B.

Make cell A1 (Sales Report-Q1), bold and left-justified.

All the region names (cells A3, A8, A12, and A17) must be italic and centered.

Make cell A22 (Grand Total:), bold, italic, and left-justified.

Make column A wide enough so that you can see all the text in its cells.

Cells B2 through G2 are centered and bold.

Cell G3 must be formatted as a percentage.

Calculate quarterly sums for each city. The cell in column E for each city should be the sum of the cells in columns B, C, and D. For example, cell F4 (Boston) is the sum of cells B4, C4, and D4.

Calculate regional sums:

- Cell E7 contains the sum of cells E4 through E6.
- Cell E11 contains the sum of cells E9 and E10.
- Cell E16 contains the sum of cells E13 through E15.
- Cell E20 contains the sum of cells E18 and E19.

Calculate the grand total: cell E22 contains the sum of cells E7, E11, E16, and E20

Cells E6, E10, E15, and E19 have a single bottom border.

Cell E20 has a double bottom border

All the numbers in columns B, C, D, and E must be formatted as currency with no decimal places.

The cells in column G will use the number in cell G3 to calculate projected income.

- Cell G7 is set to
`=E7*(1+G3)`

- Cell G11 is set to
`=E11*(1+G3)`

- Cell G16 is set to
`=E16*(1+G3)`

- Cell G20 is set to
`=E20*(1+G3)`

Note: you can

*not*use simple copy and paste to do this unless you use an absolute cell reference to G3.- Cell G7 is set to
Cell G22 is the sum of cells G7, G11, G16, and G20.

All the numbers in cells G7 through G22 are formatted as currency with two decimal places.

Change the name of the sheet to Sales Q1.

This is what the document should look like when it is finished.

Upload the finished file to Moodle. Please name your file in the form:

`lastname_firstname_3.xlsx`

For example, if your name is *Fred Bloggs*, your
filename would be `bloggs_fred_3.xlsx`

. Do *not*
put blanks in your filename, and please use all lowercase letters.