USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
click on A9 in the correct worksheet, insert tab, text, object, create from file, click on New Flavors.txt
|
|
|
click on A9 in the correct worksheet, data tab, get external data group, from text, click next then finish
|
|
|
all of the above are correct
|
|
|
None of the above
|
Detailed explanation-1: -The Paragraph group of the Home tab contains the commands to set the alignment, text direction, and line spacing of the paragraphs. It also has the commands for creating a bulleted or numbered list.
Detailed explanation-2: -On the Qtr 1 worksheet, click on any cell in the table to select the table. 2. On the TABLE TOOLS DESIGN tab, in the Table Style Options group, click the Total Row to enable it.
Detailed explanation-3: -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-4: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.