DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Your answer in False. You cannot delete a worksheet from a workbook if that workbook is being shared. You can remove the active worksheet by selecting (Edit > Delete Sheet). You can quickly insert a new worksheet before the active sheet by using the shortcut key (Shift + F11).
Detailed explanation-2: -On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet. Tip: You can also right-click the sheet tab of a worksheet or a sheet tab of any selected worksheets that you want to delete, and then click Delete Sheet.
Detailed explanation-3: -first statement is false . A worksheet can delete from a workbook.
Detailed explanation-4: -In MS-Excel, the address of any cell starts with “A1‟. Hence statement 2 is false.