ITM 301 Principles of Information Systems Module 2 SLP IT Management and Decision Making Please see the attachment for the Excel assignment No QUIZ is required.
Module 2 - SLP
IT MANAGEMENT AND DECISION MAKING
You might find it useful to review this video before doing this assignment.
Introduction to Excel Formulas
https://www.youtube.com/watch?v=wqn7mxR2Xpk
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 |
SLP Assignment Expectations
Upload your completed file to the SLP 2 dropbox.
