USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Borders
|
|
|
Cell Style
|
|
|
Conditional Formattting
|
|
|
Format as Table
|
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: -Apply the Top and Bottom Border to the selected cells with a single command. On the Home tab, in the Font group, click the Borders button arrow, and select Top and Bottom Border.
Detailed explanation-3: -A cell style includes a set of formats such as font, font size, number format, cell borders and cell shading. You can also lock cells using cell styles.
Detailed explanation-4: -The Percentage format displays the cell value with a percent symbol. The only option that you can change is the number of decimal places. To quickly apply the Percentage format with no decimal places, use the Ctrl+Shift+% shortcut.