Managing Worksheets and Workbooks in Excel

Which file extension is commonly used for Excel workbooks?

• .xls

• .docx

• .xlsx

• .pptx

Answer explanation

The correct file extension commonly used for Excel workbooks is .xlsx.

Which of the following keyboard shortcuts can be used to create a new worksheet in Excel?

• Ctrl+N

• Ctrl+S

• Ctrl+C

• Ctrl+W

Answer explanation

Ctrl+N is the correct keyboard shortcut to create a new worksheet in Excel.

Which Excel feature allows you to view and manage multiple workbooks simultaneously?

• PivotTables

• Conditional Formatting

• Data Validation

• Excel's Window Arrangement options

Answer explanation

Excel's Window Arrangement options allow you to view and manage multiple workbooks simultaneously in Excel.

How can you ungroup grouped worksheets in Excel?

• Right-click on one of the grouped worksheet tabs and select "Ungroup Sheets".

• Click on the "Ungroup Sheets" button in the Ribbon.

• Press Ctrl+Shift+U on the keyboard.

• Grouped worksheets cannot be ungrouped

Answer explanation

To ungroup grouped worksheets in Excel, right-click on one of the grouped worksheet tabs and select 'Ungroup Sheets'.

What is the purpose of using workbook properties in Excel?

• To adjust the appearance of worksheets.

• To view details such as file size, last modified date, and author information.

• To calculate formulas across multiple worksheets.

• To insert comments and annotations in the workbook

Answer explanation

The purpose of using workbook properties in Excel is to view details such as file size, last modified date, and author information.

When saving a workbook for the first time, which file format should you choose for compatibility with newer versions of Excel?

• .xls

• .docx

• .xlsx

• .pdf

Answer explanation

Choose .xlsx file format when saving a workbook for the first time for compatibility with newer versions of Excel.

How can you copy a worksheet within the same workbook in Excel?

• Right-click on the worksheet tab and select "Copy".

• Select the worksheet tab, press Ctrl+C, then Ctrl+V to paste.

• Right-click on the worksheet tab, select "Move or Copy...", then choose the location and click "Copy".

• There is no way to copy a worksheet within the same workbook

Answer explanation

To copy a worksheet within the same workbook in Excel, you should right-click on the worksheet tab, select 'Move or Copy...', then choose the location and click 'Copy'.

What is the purpose of saving a workbook as a backup copy?

• To automatically update changes made to the workbook.

• To create a duplicate copy of the workbook for archival purposes.

• To reduce the file size of the workbook.

• To permanently delete the original workbook

Answer explanation

Saving a workbook as a backup copy is done to create a duplicate copy of the workbook for archival purposes, not to update changes, reduce file size, or delete the original workbook.

What is the purpose of grouping worksheets in Excel?

• To merge the contents of multiple worksheets into one.

• To hide certain worksheets from view.

• To allow for simultaneous editing of multiple worksheets.

• To automatically sort data across multiple worksheets

Answer explanation

Grouping worksheets in Excel allows for simultaneous editing of multiple worksheets, making it easier to work on related data across different sheets.

Which of the following is the correct method to rename a worksheet in Excel?

• Right-click on the worksheet tab and select "Rename".

• Double-click directly on the worksheet tab.

• Click on the worksheet tab and press F2.

• All of the above

Answer explanation

The correct method to rename a worksheet in Excel is to right-click on the worksheet tab and select 'Rename', double-click directly on the worksheet tab, or click on the worksheet tab and press F2.