Excel_1f_dispenser_sales | Computer Science homework help

Jul 19, 2023



Don't use plagiarized sources. Get Your Custom Essay on
Excel_1f_dispenser_sales | Computer Science homework help
Just from $13/Page
Order Essay

Open the file Student_Excel_1F_Dispenser_Sales.xlsx   downloaded with this project.


Merge and center the title and   then the subtitle across columns A:F and apply the Title and Heading 1 cell   styles respectively.


Make cell A1 the active cell,   and then check spelling in your worksheet. Correct Npkin to Napkin. If any   columns are too narrow to display all the data, apply AutoFit to the column.



In cell E4, construct a formula   to calculate the Total Sales of the Condiment Rack by multiplying the   Quantity Sold times the Retail Price. Copy the formula down for the remaining   products.


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.
  Mac users: Instead of the Quick Analysis tool, use the AutoSum button.   Complete the step as specified. Apply bold.


Using absolute cell references   as necessary so that you can copy the formula, in cell F4, construct a   formula to calculate the Percent of Total Sales for the first product. Copy   the formula down for the remaining products.


To the computed percentages, apply   Percent Style with two decimal places, and then center the percentages.


Apply the Comma Style with no   decimal places to the Quantity Sold figures. To cells D4, E4, and E11 apply   the Accounting Number Format. Increase the column widths as needed.


To the range D5:E10, apply the   Comma Style. Increase the column widths as needed.


Change the Retail Price of the   Artisan Rack to 29.95 and the Quantity Sold of the Cheese Shaker to 425


Delete column B. 


Insert a new row 3. In cell A3,   type Month   Ending March 31 and   then merge and center the text across the range A3:E3. Apply the Heading 2   cell style.


To cell A12, apply the 20% –   Accent1 cell style.


Select the four column titles.   Apply Wrap Text, Middle Align, and Center formatting, and then apply the   Heading 3 cell style.


Center the worksheet   Horizontally on the page, and then insert a Footer with the File Name in the   left section.


Display the document properties,   and then as the Tags, type tabletop dispensers, sales
  In the Subject box, add your course name and section number. Be sure your   name displays as the Author.



Save and close the workbook.   Exit Excel. Submit the file as directed.

Recent Posts