GoSkills
Back to lesson
Question
1
of
3
1. We have created a useful PivotTable solution and want to send it to a user inside our company. It’s a true work of art, and we spent hours getting the formatting just right to display our reports in just the right way (something that is very important to our supervisor.) Each of the following is an important consideration to implement, but which is probably the most important in this case?
Unchecking the option to “Save data with the file”.
Setting the file to automatically update upon open.
Preventing column resizing and turning off slicers and PivotCharts ability to move or size with cells.
Don’t know
2. We have created a useful PivotTable solution and want to send the final report to a vendor. Each of the following is an important consideration to implement, but which is probably the most important in this case?
Setting the file to automatically update upon open.
Uncheck the option to “Save data with the file”.
Prevent column resizing and turn off slicers and PivotCharts ability to move or size with cells.
Don’t know
3. You’ve been tasked with creating a dashboard that your boss will be opening every morning at a minimum to understand the key drivers affecting your business. Each of the following is an important consideration to implement, but which is probably the most important in this case?
Setting the file to automatically update upon open.
Preventing column resizing and turning off slicers and PivotCharts ability to move or size with cells.
Unchecking the option to “Save data with the file”.
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement