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?

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.

Che wants to change the chart type of the whole chart to give it a different look. To do this, he follows the following steps: 1. X 2. He clicks Change Chart Type On the Design tab in the Type group. 3. Che clicks the chart type that he wants to use in the Change Chart Type dialog box. What was step 1 in his procedure?

Avril wants to link worksheet data to a Word document so that whenever the worksheet is updated, the changes are updated in the document. To do so, she should open the Excel worksheet and drag over the content and press Ctrl+C. Next she should move to the Word file, Place the insertion point where she wants the worksheet data to appear and press Ctrl + V.

Which of these series of clicks would you select to remove hyperlink from a cell?

Amelia wants to insert a hyperlink to an e-mail address. Which of these can be X in the following series of clicks she can use: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Subject box (Type subject ) > OK?

Which of these combination of keys will you press to switch between two workbook windows?

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?

Ariana wants to view data from two workbooks at the same time so that one of them opens in a new window. What can she click to display one workbook in a new window?

Pam wants to break the link to the external reference of a formula so that all its values are replaced by the calculated values. To do so, she can click Data Tab > Queries & Connections Group > Edit Links button > Edit Links dialog box > Break Link button.

Alicia has already created a chart in Excel and wants to link it to her PowerPoint presentation. To do so, she can click Insert tab > Symbols group > Object command > (Dialog box > Create New > Locate desired file > Insert > OK > Tick box next to Link to file > OK.

You can use the DELETE key to clear cell contents.

Which of these will you select as X in the following series of clicks to insert a hyperlink to a webpage: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Insert Hyperlink box > X > Type or paste link?

Melanie wants to change the default PivotTable Style for a workbook. She selects a cell in a Pivot Table, then clicks a certain tab on the Ribbon, under the PivotTable Tools tab. Then she right-clicks the style she wants to set as the default In the PivotTable Style gallery and finally clicks on Set As Default in the context menu. What is the tab Melanie clicks during this procedure?

A workbook template has which of the following file extensions?

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

Tim wants to insert a hyperlink to a new file for quick access to related information on a web page. Which of these can be X in the following series of clicks he can use: Cell to insert hyperlink > Insert tab > Links group > Hyperlink > Link to > Create new Document > Name of New Document (Type a name for new file ) > When to Edit > Select an option > Text to display box > ( Type text that you want to use to represent the hyperlink) > X > (Type information to be displayed when pointer rests on hyperlink in the box) > OK?

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Don wants to compare two worksheets in the same workbook by viewing them side by side. What can he click to do so?

You can press Ctrl+F11 to update a linked object from another app.