35) 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?

Mixed

General

Relative

Absolute

Answer is:

Mixed

Spread Sheet Application MCQ with Answers

For more MCQ's Click Here

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

Now()

Lower()

Max()

IF()

Answer is:

Now()

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

Pageup

Home

Ctrl + pageup

Ctrl + Home

Answer is:

Ctrl + Home

38) 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

Answer is:

View-Show/hide-Formula bar

39) 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

Answer is:

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

Spread Sheet Application MCQ with Answers

For more MCQ's Click Here

35) 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?

Mixed

Spread Sheet Application MCQ with Answers

Related Spread Sheet Application MCQ with Answers

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

Now()

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

Ctrl + Home

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

View-Show/hide-Formula bar

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

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

Spread Sheet Application MCQ with Answers