Leo, Owner of Leo's Bread Company, Recently Installed Excel 2010

question 13

Multiple Choice

Leo, owner of Leo's Bread Company, recently installed Excel 2010 and created a new workbook to track sales of different types of bread.He wants to determine which types of bread are the most popular among his customers.He is particularly interested in sales of rye bread, onion rolls, and bagels.Leo has formatted the sales numbers with the Accounting number format.Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500.What Excel feature can Leo use to accomplish this?

• A)Spell checker
• B)Conditional formatting
• C)Point mode
• D)Formulas version

---

Definitions:

Capacity

The ability or power to do, experience, or understand something; often used in legal, psychological, and health-related contexts.

Forgetting

The inability to access a memory from long-term storage.

State-Dependent Memory

The phenomenon whereby information learned in a particular state of mind (e.g., mood or consciousness) is more readily recalled when in the same state.

Context-Dependent Memory

A phenomenon where individuals recall information more effectively when the context at recall matches the context during encoding, highlighting the impact of environmental cues on memory retrieval.