Question

Multiple Choice Questions:
4.
cell As of sheet1 has the formula to calculate the average of cells B3 to B6 from sheet2. What will be the
formula for the same?
a. AVERAGE(B3:36)
b. = AVERAGE(!'B3:06')
d. =AVERAGE(sheet2B3:36)
c. AVERAGE('sheet2!B3:36)
​

Answer 1

Answer:

the answer to this would be d part

Answer 2

The formula to calculate the average of cells B3 to B6 from sheet2 in sheet1 is =AVERAGE(sheet2!B3:B6)

c. =AVERAGE(sheet2!B3:36)

Let's fix the mistakes in the question

Cell as of sheet1 has the formula to calculate the average of cells B3 to B6 from sheet2. What will be the formula for the same?

a. =AVERAGE(B3:36)

b. =AVERAGE(!'B3:06')

c. =AVERAGE(sheet2!B3:36)

d. =AVERAGE(sheet2B3:36)

​

Explanation

In Excel, if you want to refer to cells of another worksheet then you can do so by writing the sheet name followed by the exclamation mark (!) and the cell range.

Example

=AVERAGE(sheet2!B3:36)

This formula means that the average is to be taken out from values present in the cell range of B3 to B6 of sheet2

Extra Information

In Excel, columns are named as A, B, C, D, E, F, and so on.

In Excel, rows are named as 1, 2, 3, 4, 5, 6, and so on.

Cells in an Excel sheet are made with intersections of rows and columns.

Cell Address is used to identify cell on an Excel Sheet and Cell Address comprises of a letter and a number. The letter shows the column and the number shows the row.

Example

A1

In this, it is the cell that is present in column A and row 1.

D6

In this, it is the cell that is present in column D and row 6.

Function is a predefined formula that allows users to perform mathematical, statistical, and logical operations.

There are various functions in Microsoft Excel some of them are:

1. SUM

2. AVERAGE

3. COUNT

4. IF

5. MAX

6. MIN

There are two formats by which you can apply Excel functions on cells.

1. Name of Function (Range of Cells i.e. Starting Cell : Ending Cell)

Example

=AVERAGE(A1:A3)

2. Name of Function (Each Cell Address separated with a comma(,))

Example

=AVERAGE(A1,A2,A3)

Example

Suppose you want to add values present in cells from A1 to A5 and display the sum in A6.

First, write the values in A1 to A5 and then click on A6 cell and type=SUM(A1:A5)

After that press "Enter"

In the A6 cell, you will get the sum of values present in cells from A1 to A5.

In case you have typed the wrong formula or want to modify it then you can click on the cell where you have written the formula and there will be a Formula Bar available above the worksheet area which will show the formula that you have written in the cell and you can edit it.