03-03Ex_5e_s

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 cor ect blank answer or N answer =COUNTIF(A14:H27," ") 0 Total SUM(AV13:AV15) 51 Answers are entered in the cel s with gray backgrounds. Percentage =AD6/AD8 Cel s with non-gray backgrounds are protected and cannot be edited. 0% A red asterisk (*) wil 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 format ing might be used but wasn't here, to hide some of the er or check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. For the Month Ended May 31, 2011
Background image of page 1

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

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

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

Page1 / 2

03-03Ex_5e_s - Exercise 3-3 Name Section Score 0 Instructions Answers are entered in the cells with gray backgrounds Cells with non-gray

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online