Microsoft Excel Module 2 Review

What is the most efficient way to adjust the width of a column to fit its content in Excel?

• Double-click the right border of the column header

• Right-click the column and select "AutoFit Column Width"

• Drag the column border to resize manually

• Both A and B

Which of these methods can you use to insert a new row in a worksheet?
Select all that apply.

• Right-click or access the context menu for a row number, select Insert

• Right-click or access the context menu for a column header, select Insert

• Right-click or access the context menu for a cell, select Insert Entire Row

• Home, Cells group, Insert > Insert Sheet Rows

Which of these methods can you use to set the width of a column in a worksheet?

• Double-click between a column divider to make it autofit

• Select the divider between 2 rows and drag up or down

• Right-click or access the context menu for a column header and select Row
  Height
  

  
  

• Select Format in the Cells group, and then select Row Height

How can you insert a new worksheet into a workbook?

• Press Ctrl + N

• Right-click an existing worksheet tab and select "Insert"

• Click the "+" icon next to the worksheet tabs

• Both B and C

What happens when you cut and paste data in Excel?

• The original data is copied and remains in place

• The original data is moved to the new location

• The original data is deleted permanently

• Only the formatting of the original data is pasted

What is the purpose of freezing panes in Excel?

• To make a worksheet read-only

• To keep certain rows or columns visible while scrolling

• to hide rows and columns temporarily

• To create a split screen view of the worksheet

How do you delete a worksheet in a workbook?

• Right-click the worksheet tab and select "Delete"

• Press the Delete key while the worksheet is selected

• Use the "Delete" option in the Home tab

• Both A and C

Which view would you select to see how a worksheet will look when printed?

• Page Layout view

• Normal view

• Custom view

• Page Break Preview

How can you save a workbook in a different format, such as .csv?

• Use the Save As option and select the desired format

• Change the file extension directly in the File Name box

• Use the Export option under the File menu

• Both A and C

Which of the following statements are true?
Select the correct option.

• The Quick Access Toolbar can be moved to beneath the ribbon.

• The Quick Access Toolbar cannot be reset to default settings.

• The Quick Access Toolbar cannot be moved beneath the ribbon.

• The Quick Access Toolbar cannot be hidden from view.