Senior Pivot Tables

Test your Senior-level Spreadsheets Pivot Tables skills in Tools Systems. This timed assessment evaluates your expertise in Accounting.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

To create a consolidated P&L pivot table from three separate GL tables with non-uniform charts of accounts, what is the most scalable approach using the Data Model?

A. Create a master Chart of Accounts dimension table and build one-to-many relationships to each GL fact table.

B. Use Power Query to append the three GL tables into a single large table before loading to the pivot cache.

C. Create three separate pivot tables and use cell-linking formulas to consolidate the results on a summary sheet.

D. Build a calculated column in each GL table to standardize account names before creating the pivot table.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question