PrepAway - Latest Free Exam Questions & Answers

Which of the following views will you have to work on?

You work as a Sales Manager for Net World Inc. You are creating a sales report in Microsoft Excel
2010. You want to create the report while keeping an eye on how it will look in printed format.
Which of the following views will you have to work on?

PrepAway - Latest Free Exam Questions & Answers

A.
Normal

B.
Print Preview

C.
Page Layout

D.
Page Break

Explanation:
In order to fulfill the requirement of the question, you will have to work on Page Layout View.

The Page Layout View is one of the several views provided by Excel. This view was introduced in
Excel 2007 to enable users to create a worksheet while keeping an eye on how it will look in printed
format. Users can work with page headers, footers, margin settings in the worksheet in this view. It
also enables a user to place various objects, such as charts, at the place where the user wants to
print them.
Various page setup options are also available in this view. It enables users to quickly set the
worksheet page for printing purposes.
Answer A is incorrect. The Normal view will not allow you to work on your worksheet while showing
how it will appear in printed format.
Answer D is incorrect. Although the Page Break view will show the print breaks of the worksheet
pages, it will not provide different printing options to work on.
Answer B is incorrect. There is no such view as Print Preview in Excel 2010.


Leave a Reply