DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use the ALT key as you click to select other cells
|
|
|
Use the WINDOWS key as you click to select other cells
|
|
|
Use the F1 key as you click to select other cells.
|
|
|
Use the CTRL key as you click to select other cells
|
Detailed explanation-1: -Pressing CTRL+A a second time selects the entire worksheet. Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection.
Detailed explanation-2: -Click the tab for the first sheet, then hold down CTRL while you click the tabs of the other sheets that you want to select. By keyboard: First, press F6 to activate the sheet tabs. Next, use the left or right arrow keys to select the sheet you want, then you can use Ctrl+Space to select that sheet.
Detailed explanation-3: -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-4: -To view four different sections of the same worksheet simultaneously, split your screen both vertically and horizontally. For this, select the cell above and to the left of which the split should appear, and then use the Split command.