Question

1. To add the numbers in given range of cells​

Answer 1

Answer:

Here's a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You'd press Enter to get the total of 39787.

Answer 2

Answer:

Explanation:

ANSWER :-

Add With Paste Special

To increase the amounts in a range of cells -- adding the same amount to each cell -- you can use the Paste Special command.

For example, follow these steps to increase the amounts by 10, in cells A2:B6

• In an empty cell, type 10, then copy that cell

• Select cells A2:B6

• On the Ribbon, click the Home tab

• Click the Arrow below the Paste button, and click Paste Special -- or use the shortcut keys -- Ctrl+Alt+V
• In the Paste Special window, under Operation, click Add, then click OK
• All the numbers increase by 10
• Clear the cell where you typed the 10