Reference no: EM133791220

MODULE - SPREADSHEETS

ASSIGNMENT:
This assignment will cover practicing the basics of spreadsheets with two types of sheets you might use in your studies or personal life. Use this opportunity to get familiar with using the spreadsheet tools to enter and format data in ways that makes the data easy to review and kept up to date using the power of formulas and functions.

Follow the instructions included below to produce two spreadsheets:

Checkbook Registers (sslab1)
For this sheet, sslab1, is a simple checkbook register that should follow the detailed instructions below including format and formulas. The goal is to keep a running total of how much money is in the account as transactions change over time.

Your Choice
The second spreadsheet can be any of your choice, but you must include the basic topics and functions as-instructed below.

Spreadsheets Part 1 (sslab1, Check Register):

This activity requires you to create a new spreadsheet and perform basic tasks such as entering labels and values, formatting, relative replication, etc. Follow the instructions exactly for full credit.

Start new spreadsheet

In cell A1, type CHECK # and press ENTER

Change the width of column B to 20 characters and center PAYEE in cell B1.

Note: This is 20 characters but not all software packages use the same unit of measure so just be sure to achieve the desired result using whatever spreadsheet software you use.

Move the cell pointer to cell B1
On the Home menubar, select Format, then Column Width
Enter 20 and click OK
Type PAYEE in cell B1 and press ENTER
Click on the align center icon

Add the labels AMOUNT in cell C1, DEPOSIT in cell D1, and BALANCE in cell E1

Right justify AMOUNT, DEPOSIT, and BALANCE:
Select cells C1:E1
Click on the right align icon

Make all of your headings bold.
Use your mouse to highlight all of the column headings (A1:E1)
Click the Bold icon on the toolbar

Left justify the check numbers:
Use your mouse to select the range A2:A9 and click the align left icon

In cell A10 type in TOTALS press ENTER
Then select cell A:10 again and click on B (near Fonts) to bold the label

Format columns C, D, and E to show currency to 2 decimal places
Block-select all the cells you want to format (C2:E10)
Then click on Number → Currency (and set decimal places to 2 if needed)

Put your name in cell D12

Put borders around the cells of the spreadsheet in range A1:E10
Use the mouse to highlight cells A1:E10
Click on the Borders button (in the Fonts section)
Under Line Arrangement, select "All Borders"

To keep the balance of the register, we will use a mathematical formula to compute the balance:
We will assume that this is a new account and there was not a balance in the account when the
$1000 was deposited; therefore, enter 1000 in cell E2
In English, the formula that we need to compute the balance for each line would read like this:
New balance = old balance - checks written + deposits
Translated into cell references, the formula is: E3=E2-C3+D3
Therefore, in cell E3, enter the formula =E2-C3+D3 and press ENTER
Alternatively, you can type the = in cell E3, then click cell E2, enter the -, click cell C3, enter the +, click cell D3, and press ENTER
Check your work: the value $921.50 should appear in cell E3

Copy this formula down the E column for all cells between row 3 and 9:
Option 1: Click on cell E3, Select Copy, highlight cells E4:E9, select Paste
Option 2: Use your mouse to click on the lower left hand corner of cell E3 then click and drag down to cell E9 to use relative copying for each cell selected.
Check your work: the value in cell E9 should be $882.00

It seems you got excited and purchased a used computer from a friend at a really great price. You then decided to network your old and new systems together, so you purchased additional computer equipment from the local computer shop. In addition, you stopped off at the local watering hole and bought a couple of cases of refreshments to help you hook up and re-configure your new network.

Unfortunately, you neglected to enter these transactions. When you realized what you had done, you had to make an immediate deposit to cover your expenses. Because all the surprise expenses were after the check to the cable company, you will need to do the following steps to find your correct balance:.
Insert 4 blank rows after the check to the cable company (row 9) and before the TOTALS line:
Move the cell pointer to select row 10 and select Insert and/or Sheet-rows four times

This activity requires you to apply your newly acquired/reviewed spreadsheet skills in something useful for you or someone you know in a real-world scenario.

You are not required to include all covered topics, but you must include the following:

Column labels
Row labels
At least 5 rows of data
Sum of at least one column or row
Calculate with a function besides SUM.
(Suggestion: use AVERAGE, MAX, or MIN)
Resize columns wide enough to view all data and text
Save the file as something notable (spreadsheet2?)

Note: You only need to demonstrate use of a spreadsheet in a real-world application. Perhaps you could do a personal budget or one for a club or team. You could use data you recorded from an experiment or a survey or data from another course. Be sure everything is neat and easy to read.