Class 8 Spreadsheet - Formulas and Functions
A Fill in the blanks with the correct words: 1. The formula in Excel starts by typing = sign. 2. The $ symbol is used for absolute referencing. 3. On selection, the formula entered into a cell is displayed in the Formula bar. 4. The : symbol is used in specifying a range of cells. 5. SUM is the name of a Function in Excel 2013. B Write T for the true statement and F for the false one. Correct the false statement(s). 1. The default cell referencing is absolute type. F (The default cell referencing is relative type) 2. The AVG function is used to find the average value of list of values. F (The AVERAGE function is used to find the average value of list of values) 3. The range A2:F5 covers 14 cells. F (The range A2:F5 covers 24 cells) 4. A function can be used inside another function. T 5. $A5 is not a valid cell reference in Excel 2013. F ($A5 is a valid cell reference in Excel 2013) C Choose the correct option. 1. Which one is not a type of cell referencing in Excel 2013? a. Relati...