Exam 5: Generating Reports From Multiple Worksheets and Workbooks

Calista wants to add a screentip to a hyperlink she inserted into a cell.She selects the cell with the hyperlink,then presses a certain combination of buttons,then selects ScreenTip,types in a message,clicks OK,then clicks OK again to save the link.Which of these combination of buttons must she have pressed during this procedure?

To ungroup worksheets after grouping them and working on them simultaneously,right-click any worksheet tab in the group and click Ungroup Sheets.

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

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 the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?

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

Rogelio wants to use a named range formula in a cell.To do so,he can select the cell,press F2 to edit the cell,then select (Insert > Name > Paste)and select the name for the cell.