Computer Science
Class-VII
Chapter-8 Formulas in MS-Excel
A. Fill in the blanks:
1. In case, a number is too big to be properly displayed in its cell, MS-Excel displays a series of ______________.
Answer: #####
2. In case, you enter 4*4 in a cell, Excel will display___________.
Answer: 16
3. Function in MS-Excel consist of a function name and ____________.
Answer: Function arguments
4. All formulas start with the _____________ sign.
Answer: =(equal)
5. ____________ are predefined formulas.
Answer: Functions
B. Write whether true or false:
1. In MS-Excel all the formulas start with the '=' sign.
Answer: True
2. In MS-Excel, the formula =A5+A6 is not the same as =a5+a6.
Answer: False
3. The SUM function has more than one argument.
Answer: True
4. MS-Excel does not make an exact copy of a formula.
Answer: False
5. In MS-Excel, function arguments are enclosed within a square bracket.
Answer: False
C. Tick the correct option:
1. References to cells in other workbooks are called
a. external references b. remote references
Answer: external references
2. References to data in other programs are called
a. external references b. remote references
Answer: remote references
3. It identifies a cell or a range of cells in a worksheet.
a. Operator b. Reference
Answer: Reference
D. Answer the following questions:
1. Explain elements of the formula.
Answer: Elements of the formula are:
1. Value
2. Cell Address
3. Function
4.Operator
5. Parenthesis
2. How can you use the reference? Write about external and remote reference.
Answer: Use cell references in a formula:
1. Click the cell in which you want to enter the formula.
2. In the formula bar type = equal sign.
3. Select the cell that contains the value you want
4.Press enter.
Reference to cells in other workbooks are called external references.
References to data in other programs are called remote references.
3.What do you mean by concatenation?
Answer: The process of linking text values in a series within formulas is called concatenation.
Example: ="Computer" & "Science"
Result: Computer Science
4. What do you mean by 'precedence of operators'?
Answer: The results of the formula are calculated based on an order of precedence. The following table shows the order of precedence:
( ) - Parenthesis
^ - Exponent
* - Multiplication
/ - Division
+ - Addition
- - Subtraction
5. What is a function?
Answer: Functions are predefined formulas that perform specific calculations. For example:
SUM()
AVERAGE()
MAX()
MIN()
6. What do you know about the AutoSum feature of MS-Excel?
Answer: The AutoSum button will total the values above the destination cell or in the row to the left of the destination cell.
You may like:
No comments:
Post a Comment