Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
When inspecting a workbook, you locate the following VBA code in the Sheet4 code module. What will this code do? Private Sub Worksheet_Activate() ActiveSheet.PivotTables("pvtSales").PivotCache.Refresh End Sub
It will refresh the “pvtSales” PivotTable whenever the workbook is opened
It will refresh the “pvtSales” PivotTable every time the Sheet4 is selected
It refreshes the “pvtSales” PivotTable when any worksheet in the file is activated
Don’t know
2
Advanced
When inspecting a workbook, you locate the following VBA code in the ThisWorkbook code module. What will this code do? Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveWorkbook.RefreshAll End Sub
It will refresh all PivotTables in the workbook any time a new sheet is selected
Upon selecting a worksheet, it will refresh the PivotTable on that worksheet
It will refresh the “pvtSales” PivotTable whenever the workbook is opened
Don’t know
3
Advanced
What is the easiest way to ensure that the Sales PivotTable is refreshed every time you open the file?
Create a worksheet with instructions to refresh the PivotTable manually when you open the file
Right-click the PivotTable > PivotTable Options > Data > check the box next to “Refresh data when opening the file”
Record a macro to refresh the PivotTable and place it in the VBA module for that worksheet
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement