Microsoft Excel Questions

MCQ bookmark_border

21.

Which of the following Excel screen components can NOT be turned on or off?

A

Formula Bar

B

Status Bar

C

Tool Bar

D

None of above

Correct Answer: D

Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.
In earlier versions of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.
In earlier versions of Excel, you could hide the tool bar as per requirement. However, that capability was removed starting with Excel 2007 and introduced Ribbon.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

What happens when you press Ctrl + X after selecting some cells in Excel?

A

The cell content of selected cells disappear from cell and stored in clipboard

B

The cells selected are marked for cutting

C

The selected cells are deleted and the cells are shifted left

D

The selected cells are deleted and cells are shifted up

Correct Answer: B

When we pressing the ctrl+x in the Microsoft excel sheet it means we cut the content from that cell simply means the cells selected are marked for cutting and the user has need to move the content from one cell to another cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

Which of the following option is not available in Paste Special dialog box?

A

Add

B

Subtract

C

Divide

D

SQRT

Correct Answer: D

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

Which command will you choose to convert a column of data into row?

A

Cut and Paste

B

Paste Special > Transpose

C

Both of above

D

None of above

Correct Answer: B

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

Which command will you choose to convert a column of data into row?

A

Cut and Paste

B

Paste Special > Transpose

C

Both of above

D

None of above

Correct Answer: B

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

Which of the cell pointer indicates you that you can make selection?

A

Doctor

B

Small thin plus icon

C

Mouse Pointer with anchor at the tip

D

None of above

Correct Answer: A

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

Which of the cell pointer indicates that you can fill series?

A

Doctor

B

Small thin plus icon

C

Mouse Pointer with anchor at the tip

D

None of above

Correct Answer: B

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

Which of the cell pointer indicate that you can move the content to other cell?

A

Doctor

B

Small thin plus icon

C

Mouse Pointer with anchor at the tip

D

None of above

Correct Answer: C

Mouse Pointer with anchor at the tip cell pointer indicate that you can move the content to other cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

You can auto fit the width of column by

A

Double clicking on the column name on column header

B

Double click on the cell pointer in worksheet

C

Double clicking on column right border on column header

D

Double clicking on the column left border of column header

Correct Answer: C

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

You can auto fit the width of column by

A

Double clicking on the column name on column header

B

Double click on the cell pointer in worksheet

C

Double clicking on column right border on column header

D

Double clicking on the column left border of column header

Correct Answer: C

Check Answer report_problem Report forum Discussion