FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following views shows how a worksheet will appear when printed?
A
page layout view
B
page break preview
C
normal view
D
reading view
Explanation: 

Detailed explanation-1: -Page Layout view shows you the position of your worksheet as it will appear on a printed page. One of the features of Page Layout view is the Ruler which shows the size of the margins and allows you to drag the margins in or out to change the amount of the worksheet shown on the page.

Detailed explanation-2: -To view a page in Page Layout View, first you need to click the worksheet that you want to change in this view and then on the ‘View’ tab click ‘Page Layout View’ which is found under the ‘Views’ group.

Detailed explanation-3: -Page layout: Used to create documents with a more custom design, like newsletters, books or posters. A page layout document is like a canvas that you add text boxes, images and other objects to, then arrange the objects on the page however you like.

Detailed explanation-4: -The Print Area is the area or range of cells that will be printed. A page break defines where one page ends and another one begins. You can see the range of cells that will be printed by selecting (View > Page Break Preview).

Detailed explanation-5: -Select the worksheet that you want to modify. On the View tab, in the Workbook Views group, click Page Break Preview.

There is 1 question to complete.