Question

Give examples for the following.
1. cell address. _________________
,________________
2. Mathematical functions. _______________ ,
________________________
3. Absolute cell reference. _____________ , ____________
4. Statistical functions. ____________ , ______________
5. Mixed cell reference. _____________ , ______________
​

Answer 1

1. First column, seventh row: A7, Tenth column, twentieth row: J20.
2. x2 (squaring) is a function.
3. x3+1 is also a function.
4. Sine, Cosine and Tangent are functions used in trigonometry.
5. Absolute column and absolute row reference. =$A$2.
6. Relative column and absolute row reference. =A$2.
7. Logistic regression, Polynomial regression
8. A mixed reference is a reference that refers to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column

Answer 2

Answer:

chff

dhdh

dhdh

didhd

dhag

Yahoo

it'll

ISSN

off

Haan