1. Which of the following symbol is used to to concentration of a string?
Ans- Ampersand (&)
2. These are built in formulas.
Ans- functions
3. It is the default cell reference in MS Excel.
Ans- Absolute.
4. This formula error indicates that the formula contain and invalid data.
Ans-#Value!.
5. Go to some function is present on this tab.
Ans-HOME.
B. FILL IN THE BLANKS.
1. If formula must begin with an = (equal to) sign.
2. In absolute referencing, a $(doller) sign is used before the column letter and row number.
3. The the the max function is used to find the highest numeric value in a range.
4. Mixed reference is a blend to relative and absolute reference.
5.The round() function return the rounded number to the next lowest integer value.
C write true and false statements.
1. In excel, you can perform operational like addition, subtraction or multiplication on text value or text string.false
2. Circular difference is a type of cell reference true.
3. Joining two or more text value is known as concatenation true.
4. A function also start with an equal to sign.true
5. You cannot perform average function using autosum feature false.
D. Answer the following questions.
1.Define the term formula.list of list the rule of write a formula in Excel.
Ans-A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.
2. Name the type of cell reference define anyone.
Ans-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. What do you understand by function question mark write the rule of enter a function.
Ans-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 (a, b).
4. Define the term or two some. Name some operations that can be performed using this feature.
Ans-The Autosum is used to add, average, number count, maximum, minimum values of the selected range of rows or cells together and the result is displayed in the cell below the range selected. dome7w and 1 more users found this answer helpfu.
5. Describe the use of function library.
Ans-Library functions in C language are inbuilt functions which are grouped together and placed in a common place called library. Each library function in C performs specific operation. We can make use of these library functions to get the pre-defined output instead of writing our own code to get those outputs.
Comments
Post a Comment