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?

Accepted Answer

Melanie clicks on the Design tab under the PivotTable Tools tab to change the default PivotTable Style in a workbook.

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?

Accepted Answer

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?

Accepted Answer

The Design tab in Excel contains tools for adding various elements to a chart, including the ability to change the chart style. This tab becomes available when a chart, such as a PivotChart, is selected.

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.

Accepted Answer

This is the correct procedure to ungroup worksheets that were previously grouped and worked on simultaneously.

Question 5

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

Accepted Answer

The Format Cells dialog box is where you can select and customize font, border, and fill settings for a particular element in a PivotTable. The Quick Style dialog box is for selecting pre-designed styles and the Field Settings dialog box is for configuring the behavior of individual fields. The PivotTable Options dialog box is for customizing the overall layout and settings of the PivotTable.

Question 6

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

Accepted Answer

Alt + Tab is the shortcut key combination that allows you to switch between open windows or applications, including workbook windows.

Question 7

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

Accepted Answer

Pressing the "Delete" key will remove the hyperlink completely.

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?

Accepted Answer

The "Address box" is where you type or paste the URL of the webpage you want to link to when inserting a hyperlink.

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?

Accepted Answer

To display one workbook in a new window, Ariana should click on the View tab, go to the Window group, and select the New Window option. This will open the current workbook in a new window, allowing her to view data from two workbooks simultaneously. Option B (Arrange All) would only arrange multiple open windows within one Excel application window, while Option C (Reset Window Position) would only reset the position of the current workbook window. Option D (Switch Windows) is not helpful for opening one workbook in a new window.

Question 10

A workbook template has which of the following file extensions?

Accepted Answer

A workbook template in Microsoft Excel uses the .xltx extension. This template format allows users to create pre-formatted and pre-configured workbooks that can include predefined settings, formulas, and layouts, making it easier to maintain consistency across similar types of documents.

Question 11

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

Accepted Answer

A template is a pre-designed workbook that contains the necessary formatting, formulas, macros, and text that you use repeatedly. It saves time as you can simply open the template and start working without having to create everything from scratch.

Question 12

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

Accepted Answer

The answer of Which of these series of clicks would...

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?

Accepted Answer

To insert a hyperlink to an email address, Amelia can select the text or picture that she wants to use as a hyperlink and then click on the "Insert" tab followed by "Hyperlink." In the "Link To" section, she can choose "E-mail Address" and enter the email address she wants to link to. She can also enter the subject line for the email in the "Subject" box before clicking "OK" to complete the process.

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?

Accepted Answer

To change the chart type in most charting software, including Microsoft Excel, the first step is typically to select the chart itself. Clicking the chart area ensures that the chart is selected and active, allowing changes such as the chart type to be applied to the entire 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.

Accepted Answer

This is the correct procedure for setting a named range formula in a 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?

Accepted Answer

Choice A) Shape Fill is the best choice because it allows Anne to apply a different fill color to the selected chart element. Choice B) Shape Styles would allow Anne to apply a pre-designed style to the chart element, but may not necessarily change the fill color. Choice C) Shape Effects would apply visual effects such as shadows or reflections to the chart element, but again, may not change the fill color. Choice D) Shape Outline would allow Anne to change the color, weight, and style of the element's outline, but would not change the fill color.

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.

Accepted Answer

This statement is true.

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?

Accepted Answer

Calista must have pressed Ctrl + K to bring up the Insert Hyperlink dialog box, where she can select ScreenTip and type in a message before clicking OK to save the link.

Question 19

You can use the DELETE key to clear cell contents.

Accepted Answer

The DELETE key on the keyboard can be used to clear the contents of a cell in various programs such as Microsoft Excel, Google Sheets, etc.

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?

Accepted Answer

The option X in this series is asking for the specific chart style that the user wants to apply to the chart. Therefore, the best choice of the option X is Style as it refers to the specific style of chart that the user wants to use. The other options are not applicable as they do not fit the context of the series.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks