Which of the following statements is most true regarding using Microsoft Excel to analyse data?

a.

The XLookup function can be used to combine data contained in two worksheets, providing that the worksheets have no common fields

b.

The Pivot Table function is useful for importing multiple worksheets

c.

The most effective way to approach data analysis is to separate data tables from analysis tables

d.

For a Pivot Table to work most effectively, each data table cell should contain a different field