USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
lock
|
|
|
manipulate
|
|
|
name
|
|
|
validate
|
Detailed explanation-1: -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-2: -Select the range you want to name, including the row or column labels. Select Formulas > Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Select OK.
Detailed explanation-3: -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.