Spread Sheet Application Set 8

---

Which one of the following is ?no argument? function?

  

    (A) "Now()"

    (B) "Lower()"

    (C) "Max()"

    (D) "IF()"

Now()

---

Which key is used to move the insertion point to the beginning of the current sheet?

  

    (A) Pageup

    (B) Home

    (C) Ctrl + pageup

    (D) Ctrl + Home

Ctrl + Home

---

Which sequence of operation is used to insert the hidden formula bar in Excel worksheet?

  

    (A) View-Show/hide-Formula bar

    (B) Insert-show/hide-Formula bar

    (C) Data-show/hide-Formula bar

    (D) Home-show/hide-formula bar

View-Show/hide-Formula bar

---

Which option is used to change the direction where the cursor moves when you press the enter key in Excel?

  

    (A) Excel options AdvanceEnable auto complete for cell values

    (B) Excel optionsAdvance?Extend data range formats

    (C) Excel optionsAdvance choose direction by clicking down arrow next to check box

    (D) Excel optionsAdvance?Enable fill handle and cell drag and drop

Excel optionsAdvance choose direction by clicking down arrow next to check box

---

Which key is used to make multiple line in a single cell?

  

    (A) Alt + Enter

    (B) Tab + Enter

    (C) Ctrl + Enter

    (D) Shift + Enter

Alt + Enter

---