Workbook Management

What is the first step in creating a new workbook?

• Click on the 'New Workbook' button.

• Save the current workbook.

• Open the software application

• Close the software application.

How can you manage workbook properties in Excel?

• By going to the 'File' tab, clicking on 'Info', and selecting 'Properties'.

• By navigating to the 'View' tab and clicking on 'Workbook Properties'.

• By right-clicking on the workbook and choosing 'Properties'.

• By accessing the 'Format' tab and selecting 'Workbook Properties'.

What is the process of adding worksheets to a workbook called?

• sheet inclusion

• worksheet addition

• workbook expansion

• worksheet insertion

How can you rename a worksheet in Excel?

• Right-click on the sheet tab, select 'Rename', and type in the new name

• Press 'Ctrl + R' and enter the new name.

• Go to the 'File' tab, select 'Rename Worksheet', and enter the new name.

• Double-click on the sheet tab and type in the new name.

What is the term used for removing worksheets from a workbook?

• eliminating

• clearing

• deleting

• erasing

What is the purpose of creating a new workbook in Excel?

• To start a new file and work with data, calculations, and visualizations.

• To import data from another source.

• To organize data in a different format.

• To create a backup of an existing workbook.

Why is it important to manage workbook properties?

• To decrease the efficiency of workbooks

• To organize and categorize workbooks, improve searchability, enable version control, enhance document security, and facilitate collaboration.

• To make workbooks more difficult to access

• To increase the file size of workbooks

What is the shortcut key to add a new worksheet in Excel?

• Ctrl + N

• Alt + F11

• Shift + N

• Ctrl + Shift + N

• Shift + F11

How can you delete a worksheet in Excel?

• Press the 'Delete' key on your keyboard.

• Go to the 'File' menu and select 'Delete Worksheet'.

• Right-click on the sheet tab and select 'Delete'

• Drag the sheet tab to the Recycle Bin icon.

What happens when you delete a worksheet in Excel?

• The worksheet is saved as a separate file.

• The worksheet is permanently removed from the workbook and all data/formatting is lost.

• The worksheet is moved to the Recycle Bin.

• The worksheet is hidden but can be restored.