Chapter 5 Excel sections 2-5

Which option do you select to create a new workbook in Excel?

• File > New > Blank workbook

• File > Open > New Workbook

• File > Save As > New Workbook

• File > New > Open Workbook

How can you insert a new worksheet in an existing workbook?

• Right-click a tab and select "Insert"

• File > New > Worksheet

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

• Edit > Insert > New Worksheet

What is the shortcut key to enter the current date in a cell?

• Ctrl + D

• Ctrl + ;

• Ctrl + Shift + ;

• Alt + D

Which feature can you use to protect a worksheet from being edited?

• File > Options > Protect Workbook

• Review > Protect Sheet

• Home > Format > Protect Sheet

• Data > Protect Workbook

How can you set a print area in Excel?

• File > Print > Set Print Area

• Page Layout > Print Area > Set Print Area

• View > Page Break Preview > Set Print Area

• Insert > Print Area > Set Print Area

Which option allows you to change the cell format to currency?

• Home > Number > Currency

• Data > Currency

• Insert > Currency

• Review > Currency

How can you rename a worksheet?

• Double-click the sheet tab and type the new name

• Right-click the sheet tab, select "Rename", and type the new name

• File > Options > Rename Sheet

• Both A and B are correct

What is the shortcut for saving a workbook?

• Ctrl + S

• Ctrl + W

• Ctrl + N

• Ctrl + B

How do you apply conditional formatting to a cell?

• Home > Styles > Conditional Formatting

• Data > Conditional Formatting

• Insert > Conditional Formatting

• View > Conditional Formatting

What is the shortcut key to select the entire worksheet?

• Ctrl + A

• Ctrl + Shift + A

• Ctrl + Alt + A

• Alt + A