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.

Question

Accepted Answer

A. Type the array formula into the first cell. B. Highlight the range of cells that you want to use as an input in his array formula. D. Press CTRL-SHIFT-Enter.

Answer

C. Press CTRL-SHIFT-Tab to remove the error message.

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…

Question

Exhibit

Options

How the community answered

Explanation

Topics

Community Discussion