1 Start Excel, and then on the opening screen, in the lower left, click Open Other Workbooks . Click Browse , and then navigate to your student data files for this chapter. Open the file e01_1F_Balance_Sales . Click the File tab , on the left click Save A s, and then click Browse . In the Save As dialog box, navigate to your Excel Chapter 1 folder, and then using your own name, save the file as Lastname_Firstname_1F_Balance_Sales
2 Merge & Center the title and the subtitle across columns A:F . Apply the Title and Heading 1 cell styles respectively.
3 Make cell A1 the active cell, and then check spelling in your worksheet. Correct Silde to Slide . Widen column A to 180 pixels and columns B:F to 95 pixels .
4 In cell E4 , construct a formula to calculate the Total Sales of the Balance Pillow by multiplying the Quantity Sold times the Retail Price . Copy the formula down for the remaining products.
5 Select the range E4:E10 , and then use the Quick Analysis tool to Sum the Total Sales for All Products , which will be formatted in Bold. To the total in cell E11 , apply the Total cell style.
1 Start Excel, and then on the opening screen, in the lower left, click Open Other Workbooks . Click Browse , and then navigate to your student data files for this chapter. Open the file e01_1F_Balance_Sales . Click the File tab , on the left click Save A s, and then click Browse . In the Save As dialog box, navigate to your Excel Chapter 1 folder, and then using your own name, save the file as Lastname_Firstname_1F_Balance_Sales
2 Merge & Center the title and the subtitle across columns A:F . Apply the Title and Heading 1 cell styles respectively.
3 Make cell A1 the active cell, and then check spelling in your worksheet. Correct Silde to Slide . Widen column A to 180 pixels and columns B:F to 95 pixels .
4 In cell E4 , construct a formula to calculate the Total Sales of the Balance Pillow by multiplying the Quantity Sold times the Retail Price . Copy the formula down for the remaining products.
5 Select the range E4:E10 , and then use the Quick Analysis tool to Sum the Total Sales for All Products , which will be formatted in Bold. To the total in cell E11 , apply the Total cell style.
1 Start Excel, and then on the opening screen, in the lower left, click Open Other Workbooks . Click Browse , and then navigate to your student data files for this chapter. Open the file e01_1F_Balance_Sales . Click the File tab , on the left click Save A s, and then click Browse . In the Save As dialog box, navigate to your Excel Chapter 1 folder, and then using your own name, save the file as Lastname_Firstname_1F_Balance_Sales
2 Merge & Center the title and the subtitle across columns A:F . Apply the Title and Heading 1 cell styles respectively.
3 Make cell A1 the active cell, and then check spelling in your worksheet. Correct Silde to Slide . Widen column A to 180 pixels and columns B:F to 95 pixels .
4 In cell E4 , construct a formula to calculate the Total Sales of the Balance Pillow by multiplying the Quantity Sold times the Retail Price . Copy the formula down for the remaining products.
5 Select the range E4:E10 , and then use the Quick Analysis tool to Sum the Total Sales for All Products , which will be formatted in Bold. To the total in cell E11 , apply the Total cell style.
1 Start Excel, and then on the opening screen, in the lower left, click Open Other Workbooks . Click Browse , and then navigate to your student data files for this chapter. Open the file e01_1F_Balance_Sales . Click the File tab , on the left click Save A s, and then click Browse . In the Save As dialog box, navigate to your Excel Chapter 1 folder, and then using your own name, save the file as Lastname_Firstname_1F_Balance_Sales
2 Merge & Center the title and the subtitle across columns A:F . Apply the Title and Heading 1 cell styles respectively.
3 Make cell A1 the active cell, and then check spelling in your worksheet. Correct Silde to Slide . Widen column A to 180 pixels and columns B:F to 95 pixels .
4 In cell E4 , construct a formula to calculate the Total Sales of the Balance Pillow by multiplying the Quantity Sold times the Retail Price . Copy the formula down for the remaining products.
5 Select the range E4:E10 , and then use the Quick Analysis tool to Sum the Total Sales for All Products , which will be formatted in Bold. To the total in cell E11 , apply the Total cell style.
