Exam 5: Generating Reports From Multiple Worksheets and Workbooks

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.

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

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

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?

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?

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?

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?

A workbook template has which of the following file extensions?

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

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.

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?

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?

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

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

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.

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.

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

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?

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?