USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
On the home tab, in the editing group, click the editing group dialog box launcher.
|
|
|
On the Insert tab, in the Text group, click series.
|
|
|
On the Data tab, in the Forecast group, select what-If analysis and then click Series.
|
|
|
On the home tab, in the editing group, select Fill and then click Series.
|
Detailed explanation-1: -Which of the following methods is used to display the Series dialog box that is used to fill data in a range? On the Home tab, in the Editing group, select Fill and then click Series.
Detailed explanation-2: -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-3: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).
Detailed explanation-4: -Hold down the Ctrl+Alt+V keys (Command+Ctrl+V on the Mac) to invoke the Paste Special dialogue box again. Check the Transpose option and click OK. This will convert the columns to rows.
Detailed explanation-5: -Alignment Tab. You can position text and numbers, change the orientation and specify text control in cells by using the Alignment tab in the Format Cells dialog box.