Correct Answer: Enable automatic update for all Workbook Links.
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
What is the maximum number of users that can open and share a shared workbook at the same time?
If your Microsoft Excel workbook closes due to system error before you could save it, then which of the following is the correct way to recover it?
Laura inserts an image into a shape. She needs to make this image transparent so that the text remains visible. Which of the followings is the correct way to make the image transparent?
Slicers are typically associated with the PivotTable in which they are created.
Data of a copied cell remains on the clipboard until a cell is not edited.
For Workbook Links in Microsoft Excel 2010, which security setting is NOT recommended?
Daniel groups three sheets: Q1, Q2 and Q3, containing sales data. What will happen on deleting the data of cell B2 from sheet Q1?
Roger upgrades from Excel 2003 to 2010. He wants to run the PivotChart Wizard but has not installed the Classic menu for 2010. Which of the following is the correct way to add the PivotTable and PivotChart Wizard?
Mark inserts an image into a current worksheet. His client demands that the image should be attached with a cell and should resize when the cell is resized. Which of the following options is the correct Format Picture property, which will fulfil this requirement?
Which of the following options are true about a PivotTable calculated field?