Product Pricing Calculator Guidelines

1. Columns B and E will be formatted for currency data entry.
2. Both Column B and E can be selected by first selecting Column B, and then
holding down CTRL and selecting Column E.
3. On the Format menu, select Cells. The Format Cells dialog box will appear.
4. Click the Number tab, then under Category select Currency.
5. Next to Decimal places type or select 2.
6. Under Symbol select a monetary value symbol ($).
7. Click OK to close the Format Cells dialog box.
8. Save the file.
Formatting Cells for Currency Data Entry
1. Column C will be formatted for number data entry.
2. Select Column Heading C.
3. On the Format menu, select Cells.
4. From the Format Cells dialog box, click the Number tab, under Category select
Number.
5. Next to Decimal places type or select 2.
6. Click OK to close the Format Cells dialog box.
7. Save the file.
Entering Research Pricing Data
1. Access the online grocery shopping site:
NetGrocer: Grocery Shopping Online
Click on the “Grocery” tab to see product items to choose from.
2. From the Select an Aisle left column, under Canned Food select Fruits (a new
page will appear).
3. On the web page that appears select Mixed Fruit.
4. For practice you will use the information provided below first, then you will have
an opportunity to choose other products and enter the new product’s data into
your worksheet.
Column Heading
Row
Heading
Page 3/5
Free Download

Product Pricing Calculator Guidelines DOC

Favor this template? Just fancy it by voting!
  •  
  •  
  •  
  •  
  •  
(0 Votes)
0.0
Related Forms
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 643 Views | 4 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 555 Views | 5 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 976 Views | 15 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 1163 Views | 22 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 1059 Views | 25 Downloads