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
Documents similaires










-
32
-
0
-
0
Licence et utilisation
Gratuit pour un usage personnel Attribution requise- Détails
- Publié le Dec 17, 2021
- Catégorie Literature / Litté...
- Langue French
- Taille du fichier 0.2485MB