Fill the function in cell E4 down through cell E35 3 18 On the Stock worksheet

Fill the function in cell e4 down through cell e35 3

This preview shows page 2 - 3 out of 3 pages.

cell E35.318On the Stock worksheet, apply Wrap text and Center Align in A3:G3. Insert a formula to calculate the Total Cost of Bottle Stock in column F. AutoFit column F.419On the Stock worksheet, format the range A3:G35 as an Excel Table with headers, and apply the Table Style Light 3. Note, depending on the version of Office you are using, the style may be named Tan, Table Style Light 3. Add the Total Row style option as row 36 in the table. Use the functions in the TotalRow to sum the Quantity and Total Cost columns.620In column G, insert a formula that provides the Total Cost for each item as a percent of the Total. Apply the Percent style, with one decimal place. Center Align the results.321Sort the table ascending by Item. Filter the table to display only Chardonnay and Pinot Grigio.822Group the worksheets, in the Footer insert the Sheet Name in the left section and the Date in the right section. Return to Normal View. Ungroup the worksheets. Show formulas on the Downtown worksheet and adjust the width to print to 1 page. On the Stock worksheet, set the titles to print for rows 1:3. Hide the Stock Worksheet. Save the file.7.523Verify that the worksheets are in the following order: Sales Chart, Summary, Downtown, Midtown, Seaside, Town Center, Stock. Save the file, close Excel, and then submit the file as directed by the instructor.0Total Points100.0Updated: 02/09/20182Current_Instruction.docx
Background image
Office 2016 – myitlab:grader – InstructionsExcel ProjectUpdated: 02/09/20183Current_Instruction.docx
Background image

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '16
  • James Loop
  • Decimal, Town Center

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture