USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl + =
|
|
|
Alt =
|
|
|
= SUM
|
|
|
Shift +
|
Detailed explanation-1: -AutoSum is a fast, easy way to add up multiple values in Excel. You can access the AutoSum command from either the Home tab or the Formulas tab, but there is a keyboard shortcut that makes it even faster: Alt+=. To use this shortcut, simply hold down the Alt key, then press the equals sign on your keyboard.
Detailed explanation-2: -Horizontal Auto Sum in Excel Now, press the Excel SUM formula shortcut key, “Alt + =, ” to arrive at the AutoSum. As we can see, it has applied the Excel SUM formula shortcut to the beside cell of the selected cells.
Detailed explanation-3: -To sum a row of numbers, select the cell immediately to the right. AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum.
Detailed explanation-4: -In Microsoft Excel programs, pressing Alt + A opens the Data tab in the Ribbon. Once in the Data tab, after pressing the shortcut, you’ll also have the option to press an additional key to select a Data tab option.
Detailed explanation-5: -In Excel 2013, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box.