Question

1. Write the function that can be used to calculate the total of five subjects given in five different
cells.
2. Writo function that can calculate the lowest of the marks given.
3. Write the cell address formed by intersection of row 18 and column Z
4. Write cell reference for fixed column A and relative row 5.
5. Write cell reference for both column C and Row 6 fixed.​

Answer 1

Answer:

1 ==> use formula

=(cell1+cell2+cell3+cell4+cell5)

cell1 and cell1 etc. are the name of the cells like d1 d2 etc.

2 ==> You can find this minimum value by graphing the function or by using one of the two equations. If you have the equation in the form of y = ax^2 + bx + c, then you can find the minimum value using the equation min = c - b^2/4a.

3 ==> Cell formed by intersection of row 18, and column Z is Z18.

4 ==> Reference (Fixed Column and relative row) formed by row 134 and column BD is $BD134.

5 ==> A key element of a formula is the cell reference, and there are three types: Relative. Absolute. Mixed.........☺

Explanation:

❤❤