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

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.

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 Formulashttps://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.