5. The absolute referencing can be done for B2 cell as: A S2 BSBS2 C. BS2 D. None 6. The cell reference for a range of cells that starts in cell C1 and goes over to column Hand down to row 10 is? ACT:10H B. CI:H10 C. CI:H-10 D. CI:H:10 7. What function displays row data in a column or column data in a row? A. Hyperlinks B. Rows C. Index D. Transpose 8. Which of the following functions will not show the word "TRUE" or "FALSE" as a result? A. NOT B. OR C. IF D. AND 9. To create a formula, you can use: A. Values but not cell references B. Cell references but not values C.Values or cell references although not both at the same time D. Value and cell references 10. Excel is one of the most efficient tools when handling: A. Large amount of data B. Confidential and sensitive data C. Online data based on server/client systems D. None of the above