Answer the following questions.
1. What do you mean by a formula? Give examples.
2. What is cell reference? Give its types.
3. What is function? Name some functions. 4. What are the two buttons present on the Formula bar.
5. Explain the AutoSum feature of Excel.
the Questions are from class 7 formulas and functions .
pls answer correctly
if there is spam then I will report.
whoever answers first will be BRAINLIEST
FAST. FAST. FAST. FAST
Answers
Answer:
1.The formula is a fact or a rule written with mathematical symbols. It usually connects two or more quantities with an equal to sign. When you know the value of one quantity, you can find the value of the other using the formula. Examples of formula: Perimeter of rectangle = 2(length + width)
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.A function is a group of statements that together perform a task. A function declaration tells the compiler about a function's name, return type, and parameters. Some functions are : sum(),area().
4.The left most is called as "Cell Name Box", middle one is "Formula Bar Buttons" and right one is the contents of the Active Cell
5.AutoSum is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. For example, if you wanted to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button (shown right).
Hope it helps you
Keep learning ✌️✌️