Free Preparation Discussions
MENU
Microsoft Exam 77-427 Topic 3 Question 21 Discussion
Topic #: 3
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.
The following steps are taken to input Excel array formulas:
Highlight the range of cells that a user wants to use as an input in his array formula.
Type the array formula into the first cell or make this cell editable by pressing F2 or clicking in the formula bar if a user has already specified a value into the first cell.
Press CTRL-SHIFT-Enter.
Answer option C is incorrect. This is an invalid answer option.
Currently there are no comments in this discussion, be the first to comment!