QE-Ans.pdf

Questions of EEE with Answers 1. In MS Excel, to create a blank workbook, click the File tab and then click: New. 2. In MS Excel, to display a particular worksheet, click the worksheet’s tab on the: tab bar below the grid of cells. 3. In MS Excel, to create a ne...

Questions of EEE with Answers 1. In MS Excel, to create a blank workbook, click the File tab and then click: New. 2. In MS Excel, to display a particular worksheet, click the worksheet’s tab on the: tab bar below the grid of cells. 3. In MS Excel, to create a new worksheet, click: the Insert Worksheet button at the right edge of the tab bar. 4. In MS Excel, to change a worksheet’s name: double-click the worksheet’s tab on the tab bar. 5. In MS Excel, to change a worksheet’s location in the workbook: drag its tab to the desired location on the tab bar. 6. In MS Excel, to display the Move Or Copy dialog box: right-click the worksheet’s tab and then click Move Or Copy on the shortcut menu. 7. In MS Excel, to move or copy a worksheet: right-click the worksheet’s tab and then click Move Or Copy on the shortcut menu. 8. In MS Excel, to delete a worksheet: right-click the worksheet’s tab and then click Delete on the shortcut menu. 9. In MS Excel, the simplest way to enter data is to: click a cell and type a value. 10. In MS Excel, to enter a series of values, using AutoFill method: enter the first value in a recognized series and use the fill handle to extend the series. 11. In MS Excel, to enter a series of values, using FillSeries method: enter the first two values in a series and use the fill handle to extend the series. 12. In MS Excel, to enter data, using AutoComplete method: type the first few letters in a cell, and if a similar value exists in the same column, Excel suggests the existing value. 13. In MS Excel, to enter data, using Pick From Drop-Down List method: right-click a cell, click Pick From Drop-Down List, and select the value from the list. 1 14. In MS Excel, the AutoFill Options button appears when the user adds data to a worksheet by using: the fill handle. 15. In MS Excel, to display a list of actions Excel can take regarding the cells affected by dragging the fill handle, click: the AutoFill Options button. 16. In MS Excel, to copy or cut an entire column and paste it elsewhere in the worksheet: click the column’s header at the top of the worksheet. 17. In MS Excel, to locate specific data in a worksheet, use: the Find page of the Find and Replace dialog box. 18. In MS Excel, to substitute one value in a worksheet for another, use: the Replace page of the Find and Replace dialog box. 2