FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How do you select different areas of a worksheet at the same time?
A
Use the ALT key as you click to select other cells
B
Use the WINDOWS key as you click to select other cells
C
Use the F1 key as you click to select other cells.
D
Use the CTRL key as you click to select other cells
Explanation: 

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.

Detailed explanation-3: -We can use the Ctrl and Shift keys to select multiple sheets. Hold the Ctrl key and left-click sheet tabs to add them to the group of select sheets.

Detailed explanation-4: -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-5: -The Select All button sits at the upper left of all worksheets, at the origin of row and column labels. You can use the Select All button to quickly select all cells in a worksheet.

There is 1 question to complete.