Microsoft Excel 2021365 - Beginner to Advanced - Setting and Clearing the Print Area

The video tutorial explains how to print specific sections of a spreadsheet by setting a print area. It covers the steps to set and clear a print area using the Page Layout ribbon and discusses the creation of a named range called Print_Area. The tutorial also demonstrates how to print a selection without setting a print area permanently and highlights the importance of clearing the print area to print the entire spreadsheet again.

What is the primary purpose of setting a print area in a spreadsheet?

• To highlight important data

• To delete unwanted data

• To change the font style

• To print only specific sections or rows

What happens when you set a print area in a spreadsheet?

• The font size is increased

• The spreadsheet is automatically saved

• A new worksheet is created

• A named range called Print_Area is created

How can you clear a previously set print area to print the entire spreadsheet again?

• By changing the font color

• By saving the spreadsheet with a new name

• By restarting the spreadsheet application

• By selecting 'Clear Print Area' in the Page Layout ribbon

What option should you choose in the print settings to print only the currently selected cells?

• Print entire workbook

• Print active sheets

• Print selection only

• Print all pages

What must you do to revert back to printing the entire sheet after printing a selection?

• Delete the selected cells

• Restart the computer

• Select 'Print active sheets' in the print settings

• Change the page orientation