5. Which function displays columnar data in rows and vice vera?? A. MATCH B. TRANSPOSE C. INDEX D. LOOKUP 6. Which of the following statemerits repecicnts a difference between the Excel COUNTIF: function and the COUNTHF function? A. COUNTIF sums two celis using multiple arguenents. B. COUNTIFS counts cells using muleiple criterix; COUNTIF uses one criterion. C. COUNTIFS sums cells visine either values or labels COUNIIF, sumt cells with values D. COUNTIFS counts both blank and nooblank celle COUNTIF ignores nooblank cells. 7. Which of the following keybourd avor was areates an Excel chart shoet for the selected da defiult chart type? A. [A/1]+[F11] B. [CCr}]+[F1] C. [F]1] D. [F9] A. Cell Siyles B. Conditional Formagtine. C. Visualization tistirary