Question

What will be the result of the functions given as:=Average (A1,B1,C1) where A1=10,B1=20 AND C1 =30

Answer 1

it's 20
hopes it help you

Answer 2

(20) is the correct answer for the given above function= AVERAGE ( A1, B1, C1 ) on the behalf of a given value in the question :

Explanation:

• The Average function is used in the excel sheet or spreadsheet to find the Average value on the behalf of some cell data which is passed on the argument of the Average function.
• The syntax of the Average function is "Average (first_cell, Second_cell, third_cell)" or Average(firstcell:lastcell).
• So the above question holds the argument which is used to find the average value from A1, B1, and C1. These cells hold the value of 10,20 and 30.
• So when any user finds an average of 10,20 and 30, then the average is 20 because (10+20+30)/3=20 (it is a formula to find the average).

Learn More :

• MS-Excel Sheet :brainly.in/question/11921439