SPREAD SHEET APPLICATION - Quiz

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

Moves cell pointer to previous column Moves cell pointer to next column Moves cell pointer to previous row Moves cell pointer to next row

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

F2 F5 F7 F11

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

Find Filter Format Sort

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

Find Filter Sort Format

5) 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?

Mixed General Relative Absolute