Deck 5: Generating Reports From Multiple Worksheets and Workbooks

Question 1

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) Data tab
B) Home tab
C) Insert tab
D) Design tab

Answer 1

D

Question 2

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?

A) E-mail Address
B) Create New Document
C) Place in This Document
D) Existing File or Webpage

Answer 2

B

Question 3

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

A) Layout tab
B) Format tab
C) Design tab
D) Analyze tab

Answer 3

C

Question 4

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

Question 5

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

A) Quick Style dialog box
B) Format Cells dialog box
C) Field Settings dialog box
D) PivotTable Options dialog box

Question 6

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

A) Ctrl + Alt
B) Alt + Tab
C) Ctrl + Alt + Tab
D) Ctrl + Shift + Alt

Question 7

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

A) Esc
B) Delete
C) Ctrl + F9
D) Ctrl + Shift + F7

Question 8

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?

A) Bookmark
B) ScreenTip
C) Address box
D) Text to display

Question 9

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?

A) View tab > Window group > New Window
B) View tab > Window group > Arrange All
C) View tab > Window group > Reset Window Position
D) View tab > Window group > Switch Windows > Select a file

Question 10

A workbook template has which of the following file extensions?

A) .xltx
B) .xls
C) .xlsx
D) .xlst

Question 11

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

A) master
B) model
C) template
D) standard

Question 12

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

A) Home tab > Editing group > Clear > Remove Hyperlinks
B) Home tab > Editing group > Delete > Delete Hyperlinks
C) Home tab > Hyperlink group > Remove Hyperlinks
D) Home tab > Styles group > Delete > Remove Hyperlinks

Question 13

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?

A) E-mail Address
B) Create New Document
C) Place in This Document
D) Existing File or Webpage

Question 14

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?

A) He clicks the chart area of the chart.
B) He selects all the labels of the chart.
C) He clicks one data series among the ones she wants to change the chart type for.
D) He selects all the data series of the chart.

Question 15

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.

Question 16

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) Shape Fill
B) Shape Styles
C) Shape Effects
D) Shape Outline

Question 17

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.

Question 18

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?

A) Ctrl + Z
B) Ctrl + K
C) Alt + E
D) Alt + F4

Question 19

You can use the DELETE key to clear cell contents.

Question 20

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?

A) Style
B) Color
C) Border
D) Shape

Question 21

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

Question 22

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?

A) Style dialog box
B) Dynamic Text box
C) ScreenTip Text box
D) Edit Hyperlink dialog box

Question 23

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.

Question 24

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.

Question 25

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?

A) Reset Window Position
B) Synchronous Scrolling
C) Arrange All
D) Zoom to Selection

Question 26

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.

Question 27

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

A) View tab > Window group > New Window > View Side by Side > Arrange All
B) View tab > Window group > New Window > View Side by Side > Freeze Panes > Select from drop down option
C) View tab > Window group > New Window > View Side by Side > Switch Windows > Select a window from the drop down menu
D) View tab > Window group > New Window > View Side by Side > Click sheets to compare in each workbook window