Module 2 – SLP
IT MANAGEMENT AND DECISION MAKING
In this SLP you will learn how to use formulas in Excel. Below is a Quiz and Lecture to help you prepare for the SLP.
SLP 2, Lecture 1: Use Relative, Absolute, and Mixed Cell References in Formulas:
SLP 2 Review Quiz: This quiz will not count toward your grade but allows you to assess your knowledge.
SLP Assignment
Enter the text below in the cells indicated.
A1: Sure Balance Checkbook
A3: Ck. #
B3: Date
C3: Item Description
D3: Debit E3: Credit F3: X
G3: Balance
Modify column widths for columns A through F.
Format the numbers to show dollars and cents for all entries in columns D, E, and G
Format column B to enter the date of transactions.
Enter the formulas below in the cells indicated.
G4: =-d4+e4
G5: =g4-d5+e5
Your checkbook should look like the one below.
|
A |
B |
C |
D |
E |
F |
G |
|
|
1 |
Sure Balance Checkbook |
||||||
|
2 |
|||||||
|
3 |
Ck. # |
Date |
Item Description |
Debit |
Credit |
X |
Balance |
|
4 |
6/30/92 |
June Paycheck |
$1,795.86 |
$1,795.86 |
|||
|
5 |
100 |
7/1/92 |
Rent Payment. |
$42.64 |
$1,753.22 |
||
|
6 |
101 |
7/1/92 |
Plaza Theatres |
$87.34 |
$1,665.88 |
||
|
7 |
7/4/92 |
Cash (Auto Teller) |
$50.00 |
$1,615.88 |
|||
|
8 |
102 |
7/6/92 |
United Way (Gift) |
$75.00 |
$1,540.88 |
||
|
9 |
103 |
7/7/92 |
Rent |
$800.00 |
$740.88 |
||
|
10 |
7/10/92 |
Hobby Sales |
$2,500.00 |
$3,240.88 |
|||
|
11 |
104 |
7/11/92 |
Speeding Ticket |
$500.00 |
$2,740.88 |
||
|
12 |
105 |
7/12/92 |
Lawyer for Speeding Ticket |
$3,200.00 |
($459.12) |
||
|
13 |
7/14/92 |
Saving Quarter Fund |
$500.00 |
$40.88 |
|||
SLP Assignment Expectations
Upload your completed file to the SLP 2 dropbox.