Spread Sheet Application Set 7

---

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

  

    (A) Moves cell pointer to previous column

    (B) Moves cell pointer to next column

    (C) Moves cell pointer to previous row

    (D) Moves cell pointer to next row

Moves cell pointer to next row

---

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

  

    (A) F2

    (B) F5

    (C) F7

    (D) F11

F5

---

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

  

    (A) Find

    (B) Filter

    (C) Format

    (D) Sort

Filter

---

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

  

    (A) Find

    (B) Filter

    (C) Sort

    (D) Format

Sort

---

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?

  

    (A) Mixed

    (B) General

    (C) Relative

    (D) Absolute

Mixed

---