Insert A Radial Cycle Smartart Diagram

Question: Add a Step Up Process SmartArt diagram to the worksheet. It is the second option in the first row of the Process category.

Answer: On the Insert tab, in the Illustrations group, click the SmartArt button. Inside the Choose a SmartArt Graphic dialog, from the SmartArt Category list, click the Process list item. Inside the Choose a SmartArt Graphic dialog, click the Step Up Process image, click OK

Question: Use Consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets Social Media, Direct Mail, and Other. Do not include links to the source data.

Answer:

Question: Add a hyperlink from the selected cell to link to cell B4 in the Social Media worksheet. Don’t forget to use B4 as the cell reference.

Answer:

Question:

Answer:

Question: Remove the hyperlink from cell B3.

Answer: Right click cell B3. In the Right-Click menu, click Remove Hyperlinks menu item

Question: Mark the workbook as final.

Answer: Open backstage view, click the Protect Workbook button. In the Protect Workbook menu, click the Mark as Final menu item. Inside the Microsoft Excel dialog, click the OK button. Inside the Microsoft Excel dialog, click OK

Question: Use Consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets Bob, Cathy, and Mario. Include links to the source data to display subtotals.

Answer:

Question: Apply the Preset 4 picture effect to the picture (the last effect in the first row of preset effects).

Answer: On the Format tab, in the Picture Styles group, click the Picture Effect button. In the Picture Effects menu, in the Preset menu, select the Preset 4 option

Question: Move the image so it is centered in cell A1.

Answer: Drag the Profit sign image to the left (by 6 columns) and up (by 1 row)

Question: Apply the Intense Effect SmartArt style to the diagram. It is the last option in the Best Match for Document section of the gallery.

Answer: On the Design tab, in the SmartArt Styles group, expand the SmartArt Styles Gallery. Select the Intense Effect option