DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION 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: -3 ways to rename a worksheet Double-click the sheet tab, and type the new name. Right-click the sheet tab, click Rename, and type the new name. Use the keyboard shortcut Alt+H > O > R, and type the new name.
Detailed explanation-2: -Rename a worksheet Double-click the sheet name on the Sheet tab to quickly rename it.
Detailed explanation-3: -Navigation. To quickly navigate through a worksheet, use a double-click shortcut. Excel will select a cell in that row or column, moving in the direction that you clicked. It stops at the cell just before the first blank cell.
Detailed explanation-4: -By clicking the sheet tabs at the bottom of the Excel window, you can quickly select one or more sheets. To enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a selection of sheets at the same time.