W NH
What do you mean by concatenation?
What is a Formula? Explain with the help of an example.
What is Cell Reference? Mention its types.
What do you mean by Function? Name some of the functions.
What are the rules to enter a function?
Answers
Answer:
1.) Concatenate, concatenation, or concat is a term that describes combining a string, text, or other data in a series without any gaps. In programming languages, an operator is used to denote concatenation.
2.)A formula is an expression telling the computer what mathematical operation to perform upon a specific value. ... In the picture below is an example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the total of cells A1, A2, and A3. In this formula, SUM is the function of the formula.
3.)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.
4.): 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. A function definition provides the actual body of the function.
5.)Functions are usually represented by a function rule where you express the dependent variable, y, in terms of the independent variable, x. A pair of an input value and its corresponding output value is called an ordered pair and can be written as