Exam 10: Data Analysis With Power Tools and Creating Macros

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?

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?

Johan wants to create a PivotTable using Power Pivot.During the procedure,to add a Table to PowerPivot,he selects a cell in a Table and clicks Power Pivot tab > Tables group > X.What is X in the procedure?

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Finley wants to create a 3-D map scene in a tour.To do this,she selects a range of cells containing her data in an Excel table.She then clicks on Insert tab > X > 3D Maps > Open 3D Maps.What is X in the procedure?

To change the background colors in a Power View report,click the POWERVIEW tab > Themes group > Background > Select a color.

To open the Manage Relationships dialog box in a Power View report,click the Design tab in the Power Pivot window,then click Manage Relationships in the Relationships group.

Which of the following scene effects move in a repetitive circular motion?

To change the size of text to a particular percentage of the original text size in a Power View report,click on Power View tab > Themes group > Text Size.

To load the Analysis ToolPak and select Anova: Single Factor for statistical analysis in Excel,one should click on the following series: File tab > Options > Add-Ins category > Manage box > Excel Add-ins > Go .select Analysis ToolPak option on the appearing dialog box > OK > Data > Analysis > Data Analysis dialog box > Anova: Single Factor > OK.

Avery wants to transform data from data sources in order to analyze it.To do this,she can click Data > Get Data > Navigator window > Select table (or tables)to use in the query > Edit > OK.

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

In which of the following boxes under Home > Scene Options will you insert the name for the scene name of a tour?

Derek wants to remove columns from Query he doesn't need.To do so,he can select the columns he wants to remove with Ctrl+Click.Then he can select Remove Columns > Remove Columns in the Query Editor ribbon.

What is the default value (in seconds)for a transition between scenes in a tour?

A worksheet has the following data in it: Cell range A2 to A10 in column A lists the years from 2010 to 2019.Cell range B2 to B10 in column B lists the types of food items sold during each year: Tomatoes,Oranges,Pears,Pineapples,Potatoes,and Onions.Cell range C2 to C10 in column C lists the sale of each item in each year.If we insert the formula =COUNTIFS("=Onions","B2:B10")in cell A11,it will give us the count of the number of times "Onions" has been listed in the worksheet.

Kahir wants to delete a macro.To do this,he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box.Which of the following will he select as X in this series of selections?

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?

How can you rename a column in Excel?

Vasalicki wants to create a query linked to a table.In which row should she enter field criteria in the query design grid?