Quiz 5 Excel Module 5
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?
Address box
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?
Arrange All? Wrong
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?
Create New Document
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?
Ctrl+K
Ricki wants to apply a particular chart style to a PivotChart she has created. Which of these tabs will help her apply it?
Design tab
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?
Desing Tab
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?
E-mail address
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.
False
You can press Ctrl+F11 to update a linked object from another app.
False
In which of these dialog boxes will you select the font, border, and fill settings for an element in a PivotTable?
Format Cells dialog box
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?
He clicks the chart area of the chart.***
Which of these series of clicks would you select to remove hyperlink from a cell?
Home tab > Editing group > Clear > Remove Hyperlinks?
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?
ScreenTip Text box
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?
Shape Fill
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?
Style
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.
True
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.
True
To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.
True
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.
True
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?
View tab > Window group > New Window
Don wants to compare two worksheets in the same workbook by viewing them side by side. What can he click to do so?
View tab > Window group > New Window > View Side by Side > Click sheets to compare in each workbook window
Which of these combination of keys will you press to switch between two workbook windows?
alt+tab
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.
false
To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.
template
A workbook template has which of the following file extensions?
xltx