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 from the course online 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

 

Keep going...

Home -> Number