01-01Pr_5e_s

# Survey of Accounting (Available Titles Cengagenow)

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

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

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

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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online