Change the layout to Layout 2 Apply chart Style 4 Switch the Row and Column

# Change the layout to layout 2 apply chart style 4

• 3

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

. Change the layout to Layout 2. Apply chart Style 4. Switch the Row and Column data. Change the chart title to Sales by Location . 8 18 On the Inventory worksheet, insert a formula to calculate the Total Cost of the items in inventory in column E. 3 19 On the Inventory worksheet, format the range A3:F29 as an Excel Table, and apply the Table Style Light 2. Add a Total Row. Ensure that the Total Row is added as Row 30 in the table. Use the functions in the Total Row to sum the Quantity and Total Cost columns. 6 20 In column F, insert a formula that provides the Total Cost for each item as a percent of the Total Cost. Apply the Percent style, with one decimal place. 3 21 Sort the table ascending by Item. Filter the table to display only the Large items. 9 22 Group the worksheets, insert the Sheet Name in the left section and the Date in the right section in the Footer. Ungroup the worksheets. Show formulas on the Downtown worksheet and adjust the width to print to 1 page. On the Inventory worksheet, set the titles to print for rows 1:3. 7 23 Save the file, close Excel, and then submit the file as directed by the instructor. 0 Updated: 02/13/2018 2 Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions Excel Project Step Instructions Points Possible Total Points 100.00 Updated: 02/13/2018 3 Current_Instruction.docx