Question

Write the excel formula for the following

a) Mixed referencing fixing the row as 10

b) Find the maximum in the A8 to A30

c) To find the values that exists in the range D4 to F8​

Answer 1

Explanation:

+= (Mac) into a cell, and Excel automatically inserts the SUM function. Here's an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum.

Answer 2

Answer:

+= (Mac) into a cell, and Excel automatically inserts the SUM function. Here's an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum.