Practice Exam 3- MKTG381 questions
and answers with solutions
Which of the following is not a requirement when creating a relationship in Power Pivot?
Common fields must have the same name.
The default option in the Excel Trust Center enables all macros as a workbook opens.
False
Which of the following is a visual filter for a date field in a PivotTable?
Timeline
When field names are different but have identical attributes, you cannot create a relationship.
False
When creating a forecast sheet, one data series must be a time or date field.
True
Getting data is often referred to as importing data.
True
Which of the following is not a method to launch power Query?
Click the Table button on the Insert tab
Which of the following is not true statement when merging queries?
All fields from the first and second table are displayed
When a scenario displays, you can change values in the affected cells as a regular edit.
True
Which of the following add-ins performs statistical and engineering functions?
Analysis toolpak
When creating a slicer with multiple fields, each field displays in its own slicer window.
True
When you open a macro-enabled workbook, you must enable the macros to run or edit them.
and answers with solutions
Which of the following is not a requirement when creating a relationship in Power Pivot?
Common fields must have the same name.
The default option in the Excel Trust Center enables all macros as a workbook opens.
False
Which of the following is a visual filter for a date field in a PivotTable?
Timeline
When field names are different but have identical attributes, you cannot create a relationship.
False
When creating a forecast sheet, one data series must be a time or date field.
True
Getting data is often referred to as importing data.
True
Which of the following is not a method to launch power Query?
Click the Table button on the Insert tab
Which of the following is not true statement when merging queries?
All fields from the first and second table are displayed
When a scenario displays, you can change values in the affected cells as a regular edit.
True
Which of the following add-ins performs statistical and engineering functions?
Analysis toolpak
When creating a slicer with multiple fields, each field displays in its own slicer window.
True
When you open a macro-enabled workbook, you must enable the macros to run or edit them.
