SPREAD SHEET APPLICATION

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

Now() Lower() Max() IF()

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

Pageup Home Ctrl + pageup Ctrl + Home

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

View-Show/hide-Formula bar Insert-show/hide-Formula bar Data-show/hide-Formula bar Home-show/hide-formula bar

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

Excel options AdvanceEnable auto complete for cell values Excel optionsAdvance?Extend data range formats Excel optionsAdvance choose direction by clicking down arrow next to check box Excel optionsAdvance?Enable fill handle and cell drag and drop

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

Alt + Enter Tab + Enter Ctrl + Enter Shift + Enter

SPREAD SHEET APPLICATION - Quiz

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

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

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

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

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