Connie needs to use the data consolidation tool in Excel 2019. Where can she find this capability?
Answer
A
Data tab and Data Tools group
B
Data tab and External Data group
C
Formula tab and Calculation group
D
Review tab and Changes group
Explanation
In Excel 2019, the Consolidate command is located on the Data tab, in the Data Tools group. Therefore, the correct choice is “Data tab and Data Tools group.”
AI-written and checked against the verified answer.