Question

Write the keyboard shortcuts:
1) Sum of the values of the Adjacent cells
2) To copy the formula from the above cell

Answer 1

Notes: 

The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.

A plus sign (+) in a shortcut means that you need to press multiple keys at the same time.

A comma sign (,) in a shortcut means that you need to press multiple keys in order.

Answer 2

Answer:

1)ALT =

Step 1: place the cursor below the column of numbers you want to sum (or to the left of the row of numbers you want to sum).

Step 2: hold down the Alt key and then press the equals = sign while still holding Alt.

Step 3: press Enter.

2)Ctrl + D - Copy a formula from the cell above and adjusts the cell references. For example, if you have a formula in cell A1 and you want to copy it to cell A2, select A2 and press Ctrl + D.