15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.lit

15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 1/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Reporting Exam (https://adaptiveinsightspartners.litmos.com/home/LearningPath/74048) / Résultats de l'évaluation Reporting Exam a été terminé par Ilyes Adjal le 21/06/2021 05:12:14 PM. Bonne réponse When you create reports using attributes, it allows for easy maintenance.   True  False Bonne réponse A Difference calculation remains unchanged unless it is connected to a parameter or the version selected is the current version.   True  False Bonne réponse A segment in the row axis of a report contains the elements account and a custom dimension, specifically the Revenue account and the Customer dimension. Which of the following elements must be contained in a second segment detailing Expenses?  Expense accounts  Customer dimension   Both Expense accounts and Customer dimension Bonne réponse A matrix report is limited to one version.  True   False (/home)   Tentatives 3  Temps passé 00:25:33 Note (Note minimale exigée 85%) 98% - Réussi 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 2/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Bonne réponse In the report builder, any row, column or filter element with a related parameter displays the plug icon.   True  False Bonne réponse Fill in the blank: The __________________ element is typically used to calculate a variance or variance % result. difference Bonne réponse Conditional formatting cannot be applied to a custom calculation element.  True   False Mauvaise réponse Which of the following is true regarding emailing reports? Check all that apply.  The sender can receive a copy of the report  Recipients receive the report as an attachment  Both shared and personal reports can be emailed  Email Reports permission is required to email reports Bonne réponse Select the options available to display line notes in a report.  Show in column, Show as footnotes, Show below, Hide   Show in column, Show as footnotes, Show inline, Hide  Show above, Show as footnotes, Show inline, Hide Bonne réponse By default, all data in a shared report displays for everyone regardless of their level assignment(s).  True   False 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 3/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Bonne réponse Which option copies elements from one report's row and/or column axis to a new report?  Add to favorites  Copy to shared folder  Move to shared folder   Add to reusable reports Bonne réponse When dropping the same element on a report multiple times and reporting the same result (e.g. Month to date and Year to date), it is best practice to:  Create a separate parameter for each element   Create one parameter and drop the elements on the same parameter  Do not create parameters  All of the above Bonne réponse Which elements are added together when the Subtotal calculation element is added to a report?   The segment elements preceding the Subtotal  The elements that are defined in the Subtotal calculation  The elements that are included in the organization level rollups  None of the above Bonne réponse The Matrix Report Builder and the Model Report Builder display the same commands.  True   False Bonne réponse Which one of the following elements must be included in a matrix report?   Account  Level  Currency  Version 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 4/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Bonne réponse What happens if a user attempts to run a shared report with level parameters which does not include their assigned level?   Report will not be visible to the user  Report will not run  Report will run and still show all values  Report will run and show no values Bonne réponse What does the hierarchy symbol indicate in the image below?   Display the rollup value total and the child accounts included in the rollup  Display the rollup value total only  The rollup name has been revised  Display the child accounts included in the rollup Bonne réponse Which of the following is true of filters in a matrix report? Check the two (2) that apply.   A report element can be both a filter and a parameter  At least one filter is required in a report's design   Multiple report elements can be added to the filter area  Elements in the filter area allow users to select from a filter menu Bonne réponse You can define a custom calculation to reverse the sign for revenue, liabilities, and equity accounts.  True   False Bonne réponse Snapshot can be set as the default output for a matrix report.  True   False Bonne réponse Select the options available for saving a shared report with other reporting users. 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 5/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1   Available Groups  Available Accounts   Available Levels   Available Users Bonne réponse A report containing a Level parameter with only the Sales levels as available selections is saved to a shared folder. By default, which users can access the report?  Selected users  No users  All users   Users with access to the Sales levels Bonne réponse Which of the following are parameter properties is useful for reports with multiple parameters?  Initial choice  Dynamic label syntax  Suppress rows if all zeroes   Prompt before viewing Bonne réponse A repeating report defaults to a Microsoft Excel workbook output.   True  False Bonne réponse Report properties override both row and column properties.  True   False Bonne réponse Conditional formatting is only available in Matrix reports and can be applied to any row, column, or sheet axes.   True 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 6/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1  False Bonne réponse Different formatting can be applied to the row's header, data and rollup.   True  False Bonne réponse The Current Version element represents the last version selected in reports or sheets.   True  False Bonne réponse How can a user with no access to a specific organization level, run the report for that organization level and view the related data?  Permissions > All users   Permissions > Show all data regardless of level  Properties  Move to personal folder Bonne réponse Because snapshots do not support drill down, which of the following is recommended? Check all that apply.   Drill to the desired area of the report before taking the snapshot  Export the snapshot to Excel to view the details   Include details at the top level  Enable the option Allow rows to be expanded in Report Properties Bonne réponse When reporting on level attribute values, the related level must also be included in the report.  True   False Bonne réponse The results of a Difference calculation column can be displayed in which of the following 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 7/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 formats? Select the two (2) that apply.   Value   Percent  Fraction  Text Value Bonne réponse Parameters may be created for only those elements included in the report's design.   True  False Bonne réponse How can a blank row be added to a report?   Drag and drop the Blank Space onto the row axis  Right-click and select Insert Blank Row  Click the New Row icon  None of the above Bonne réponse Which option displays the default elements in a report?  Explore Cell  Drill into... selection   Show Information  Show defaults Bonne réponse Which of the following should be applied to a report that displays a green arrow for variances above $10,000 and 5% and a red arrow for variances below $10,000 and 5%?  Subtotal calculation  Timespan   Custom calculation with conditional formatting  Display as Custom 15/10/2021 16:29 Résultats de l'évaluation https://adaptiveinsightspartners.litmos.com/assessment/results?token=7ef1850e03764e168ff87c30db32a8b0_US1&user=WsSTUi5Nzp6ptYzJUmd0Fg__&cou… 8/13 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Pondération: 1 Bonne réponse Only users with the appropriate permissions can manage the report folder structure.   True  False Bonne réponse Which element must be included in a report that compares two versions and allows the calculation to change based on a Version parameter?  Subtotal calculation  Display as % of Account  Custom calculation   Difference calculation Bonne réponse Although the Level element is not included in the report's design, a user can click the account name in the report viewer and view the account details by level.   True  False Bonne réponse A report saved to a personal folder uploads/Litterature/exam-5.pdf

  • 32
  • 0
  • 0
Afficher les détails des licences
Licence et utilisation
Gratuit pour un usage personnel Attribution requise
Partager