# 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.