USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Remove the table functionality from PreOrders. Retain the font and cell formatting.
|
|
click on name box, select PreOrders, click on table tools design tab, tools group, click convert to range, click yes
|
|
|
click on PreOrders table, click delete
|
|
|
formulas tab, defined names group, name manager, click on preorders, check font and cell formatting
|
|
|
click on PreOrders table, home tab, format painter drop down, retain the font and cell formatting
|
Explanation:
Detailed explanation-1: -To remove a chart’s data series, click “Chart Filters” and then click “Select Data.” Select the series in the Legend Entries (Series) box, and then select “Remove.” Click “OK” to update the chart.
Detailed explanation-2: -If you click a cell and then press DELETE or BACKSPACE, you clear the cell contents without removing any cell formats or cell comments. If you clear a cell by using Clear All or Clear Contents, the cell no longer contains a value, and a formula that refers to that cell receives a value of 0 (zero).
There is 1 question to complete.