Quiz & Worksheet - How to Set a Print Area in Excel

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Under which menu in the ribbon will you find the Print Area command?

File Page Setup Print Setup

Page Layout Data

Worksheet

Print Setting a Print Area in Excel Worksheet

1. What are the steps if you need to remove the Print Area settings?

File>Print>Clear
File>Clear Print Settings
Page Setup>Print Area>Clear Print Area
Page Setup>Clear Print Area
None of these answers are correct

2. Which statement is true about the Set Print Area command?

Once you set the print area, each time you print, only that area will be printed - until you clear the print area.
The print area you select and set only applies to that particular worksheet in the workbook.
You can clear the print area using the Clear Print Area command.
By default, Excel prints the entire worksheet.
All of these answers are correct

Create your account to access this entire worksheet

A Premium account gives you access to all lesson, practice exams, quizzes & worksheets

Access to all video lessons

Quizzes, practice exams & worksheets

Certificate of Completion

Access to instructors

Create an account to get started Create Account

About This Quiz & Worksheet

A print area in Excel refers to the relevant columns that you would like to print and not the columns with extraneous information which you do not wish to print. This quiz and worksheet combination will help you test your knowledge on setting a print area. The questions on the quiz will test you on the relevant menus in Excel, the steps to remove print area settings, and the print area command.

Quiz & Worksheet Goals

In these assessments, you'll be tested on:

The relevant menus you will need to use in this process
Steps to set and remove a print area
Where to view the appearance of the printed document

Skills Practiced

This quiz and worksheet will allow you to test your skills in the following areas:

Reading comprehension - ensure that you draw the most important information on print areas from the related lesson
Making connections - use your understanding of Excel to better understand the relevant menus
Information recall - access the knowledge you've gained regarding print areas in Excel

Additional Learning

To learn more about setting a print area in Excel, review the accompanying lesson Setting a Print Area in Excel on this topic. This lesson covers the following objectives:

Define a print area as a tool you can use to print only the information you need in Excel
Discuss how to define a print area
Describe the process used to set and clear a print area
Explore the relevant menus

Practice Exams

Final Exam