MO-211 practice question 27 of 35
How can you make sure that your workbook opens to the specific worksheet you choose?
Full set: 355 questionsDomain Manage slides
Microsoft Excel is designed to save the current state of a workbook, which includes the worksheet that is currently active or in view. When the workbook is subsequently opened, Excel restores this last saved state, automatically displaying the worksheet that was active when the file was last saved and closed. This is the standard, built-in method for controlling the initial view of a workbook without using macros or special settings.
A. The right-click context menu for recent workbooks does not provide an option to select a specific sheet to open.
B. The Sheet List or sheet navigation controls are used for switching between worksheets after the workbook is already open.
C. The position or order of a worksheet in the tab list does not determine which sheet is displayed when the workbook opens.
1. University of Wisconsin-Madison
Division of Information Technology (DoIT) KnowledgeBase: In the article "Excel - Opening a Workbook to a Specific Worksheet
" it states
"By default
an Excel workbook will open to the worksheet that was active when the workbook was last saved. To have a workbook open to a specific worksheet
you will need to make sure that worksheet is active when you save the workbook." (Document 99961
Published: 2020-03-03).
2. Microsoft 365 Documentation
Excel Object Model Reference: The Workbook.ActiveSheet property represents the active sheet in the workbook. This property is part of the workbook's view settings that are saved with the file. When a user saves the workbook
the reference to the currently active sheet is stored
and this state is restored upon reopening. (See documentation for the ActiveSheet property in the Microsoft.Office.Interop.Excel namespace).
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
