SPREAD SHEET APPLICATION - Practice Mode

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

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

Correct Answer: Now()

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

Pageup Home Ctrl + pageup Ctrl + Home

Correct Answer: 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

Correct Answer: View-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

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

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

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

Correct Answer: Alt + Enter

Explanation:

Alt + Enter key is used to make multiple line in a single cell.

Previous Question Set Back to Question Sets Next Question Set

Try Another Topic

Try Another Quiz