Question

Which of the following statement is INCORRECT with reference to workbooks in MS Excel?
1. A workbook is made up of worksheets.
2. Worksheets are labeled Sheet1, Sheet2 and Sheet3 and so on.
3. The name of a worksheet cannot be changed in MS Excel.
4. Each Microsoft Excel worksheet is made up of columns and rows.

Answer 1

Correct Answer - Option 3 : The name of a worksheet cannot be changed in MS Excel.

The correct answer is The name of a worksheet cannot be changed in MS Excel.

• A workbook is made up of worksheets.
• Worksheets are labelled Sheet1, Sheet2 and Sheet3, and so on.
• The name of a worksheet can be changed in MS Excel.
• Each Microsoft Excel worksheet is made up of columns and rows.

Some important shortcuts used in MS Excel:

• Ctrl + N Create a new workbook.
• Ctrl + O Open an existing workbook.
• Ctrl + S Save the active workbook.
• F12 Save the active workbook under a new name, displays the Save as dialog box.
• Ctrl + W Close the active workbook.
• Ctrl + C Copy the contents of the selected cells to Clipboard.
• Ctrl + X Cut the contents of the selected cells to Clipboard.
• Ctrl + V Insert the contents of the Clipboard into the selected cell(s).