a) 254
b) 255
c) 256
d) No limit
Check Answer
The maximum number of sheets that can be added to a workbook in Excel is 255, and any of these sheets can be set as the default sheet that is displayed when the workbook is opened.
To set a default sheet in a workbook, you can right-click on the sheet tab and select the “Move or Copy” option. In the “Move or Copy” dialog box, you can select the “Create a copy” checkbox, and then choose the “(new workbook)” option in the “To book” dropdown menu. This will create a copy of the sheet in a new workbook, and set it as the default sheet.
The correct answer is b) 255.
To set a default sheet in a workbook, you can right-click on the sheet tab and select the “Move or Copy” option. In the “Move or Copy” dialog box, you can select the “Create a copy” checkbox, and then choose the “(new workbook)” option in the “To book” dropdown menu. This will create a copy of the sheet in a new workbook, and set it as the default sheet.
The correct answer is b) 255.
Related:
- Which of the following is not a basic step in creating a…
- We can save and protect the workbook by
- To save a workbook
- Each excel file is called a workbook because
- An excel workbook is a collection of
- Which of the following is an invalid statement?
- A typical worksheet has _____number of columns in Excel 2019
- A worksheet can have a maximum __ number of rows in Excel…
- When creating a vertical page break
- How many worksheets can a workbook have ?
- Which of the following options is not located in the Page…
- Which of the following is not a term of MS Excel?
- In Excel, by default Numeric Values appears in
- Excel files have a default extension of
- MS-Excel provides the default value for steps in the Fill…