Answer the following questions.
1. Define a formula.
2. What is the result if in a formula any cell has a missing or invalid value?
3. Which symbol is used before column/row to change relative reference to
absolute reference?
4. What is cell referencing? Write names of different types of referencing.
5. Explain different components of a chart.
plz...answer all the questions.
Answers
Answer:
Q.1.Ans: 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.
Q.3. Ans: If you do not want cell reference to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.
Hope it helps you little..
Answer:
1) A formula is a method by which new values can be obtained from an existing range of values.
2) An invalid value or wrong number of values being specified as argument to a function can cause a cell to show the #VALUE! error. For example entering =if(“a”,1,0) will result in a #VALUE!
3) $
If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.
4) 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.
5) The different components of a chart are: Chart Area — Chart area includes all the area and objects in the chart. Category Axis — Category axis or X-axis is the horizontal axis of a chart. Value Axis — Value axis or Y-axis is the vertical axis used to plot the values.
hope this will help
Request:
Please mark me as the brainliest