USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
One
|
|
Two
|
|
Three
|
|
Four
|
Detailed explanation-1: -Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
Detailed explanation-2: -First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.
Detailed explanation-3: -Using a Sheet View This is another entry point for Sheet Views. When you’re ready to display a particular view, you can select it from the Sheet View menu. The Sheet View menu only displays views for the active worksheet. When a Sheet View is applied, an eye symbol appears next to the worksheet tab name.