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

question 29

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.
-After Leo enters the sales numbers into the cells,he decides he does not want the fixed dollar sign to appear on the far left of the cell,separated by spaces from the actual value.He would prefer that the dollar sign appear immediately to the left of the first digit of the value.To specify a floating dollar sign,which of the following formats should Leo apply?

• A) Comma style
• B) Percent style
• C) Currency style
• D) General number

---

Definitions:

Currency

A system of money in common use, especially in a nation.

PaymentAmt

A variable name, often used in coding to represent the amount of payment in financial transactions.

Number

A basic data type used in programming and mathematics, representing integers, floating point values, or other numeric forms.

Total Row

A row in a datasheet or table that calculates and displays the sum, average, or other aggregates of numerical data in a column.