Question

 (a)If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula? (b)Which function in Excel tells how many numeric entries are there ? (c)Which formula can we use to get the value that lies in the middle of range A2:A12 where data is sorted in Ascending order? (d)Which function is used to get the current date?​

Answer 1

Answer:

a)=average(B2:B20)

b)Use the COUNT function to get the number of entries in a number field that is in a range of numbers. Eg-: =Count (cell no. : cell no.)

c) Median

d) The NOW() function returns the current date and time

Hope you like the answer

plz mark me as brainliest

Answer 2

(a) If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula?

=AVERAGE(B2:B20)

(b) Which function in Excel tells how many numeric entries are there ?

COUNT

(c) Which formula can we use to get the value that lies in the middle of range A2:A12 where data is sorted in ascending order?

=MEDIAN(A2:A12)

(d) Which function is used to get the current date?

=TODAY()

Extra Information

In the COUNT function, you will have to mention the range same as it was mentioned in the AVERAGE and MEDIAN function.

For example, if entries are done from A1 to A5 and you have to apply COUNT function to find how many numeric entries are there then the formula will be like this:

=COUNT(A1:A5)

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

Format of writing a function in a cell of Excel Spreadsheet:

= Name of Function (Range of Cells)

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 which you have written in the cell and you can edit it.