By default how many worksheets are there in an MS-Excel workbook2007?

By default how many worksheets are there in an MS-Excel workbook2007? Correct Answer 3

The Correct Answer is "3".

Important Points

  • When we open an Excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3.
  • These are not very informative names.
  • Excel 2007 allows us to create a meaningful name for each worksheet in a workbook so we can quickly locate information.

 

                                                                                    Additional Information

To name a worksheet:

  • Right-click the sheet tab to select it.
  • Choose Rename from the menu that appears.
  • The text is highlighted by a black box.

 

                                                                                    [ alt="ex07 rename" worksheet src="https://media.gcflearnfree.org/ctassets/topics/143/ex07_rename.gif">

To insert a new worksheet:

  • Left-click the Insert Worksheet icon.
  • A new sheet will appear.
  • It will be named Sheet4, Sheet5, or whatever the next sequential sheet number may be in the workbook.
  • OR Press the Shift and the F11 keys on your keyboard.
  •  

                                                                        [ alt="ex07 insertsheet" worksheet src="https://media.gcflearnfree.org/ctassets/topics/143/ex07_insertsheet.gif">

Related Questions

By default Excel provides three worksheets. If you need only two of them, then how will you delete the third one ?
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
How many worksheets can a workbook have?