class 8 chapter 2
Test Yourself – Answers A formula may need which of the following to perform calculations? d. All of these To select adjacent cells, which of the following keys is used? d. Shift Absolute referencing is applied using which of the following letter? b. $ Here are all the answers from the worksheet. A. Choose the correct answer The values passed to a function are called Arguments . Answer: b. Arguments The second argument in the IF( ) is applicable when the given expression evaluates to True . Answer: a. True The error code #### indicates Column width too small to display result . Answer: a. Column width too small to display result B. Fill in the blanks ( Mixed, Highest, Join, Condition to check, F4 ) The Max function returns the Highest value in a given cell range. The & operator is used to Join two or more text strings. The cell address B$5 is an example of Mixed cell reference. The IF() takes arguments: Condition to check , value if true, value if false. The key to cycle throug...