Project 3/7 - Task 1 Simultaneously replace all occurrences of the word Choco with Chocolate in the workbook.ġ.
You are tracking the cost and profit of each flavor and summarizing the information in a workbook. (Hint: Giant Truck Bed Tent should now be added to the legend representing the last stack on the column chart.) Project 2/7 - Task 5 diff diff Project 3/7 - Overview TaffyĪ shop you manage sells custom-flavored taffy. (Hint: In the Select Data Source pop-up window, in the left window pane, Giant Truck Bed Tent should now appear below 4-Person Tent.) Hold down the Ctrl key and select cell range B7:C7. (Hint: The view will switch to the data source on the worksheet, cell range B4:C6.)Ĥ. On the Tents worksheet, click in the center of the chart to select it.Ģ. Project 2/7 - Task 4 On the Tents worksheet, expand the chart data range to include the Giant Truck Bed Tent in cell B7.ġ. On the Home tab, in the Styles group, click Conditional Formatting to open the menu.ģ. Select cell range C4:C11 on the Tents worksheet.Ģ. Project 2/7 - Task 3 On the Tents worksheet, apply Conditional Formatting using the 3 Flags Icon Set to the values in the Inventory column.ġ. In the Or select a place in this document field, under Cell Reference, highlight Fishing.Ħ. In the Type the cell reference field, type A4ĥ. In the Link to: section, select Place in This Document.Ĥ. On the Insert tab, in the Links group, click Link.ģ. Select cell B13 on the Tents worksheet.Ģ. Project 2/7 - Task 2 On the Tents worksheet, link the contents in cell B13 to cell A4 on the Fishing worksheet.ġ.
0 kommentar(er)
