{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Survey of Accounting (Available Titles Cengagenow)

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Exercise 3-3 * represents an incorrect N answer =COUNTIF(A14:H27,"~*") Name: 0 Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ") 51 Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ") 0 Total SUM(AV13:AV15) 51 Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8 Cells with non-gray backgrounds are protected and cannot be edited. 0% A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes: * represents an incorrect N answer " " represents an unanswered N box - counts as an incorrect. " " represents a correct blank answer or N answer LUV CARE Total number of answers = sum of above Income Statement Conditional formatting 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. For the Month Ended May 31, 2011 Revenues: Steps: Open this sheet and macro sheet Expenses: Open old templated, then change color palet to this sheet's
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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

{[ snackBarMessage ]}