ACC - 38 # N-box +B-box corrects COUNTIF(B7:AT41,"...

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

View Full Document Right Arrow Icon
Problem 1-1 Name: Section: Score: 0% 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. 1. PADRE TRAVEL SERVICE Income Statement For the Year Ended June 30, 2010 Fees earned Operating expenses: Total operating expenses Net income 2. PADRE TRAVEL SERVICE Retained Earnings Statement For the Year Ended June 30, 2010 Retained earnings, July 1, 2009 Retained earnings, June 30, 2010 3. PADRE TRAVEL SERVICE Balance Sheet June 30, 2010 Assets Total assets Instructions
Background image of page 1

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

View Full DocumentRight Arrow Icon
Liabilities Stockholders' Equity Total liabilities and stockholders' equity
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
# Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*") 0 # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 38 # N-box +B-box corrects COUNTIF(B7:AT41," ") Total SUM(AV13:AV15) 38 Percentage =(AV16-AV13-AV14)/AV16 0% Notes: If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two space If number-entry or blank-entry box is incorrect, returns "*" If number-entry or blank-entry box is correct, returns single space, " " Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. I es, " " s, so that students can't enter a space in a box and have it counted as correct. If A1 = "~*", then font = red, if something else, then font = background 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.

Page1 / 10

ACC - 38 # N-box +B-box corrects COUNTIF(B7:AT41,"...

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

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