03-03Ex_5e

03-03Ex_5e - Exercise 3-3 Name: Section: Score: 0%...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Exercise 3-3 Name: Section: Score: 0% Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. LUV CARE Income Statement For the Month Ended May 31, 2011 Revenues: Expenses: Total expenses LUV CARE Retained Earnings Statement For the Month Ended May 31, 2011 Retained earnings, May 31, 2011 LUV CARE Balance Sheet May 31, 2011 Assets Total assets Liabilities Stockholders' Equity Total stockholders' equity Total liabilities and stockholders' equity LUV CARE Statement of Cash Flows For the Month Ended May 31, 2011 Cash flows from operating activities: Net cash flows from operating activities Cash flows from financing activities: Net cash flows from financing activities Cash as of May 1, 2011 Cash as of May 31, 2011 * represents an incorrect N answer =COUNTIF(A14:H27 0 " " represents an unanswered N box - counts as an incor 51 " " represents a correct blank answer or N answer =CO 0 Total SUM(AV13:AV15) 51 Percentage =AD6/AD8 0% Notes: * represents an incorrect N answer " " represents an unanswered N box - counts as an incor " " represents a correct blank answer or N answer Total number of answers = sum of above Conditional formatting might be used but wasn't here, to Steps: Open this sheet and macro sheet Open old templated, then change color palet to this she Insert new header - change problem number and reform Copy these formulas (column AD) to new sheet. Update to new edition's names and numbers Copy new error check formulas. For N-boxes =IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC For B-Boxes =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," ")) Copy Score formula from this template to new sheet. =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10) ct N answer =COUNTIF(A14:H27,"~*") swered N box - counts as an incorrect. =COUNTIF(A14:H27," ") t blank answer or N answer =COUNTIF(A14:H27," ") swered N box - counts as an incorrect. blank answer or N answer rs = sum of above might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. hen change color palet to this sheet's ange problem number and reformat column AD) to new sheet. s names and numbers formulas. For N-boxes ",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," "))) ",IF(AC29<>sol.!AC29,"*"," ")) om this template to new sheet. OFF","",AD10) ckground color. ...
View Full Document

This note was uploaded on 05/02/2011 for the course ACC 121 taught by Professor Thomas during the Spring '08 term at Baker MI.

Ask a homework question - tutors are online