After opening a workbook,Audra wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the DATA tab?
A)Refresh
B)Refresh All
C)Update
D)Update All

Question

Quizplus · Accepted Answer

Audra should click the "Refresh All" button in the Connections group on the DATA tab to update all of the external data ranges in the workbook. This option will update all connections and external data ranges in the workbook, while the "Refresh" button only updates the selected connection or data range. The "Update" and "Update All" buttons are not options in the Connections group on the DATA tab.

After Opening a Workbook,Audra Wants to Update All of the External