Câu 14: 77-888: Excel 2010 Expert

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet as shown below: You want to use Excel Transpose Function for copying the contents of cells B1:B3 into cells A5:C5. You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel #VALUE! error message because the cells are working independently and the function will not work for each individual cell. Therefore, it is required to make the cells A5:C5 work together as an ARRAY. For this purpose, you are required to use an array formula. Which of the following steps will you take to input Excel array formulas in the spreadsheet?Each correct answer represents a part of the solution. Choose all that apply.

1. A. Type the array formula into the first cell. — đáp án hiện tại
2. B. Highlight the range of cells that you want to use as an input in his array formula. — đáp án hiện tại
3. C. Press CTRL-SHIFT-Tab to remove the error message.
4. D. Press CTRL-SHIFT-Enter. — đáp án hiện tại