FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To set an area of the sheet that you would like to print go to:
A
Page Layout
B
Page Layout
C
Page Layout
D
Page Layout
Explanation: 

Detailed explanation-1: -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: -Select the range of cells that you want to set as the print area in that Excel worksheet. Go to Page Layout –> Page Setup –> Print Area –> Set Print Area. This would set the selected cells as the print area. It also creates a named range for the selected area (the name Print Area would be visible in the Name Box).

Detailed explanation-3: -The default print area in Excel in portrait orientation includes columns A to J or rows 1 to 50. In landscape orientation, it ranges from columns A to O or rows 1 to 33.

There is 1 question to complete.