{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 4 Demo

# Chapter 4 Demo - Chapter 4 Demo Created by Travis Day Last...

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

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

View Full Document

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.

Unformatted text preview: Chapter 4 Demo Created by Travis Day Last Modified 2/26/2008 3:00 PM Workbook Description Class Demo file for Chapter 4 Worksheet Name Worksheet Description #VALUE! Applying Conditional Formatting Based on Cell Value #VALUE! Applying Conditional Formatting Based on Results of a Formula #VALUE! Applying Conditional Formatting - Order of Conditions #VALUE! Applying Conditional Formatting - Order of Conditions #VALUE! Using Relational Operators to Compare Two Values #VALUE! Using Boolean Logical Functions to Determine a Single True or False Value #VALUE! Comparing a Long List of Elements to the Same Value #VALUE! Comparing a Long List of Elements to the Same Value - Using an ARRAY #VALUE! Writing Simple IF Functions #VALUE! Writing Clear & Flexible IF Functions (by isolating assumptions) #VALUE! Nested IF's with = #VALUE! Nested IF's with >= (or <) #VALUE! Evaluating More Complex Criteria Applying Conditional Formatting Based on Cell Value Accounts Receivable Department - Customer Credit Analysis Customer Name Rule#1 Rule#2 Rule#3 Athletic Gear Corp. \$9,000 \$15,382 \$11,952 \$ 0 \$450 BA 4 15 3 TRUE FALSE FALSE Baltimore O's 39,000 10,033 7,789 0 1,950 3A 1 51 1 TRUE TRUE FALSE Baseball & More 75,000 60,009 55,342 13,892 37,500 4A 2 70 1 FALSE FALSE FALSE Canadian Ski Club 33,000 35,039 50,921 495 1,650 BA 2 43 1 TRUE FALSE FALSE Concord Pro Shop 10,000 4A 1 91 1 TRUE TRUE Everything Golf 25,000 15,221 9,483 2,899 1,250 3A 3 76 1 FALSE FALSE FALSE Lake Pro Shops 42,000 80,498 81,126 0 2,100 3A 2 87 1 TRUE FALSE TRUE Mars Dept. Store 27,000 35,354 20,666 0 213 BB 3 94 1 TRUE TRUE FALSE RG Bradley 46,000 90,970 18,343 0 2,300 3A 1 21 1 TRUE TRUE FALSE RX for Sports 15,000 5,663 3,014 0 750 2A 1 59 1 TRUE TRUE FALSE School Sports Supply 45,000 50,278 32,338 0 2,250 3A 3 91 1 TRUE TRUE FALSE Ski World 26,000 25,864 28,154 0 300 BA 2 82 1 TRUE FALSE FALSE Sneaker Kingdom 45,000 40,157 25,379 0 2,250 3A 2 71 1 TRUE FALSE TRUE Sports & Stuff 15,000 15,898 14,732 14,383 450 BA 1 67 1 FALSE TRUE FALSE Toy Kingdom 22,000 10,073 1,047 0 1,100 3A 3 14 1 TRUE FALSE FALSE Under the Sea 45,000 95,411 64,418 0 150 CB 4 79 2 TRUE FALSE FALSE US Olympic Team 20,000 5,621 6,171 0 1,000 3A 1 87 1 TRUE TRUE TRUE WWW Sports Inc. 100,000 60,009 60,354 0 500,000 5A 2 97 1 TRUE TRUE TRUE Zip & Sons 10,000 15,490 22,760 0 620 1A 2 96 1 TRUE TRUE TRUE Do any meet the rule? TRUE TRUE TRUE Do none meet the rule? FALSE FALSE FALSE Current Credit Limit Previous Year's Sales Current Year's Sales Past Due Balance Net Worth in (000) D&B Credit Rating Class D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) D&B Stress Risk Class (1 Best) Applying Conditional Formatting Based on Results of a Formula Accounts Receivable Department - Customer Credit Analysis Customer Name Rule#1 Rule#2 Rule#3 Athletic Gear Corp. \$9,000 \$15,382 \$11,952 \$ 0 \$450 BA 4 15 3 TRUE FALSE FALSE Baltimore O's 39,000 10,033 7,789 0 1,950 3A 1 51 1 TRUE TRUE FALSE Baseball & More 75,000 60,009 55,342 13,892...
View Full Document

{[ snackBarMessage ]}

### Page1 / 14

Chapter 4 Demo - Chapter 4 Demo Created by Travis Day Last...

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

View Full Document
Ask a homework question - tutors are online