Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.2 Format Cells and Ranges: Apply Number Formats (Date, Currency) Sample Data Before You Begin: These pages are based on data from a spreadsheet that we created in an earlier chapter. It is a simple spreadsheet that you can make or you can download if you wish. Try it: Create a Price Sheet Enter the Labels in Row 1. Enter the Data in Columns A and B.   Format Row 1: Bold Format Column B: Accounting. Format Column C: Percentage Format Column D: Accounting   Enter the Markup in Column C: 150%   Calculate the Retail Sale: D2=B2*C2. Please copy the formula in Cell D2 into Cells D3:D6. Calculate the Profit: E2=D2-B2. Fill that formula down, too. Keep going... Home -> Number