IT MANAGEMENT AND DECISION MAKING SLP USING AN EXCEL SPREADSHEET

IT MANAGEMENT AND DECISION MAKING

You might find it useful to review this video before doing this assignment.

Calculate data with ease in Excel from LinkedIn Learning.

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.

Copy the formulas to calculate the entire G column.

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