DATABASE FUNDAMENTALS
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: -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-4: -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.
Detailed explanation-5: -Inserting Sum into Excel Using the Alt Code To use a shortcut instead, hold down the Alt key, then type ALT+2+2+8 (Alt 228) to insert the sum () symbol.