Case 2-1 Leo,owner of Leo's Bread Company,recently Installed Excel 2013 and Created

question 56

Multiple Choice

Case 2-1
Leo,owner of Leo's Bread Company,recently installed Excel 2013 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:

Simplify

The process of reducing an expression to its simplest form, making it easier to understand or solve.

\(8^x\cdot 8^{x-1}\)

An expression that can be simplified to \(8^{2x-1}\) using the properties of exponents.

\(10,000(1.07)^{4t}\)

An exponential growth equation, where \(10,000\) is the initial quantity and \(1.07\) is the growth factor applied every period \(t\), scaled by a factor of 4.

\(10,000(1.09)^{3t}\)

An exponential function, often used in finance to calculate compounded interest or investment growth over time.