FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
how do you set a print area so that excel prints only that part of the worksheet?
A
select the area then select the Office button=>Print =>Quick Print
B
Select the area then click Print Area=>Set Print button on the Page layout tab
C
Select the area you want to print then click the Print button on the Quck Access Toolbar
D
there is not a way of doing this
Explanation: 

Detailed explanation-1: -On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Detailed explanation-2: -On the worksheet, click and drag to select the cells you want to print. Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.

Detailed explanation-3: -Print area in Excel is nothing but a pre-selected area in a spreadsheet that you want to be printed on paper. It defines the parts or cell ranges for printing. You can select multiple print areas in a worksheet. Each area will be printed on a separate page.

There is 1 question to complete.