1. Engineering
  2. Computer Science
  3. when a function returns a range of results in excel...

Question: when a function returns a range of results in excel...

Question details

When a function returns a range of results in Excel, the block of cells for the return values must be highlighted, and Ctrl-Shift-Enter is used. the function must be entered in each cell of the block for the results. all results are returned in one cell. the equation editor must be used to enter the function. an Excel function can only return one result.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution