In a formula B4*$C$2, the contents of column B will change and contents of column C will______ change.
Answers
Answer:
CHAPTER 2 – FORMULAS AND FUNCTIONS IN MS-EXCEL
Fill in the blanks with given hints :
1. If a cell has D8 cell address, D refers to column number.
2. MIN( ) function is used to find minimum value.
3. Σ is the sign of sum button.
4. Referencing are of three types; Absolute, Relative and Mixed.
Write True or False :
1. A formula starts with @ sign. False
2. A formula cannot be copied from one workbook to another. True
3. A formula can be set only for column values and not for row values. False
Match the following :
1. SUM( ) ————– Function
2. Use Formula ——- For calculations
3. Ctrl + C ————- Copy a cell
4. Ctrl + Z ————- To undo last action
5. A1 : D36 ———— Range
Tick the best answer :
1. A formula starts with ………. sign. Answer : (a) =
2. A formula from a cell can be copied using ………….. keys. Answer : (b) Ctrl + C
3. A formula can be pasted using …………… keys. Answer : (d) Ctrl + V
4. In referencing, the …………. sign is used. Answer : (c) $
5. In a formula B4*$C$2, the contents of column B will change and contents of column C ……………. . Answer : (b) will not change
6. Which is not the type of referencing ? Answer : (d) Group
Answer the following :
1. What are the steps of copying contents of a cell ?
Answer 1. Steps to copy the contents of a cell are as follows :
i- Select the contents of a cell that you want to copy.
ii- On the Home tab. in the Clipboard group, click Copy,
iii- Select the cell where you want to paste the value.
iv- On the Home tab, in the Clipboard group, click the arrow below Paste and click Values.
2. What are the steps of copying a formula applied in a cell ?
Answer 2. Steps to copy a formula applied in a cell are as follows :
i- Select the formulas that you want to copy.
ii- On the Home tab, in the Clipboard group, click Copy.
iii- Select the cell where you want to paste the formula.
iv- On the Home tab, in the Clipboard group, click the arrow below Paste and click formulas.
3. What is a formula ?
Answer 3. A formula is an equation that can perform calculations, return information, manipulate the contents of other cells, test conditions and more. It consists of cell address, number, mathematical operations and letters.
4. What is a function ?
Answer 4. A function is a pre-defined formula that performs calculations by using specific values, called arguments, in a particular order or structure. It can do simple as well as complex calculations.
5. Name any two functions used in MS-Excel ?
Answer 5. (i) COUNT( ) : To count the number of cells containing numeric values.
(ii) MAX( ) : To find the maximum value in the specified range.