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:

Click Here to Play Video

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.