Exam 5: Generating Reports From Multiple Worksheets and Workbooks

To update the data associated with external links, close all workbooks and open the one that contains the links. Then click Options on the Trust Bar and then click Enable this Content.

Anne has created a chart and wants to apply a different fill color to a chart element. Which of these will she choose after selecting the chart element and clicking on Chart Tools under Format tab?

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

In which of these dialog boxes will you select the font, border, and fill settings for an element in a PivotTable?

Ricki wants to apply a particular chart style to a PivotChart she has created. Which of these tabs will help her apply it?

Bella wants to insert a hyperlink to a location in the current file. Which of these can be X in the following series of clicks she can use to solve her purpose: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Select heading (current document only), bookmark, slide, custom show, or cell reference to link to in the list?

Which of these keys will you press to remove a hyperlink completely?