DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Page Layout
|
|
Page Layout
|
|
Page Layout
|
|
Page Layout
|
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.