Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.2 Format Cells and Ranges: Apply Number Formats (Percentage)

Calculate the Retail Price

The numbers you entered into Column B represent the wholesale cost. That is what Charlotte’s Website paid to purchase the items that go into a fruit basket. In order to make a profit, you have to figure the retail price.

 

The retail price equals the wholesale cost multiplied by the percentage.

5. Try This: Format the Percentages

To start, select all of Column C, Markup.

Go to the Home Ribbon. Look for the Number Group and click on Percentage Style (%).

Try This, Too: Enter the Data

A standard markup percentage is 150%.

Type 150 in cells C2 through C5. Excel will automatically add the % sign.

So far so good...

Memo to Self: This is a simple list of what goes into a fruit basket. In real life, you would need to list every item including shipping and handling.