Question

1. You have to write a series of numbers from 1 to 50 without using the keyboard in MS Excel. Which feature will you use?

Answer 1

Answer:

Type "=row(51:52)" without quotes. The first number should be the next consecutive number in the list. The last number needs to be larger than the first number. Press "Ctrl-Shift-Enter" to fill the cells with a static list of consecutive numbers, beginning with the first number you entered in the array formula.

Explanation:

Hope it will help you