(Solved): Which statement about Power Pivot is true? Power Pivot can work with data that exceeds Excel's one ...

Which statement about Power Pivot is true? Power Pivot can work with data that exceeds Excel's one million row limit. Relationships are never required when using multiple tables. Formulas in Power Pivot work on a cell by cell basis. Power Pivot is used mainly for data transformations.