Microsoft Excel Exercise 101: Sure Balance Checkbook [PDF]

Citation preview

CAPITOL UNIVERSITY COLLEGE OF ENGINEERING Cagayan de Oro City EN44 COMPUTER FUNDAMENTALS AND PROGRAMING PLATE NO. 04



MICROSOFT EXCEL EXERCISE 101: SURE BALANCE CHECKBOOK TITLE



DATE PERFORMED: ___________________ DATE DUE



:



___________________ GROUP NO.



:



_________



SUBMITTED BY



:



EVALUATION RATING: CRITERIA



ACTUAL SCORE



Time Spent. Student adequacy of spending time to finish the computer lab activity. (10 pts) Effort. Creativity in making the computer lab activity. (10 pts) Completion of Task. Timeliness in submitting the final report before the scheduled due date. (10 pts) Reasonable Response and Information. Following specific instruction in the conduct of the activity. Shows proper sequences of the lab output and provide proper reasoning for its report. (10 pts) Neatness. Neatness, Readability and Legibility. (10 pts) TOTAL SCORE (50 pts)



________________________ STUDENT



SUBMITTED TO



:



ENGR. MARK HEINTJE A. CUANAN INSTRUCTOR REMARKS:



1ST SEMESTER



SCHOOL YEAR 2019-2020



PLATE # 04 TITLE: Microsoft Excel Exercise 101: Sure Balance Checkbook SPECIFIC OBJECTIVE/S:  Introduces formatting of cells and columns PROCEDURE: 1. 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 2. Modify column widths for columns A through F. Indicate precisely the column width as desired. Follow the steps below. Step 1: Right click on the desired column. Step 2: Select the COLUMN width. Step 3: Type the desired number of columns in the box labeled “Column Width" (e.g., 5). Step 5: Click on . Use the following widths for each column. Column A: 5 Column B: 8 Column C: 30 Column D: 10 Column E: 10 Column F: 1 Column G: 12 3. Format the numbers to show peso and cents for all entries in columns D, E, and G. Follow the steps below. Step 1: Click on the letter at the top of the column to be formatted. (The entire column should turn dark.) Step 2: Right click and Open the FORMAT menu. Step 3: Select the NUMBER option. Step 4: The NUMBER option automatically should be selected (if not, click on the tab labeled NUMBER). Step 5: Under the Category label, select the option CURRENCY.



Step 6: Under the Format Codes label, select the format –P1,234.10 which is the third choice. Step 7: Click on . 4. Format column B to enter the date of transactions. Follow the steps above but select the DATE as the category option and M/D/YY as the format codes option which is the first choice. 5. Enter the formulas below in the cells indicated. G4: G5:



=-d4+e4 =g4-d5+e5



6. Enter the information below in the rows indicated.



7. Copy the formula from cell G5 to cells G6 through G13. 8. Format cells by adding borders to every cells. 9. Your checkbook should look like the one below. Sure Balance Checkbook   Ck. #   100



08/01/2019 Shell Oil Co.



101



08/01/2019 08/04/2019 08/06/2019 08/10/2019 08/15/2019 08/20/2019 08/28/2019 09/01/2019



  102 103   104 105  



Date Item Description 07/30/2019 January Paycheck



Pink Palace Entertainment Cash (Auto Maintenance) Dr. Hiluluk (Gift) Rent Drug Sales Bail (Drug Arrest) Fiesta Bonus September Monthly Fund



Debit   1300. 2 760.5 5 20450 10000   26850 50670 50000  



Credit X 153950.1  



Balance 153950.1



 



 



152649.9



      5000               78950.55  



151889.35 131439.35 121439.35 126439.35 99589.35 48919.35 -1080.65 77869.9