Spread Sheet Application Set 6

---

Which function in Excel is used to find the biggest value in a range?

  

    (A) Ceiling

    (B) DMAX

    (C) LEN

    (D) MAX

MAX

---

12 Which one of the following is a text function in MS Excel?

  

    (A) "MID()"

    (B) "NOW()"

    (C) "COUNT()"

    (D) "SIGN"

MID()

---

Which one of the following is a ?Date & Time? function in Excel?

  

    (A) "FIND()"

    (B) "MOD()"

    (C) "NOW()"

    (D) "MID()"

NOW()

---

Which function is used to find the middle number in a range?

  

    (A) "MEDIAN()"

    (B) "MID()"

    (C) "TRIM()"

    (D) "MODE()"

MEDIAN()

---

What is the purpose 'Tab' key in MS Excel?

  

    (A) Moves cell pointer to previous column

    (B) Moves cell pointer to next column

    (C) Moves cell pointer previous row

    (D) Moves cell pointer next row

Moves cell pointer to next column

---