USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ALT
|
|
|
CTRL
|
|
|
TAB
|
|
|
SHIFT
|
Detailed explanation-1: -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-2: -Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add information to multiple worksheets at the same time.
Detailed explanation-3: -The worksheets will be ungrouped. You can also click any worksheet not included in the group to ungroup all worksheets.
Detailed explanation-4: -Select all the data in the worksheet. Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C.