Spread Sheet Application MCQ with Answers

Spread Sheet Application MCQ with Answers

31) What is the purpose of ?Enter Key? in MS Excel?

Answer is:

Moves cell pointer to next row

32) Which function key is used to open goto dialogue box in MS Excel?

Answer is:

F5

33) Which option in MS Excel is used to display the rows that meet certain conditions?

Answer is:

Filter

34) Which option in Excel is used to rearrange the rows base on the content of a particular column?

Answer is:

Sort

35) Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?

Answer is:

Mixed