Answer these questions in properly correct way:
1) Define Function Argument.
2) Write the name of different types of cell adresses.
3) What are functions in Excel?
4) How mixed cell address is different from Relative cell address?
5) Define the use of the following :
a) Sum()
b) Min()
c) Count()
d) Average()
e) Power
Hope you all will anwer my questions, have a nice day.
Answers
Answer:
1) In mathematics, an argument of a function is a value that must be provided to obtain the function's result. It is also called an independent variable. For example, the binary function has two arguments, and , in an ordered pair . The hypergeometric function is an example of a four-argument function.
2) There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied
3) Seven Basic Excel Formulas For Your Workflow
SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments. ...
AVERAGE. The AVERAGE function. ...
COUNT. The COUNT function. ...
COUNTA. Like the COUNT function, COUNTA. ...
IF. The IF function. ...
TRIM. The TRIM function. ...
MAX & MIN. The MAX.
4) Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
5) a) The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel. SUM helps users perform a quick summation of specified cells in MS Excel. ... We can use the function to find out the total cost of the event.
b) The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values. Get the smallest value. The smallest value in the array.
c) Counting various quantities is the foremost human activity in which children engage beginning at a very tender age. The main property of counting is so fundamental to our perception of quantity that it is seldom enunciated explicitly. The purpose of counting is to assign a numeric value to a group of objects.
d) Learning about average helps us to quickly summarize the available data. The large set of marks of the students, the changing price of the stocks, the weather data of a place, the income of different people in a city, are all examples for which we can calculate an average.
e) We can define power as the rate of doing work, it is the work done in unit time. The SI unit of power is Watt (W) which is joules per second (J/s). Sometimes the power of motor vehicles and other machines is given in terms of Horsepower (hp), which is approximately equal to 745.7 watts.