Exam 77-888 topic 1 question 14 discussion

Actual exam question from Microsoft's 77-888

Question #: 14
Topic #: 1

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.

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.
C. Press CTRL-SHIFT-Tab to remove the error message.
D. Press CTRL-SHIFT-Enter.

Show Suggested Answer

Suggested Answer: ABD 🗳️
The following steps are taken to input Excel array formulas:
1. Highlight the range of cells that a user wants to use as an input in his array formula.
2. 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.
3. Press CTRL-SHIFT-Enter.
Answer option C is incorrect. This is an invalid answer option.

by Shahid_416 at Nov. 22, 2023, 11:43 a.m.

Comments

Submit Cancel

Shahid_416

1 year, 7 months ago

Option : A B D

upvoted 1 times

...