Question 1

Which of the following would you select on the Developer group to record a relative reference macro?
A) Macros
B) Visual Basic
C) Record Macro
D) Use Relative References

Accepted Answer

The answer of Which of the following would you select...

Question 2

What is the default value (in seconds)for a transition between scenes in a tour?
A) 1
B) 3
C) 10
D) 12

Accepted Answer

The default value for a transition between scenes in a tour is three seconds, as it allows enough time for the viewer to absorb the current scene before transitioning to the next one. Option A (1 second) may not provide enough time for the viewer to fully appreciate the scene, while options C (10 seconds) and D (12 seconds) may be too slow and lead to viewer boredom or impatience.

Question 3

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?
A) Add to Data Model
B) Update All
C) Measures
D) KPIs

Accepted Answer

To add a Table to PowerPivot, Johan should select a cell in a Table, and then click Power Pivot tab > Tables group > Add to Data Model.

Question 4

What is the file extension of macro-enabled workbook?
A) .xls
B) .xlx
C) .xlsx
D) .xlsm

Accepted Answer

The file extension for a macro-enabled workbook is .xlsm. This allows for the use and execution of macros within the workbook. Options A, B, and C do not support macros.

Question 5

Which of the following keys will help you single step through your code in a macro?
A) F5
B) F8
C) F11
D) F12

Accepted Answer

Pressing F8 will allow you to single step through your code in a macro, meaning each line of the code will be executed one at a time so you can observe the effects of each line of code.

Question 6

Which of the following will you select in Excel Options under File tab add the Insert Power View Report button to the ribbon?
A) Customize Ribbon
B) Advanced
C) Language
D) Proofing

Accepted Answer

The "Customize Ribbon" option allows users to add or remove buttons from the ribbon, including the option to add the "Insert Power View Report" button. The "Advanced" option is used for more technical settings, while "Language" and "Proofing" options are related to spell-check and language settings.

Question 7

Edward wants to edit a relationship between two tables.To do this,he places the cursor pointing to the relationship line and then clicks the line to select it.Then,he clicks on tab "X" > Group "Y" > Edit Relationships.What are X and Y in the procedure?
A) A-Design tab,B-Tools group
B) A-Developer tab,B-Code group
C) A-Format tab,B-Arrange group
D) A-Design tab,B-Relationships group

Accepted Answer

DIn database management systems like Microsoft Access, editing a relationship between two tables is typically done under the "Design" tab, within the "Relationships" group. This is where users can manage and modify how tables relate to each other.

Question 8

Which of the following series of clicks will you follow after clicking on a column to create a measure in the Power Pivot Window using AutoSum?
A) Calculations > AutoSum
B) Home > View> Calculation Area
C) PivotTable Fields > (Drag a field into)Values
D) Power Pivot > Calculations > Measures > New Measure

Accepted Answer

The answer of Which of the following series of clicks...

Question 9

Vasalicki wants to create a query linked to a table.In which row should she enter field criteria in the query design grid?
A) Criteria row
B) Show row
C) Field row
D) Sort row

Accepted Answer

Field criteria should be entered in the Criteria row in the query design grid to filter the results based on certain conditions. The Show row is used to select which fields to display in the results, the Field row is used to specify the field to be used, and the Sort row is used to sort the results in ascending or descending order based on a particular field.

Question 10

Which of the following scene effects move in a repetitive circular motion?
A) Figure 8
B) Dolly
C) Rotate Globe
D) Push In

Accepted Answer

The answer of Which of the following scene effects move...

Question 11

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?
A) Layer Pane
B) Editor Pane
C) Center Pane
D) Tour Editor Pane

Accepted Answer

The Center Pane in the Power Map window contains a 3-D globe on which the data is mapped. The Layer Pane displays the layers in the map, the Editor Pane allows for editing the data and the Tour Editor Pane is where you can create and edit tours.

Question 12

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?
A) Tours group
B) Scene group
C) Tables group
D) Sparklines group

Accepted Answer

The correct option is A) Tours group. In Excel, to create a 3-D map scene in a tour, you would navigate through the Insert tab, then to the Tours group, where you can find the option for 3D Maps to open and create your 3D map scene.

Question 13

Grace wants to insert a Form control button into a worksheet.Which of the following will she select as X in the following series of clicks/entries/selections to display the Developer tab: File menu > Options from drop down menu > X in Excel Options Window > Developer checkbox under the list of Main Tabs > OK?
A) Advance
B) Language
C) Customize Ribbon
D) Quick Access Toolbar

Accepted Answer

The Developer checkbox is located under the list of Main Tabs in the Customize Ribbon section of Excel Options. Therefore, Grace needs to select "Customize Ribbon" as X to display the Developer tab.

Question 14

A worksheet has the following data in it: Cell range A2 to A10 in column A lists the categories of food items in a store: Vegetables and Fruits.Cell range B2 to B10 in column B lists the types of food items for each category: Cucumbers,Corn,Pears,Lettuce,Potatoes,and Scallions.Cell range C2 to C10 in column C lists the sale of each item during the month.If we insert the formula =SUMIFS(A2:A10,B2:B10,=P* )in cell A11,it will give us the total sale of products that begin with the letter P.

Accepted Answer

The formula should be =SUMIFS(C2:C10,B2:B10,"P*") to calculate the total sale of products that begin with the letter P.

Question 15

Which of the following should be selected as X in the series to assign a macro to a button: Developer tab > Controls group > X > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type in the Assign Macro popup window?
A) Insert
B) View Code
C) Run Dialog
D) Design Mode

Accepted Answer

The correct sequence to assign a macro to a button in Excel involves using the Insert option in the Controls group under the Developer tab. This allows you to insert a Form Control, specifically a Button, onto the worksheet, after which you can assign a macro to it.

Question 16

Willa wants to insert a 3-D Map to explore data.Which of the following options should she click in Custom Maps Options box to get the best fit?
A) AutoFit
B) Pixel Space
C) Swap the X and Y axis
D) Lock current coordinate values

Accepted Answer

AutoFit will automatically adjust the map to fit the available space, providing the best fit for the 3-D Map.

Question 17

Nathan wants to run a macro from the developer tab.He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run.What should he click as X in this procedure?
A) Macros
B) Visual Basic
C) Record Macro
D) Macro Security

Accepted Answer

To run a macro from the Developer tab, after enabling the Developer tab and navigating to it, you should click on "Macros" to access the list of available macros. From there, you can select a macro and run it.

Question 18

Arlo creates a rectangular shape and inserts the text 'Color Box' in it.Then,he right clicks on the shape and selects a button to assign a macro to it.Which of the following can his selection be?
A) Assign Macro…
B) Format Shape…
C) Set as Default Shape
D) Size and Properties…

Accepted Answer

The question states that Arlo wants to assign a macro to the shape, so the best choice would be A) Assign Macro… The other options, B) Format Shape…, C) Set as Default Shape, and D) Size and Properties… do not relate to assigning a macro.

Question 19

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.

Accepted Answer

The formula should be: =COUNTIF(B2:B10,"Onions") to count the number of times "Onions" has been listed in column B. The current formula has incorrect syntax and will return an error.

Question 20

In which of the following boxes under Home > Scene Options will you insert the name for the scene name of a tour?
A) Effect
B) Scene Name
C) Scene duration (sec)
D) Transition duration (sec)

Accepted Answer

The box labeled "Scene Name" under the "Home" tab in the "Scene Options" section is where the name for the scene of a tour should be inserted. The other options (Effect, Scene duration, and Transition duration) are related to the visual elements and specific timings of the scene transitions, but do not pertain to naming the scene itself.

Quiz 10: Data Analysis With Power Tools and Creating Macros

Which of the following would you select on the Developer group to record a relative reference macro?

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

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?

What is the file extension of macro-enabled workbook?

Which of the following keys will help you single step through your code in a macro?

Which of the following will you select in Excel Options under File tab add the Insert Power View Report button to the ribbon?

Edward wants to edit a relationship between two tables.To do this,he places the cursor pointing to the relationship line and then clicks the line to select it.Then,he clicks on tab "X" > Group "Y" > Edit Relationships.What are X and Y in the procedure?

Which of the following series of clicks will you follow after clicking on a column to create a measure in the Power Pivot Window using AutoSum?

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

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

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?

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?

Which of the following should be selected as X in the series to assign a macro to a button: Developer tab > Controls group > X > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type in the Assign Macro popup window?

Willa wants to insert a 3-D Map to explore data.Which of the following options should she click in Custom Maps Options box to get the best fit?

Nathan wants to run a macro from the developer tab.He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run.What should he click as X in this procedure?

Arlo creates a rectangular shape and inserts the text 'Color Box' in it.Then,he right clicks on the shape and selects a button to assign a macro to it.Which of the following can his selection be?

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