



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Practice Exam 3- MKTG381 Question And Answers 2025
Typology: Exams
1 / 5
This page cannot be seen from the preview
Don't miss anything!
Which of the following is not a requirement when creating a relationship in Power Pivot? - correct answers ✅Common fields must have the same name. The default option in the Excel Trust Center enables all macros as a workbook opens. - correct answers ✅False Which of the following is a visual filter for a date field in a PivotTable? - correct answers ✅Timeline When field names are different but have identical attributes, you cannot create a relationship. - correct answers ✅False When creating a forecast sheet, one data series must be a time or date field. - correct answers ✅True Getting data is often referred to as importing data. - correct answers ✅True
Which of the following is not a method to launch power Query? - correct answers ✅Click the Table button on the Insert tab Which of the following is not true statement when merging queries? - correct answers ✅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. - correct answers ✅True Which of the following add-ins performs statistical and engineering functions? - correct answers ✅Analysis toolpak When creating a slicer with multiple fields, each field displays in its own slicer window. - correct answers ✅True When you open a macro-enabled workbook, you must enable the macros to run or edit them. - correct answers ✅True
Merge and append as many queries as necessary, but the same matching and relationship - correct answers ✅True Which of the following is a file format that is designed for exchanging data online - correct answers ✅.xml When you run a macro that was recorded with relative references, the active cell can be anywhere in the worksheet. - correct answers ✅False When is the best time to set data validation? - correct answers ✅before data is entered Which of the following is not true for the Merge command? - correct answers ✅You can merge queries at random Grouping rows in Power Query is similar to arranging data in a PivotTable or using the Subtotal command in a worksheet. - correct answers ✅True
Which of the following is a generated or calculated column with an IF statement that determines what displays in the column. - correct answers ✅Not extracting**tranformation A macro is saved in an Excel macro-enabled workbook which has an .xlsm file name extension. - correct answers ✅True Which of the following provides options for getting data from Microsoft Access, SQL Server, and Analysis Services? - correct answers ✅From Database The Power Query Editor cannot merge queries. - correct answers ✅False Power Query can add a column to your data based on a data sample. - correct answers ✅True