01-01Pr_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
Problem 1-1 # Incor ect N-box and B-box entries COUNTIF(B7:AT41,"~*") Name: 0 Section: # N-box Incor ects due to blanks COUNTIF(B7:AT41," ") 38 Score: 0% # N-box +B-box cor ects COUNTIF(B7:AT41," ") 0 Total SUM(AV13:AV15) 38 Answers are entered in the cel s with gray backgrounds. Percentage =(AV16-AV13-AV14)/AV16 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 incor ect answer. Notes: If number-entry box is blank (this would be an incor ect answer for N-boxes), er or check returns two spaces, " " If number-entry or blank-entry box is incor ect, returns "*" 1. If number-entry or blank-entry box is cor ect, returns single space, " " PADRE TRAVEL SERVICE Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as cor ect. Income Statement
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

01-01Pr_5e_s - Problem 1-1 Incorrect N-box and B-box...

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