FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The shortcut key for AutoSUM is:
A
Ctrl + =
B
Alt =
C
= SUM
D
Shift +
Explanation: 

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.

There is 1 question to complete.