Question

10. Write the formula that displays the sum of the cell range C3 to C7 of sheet 1 in cell C5 of sheet 2

Answer 1

Answer:

=Sheet1!C3 + Sheet1!C4 + Sheet1!C5 + Sheet1!C6 + Sheet1!C7

Explanation:

In Microsoft Excel spreadsheet, rows and columns are key components in defining the exact location of any cell. Usually the columns are represented in alphabets (column letter) A, B, C, D, E, F, G, etc and the rows are in numerical order.

As per question adapt the following procedure;

First, go in sheet2, double click on cell C5, put equal sign and now go to sheet1 and select C3, then plus sign and then C4, C5, C6 and C7 accordingly.

Its formula is;

=Sheet1!C3 + Sheet1!C4 + Sheet1!C5 + Sheet1!C6 + Sheet1!C7

Answer 2

Answer:

sheet 1 ! C3 + sheet 1! C4+ sheet 1!C5 +sheet! 1C6+ sheet! 1 C7.