MS Excel - Computer Fundamentals Questions and Answers

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

A.

Add

B.

Subtract

C.

Divide

D.

SQRT

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

It is acceptable to let long text flow into adjacent cells on a worksheet when

A.

Data will be entered in the adjacent cells

B.

No data will be entered in the adjacent cells

C.

There is no suitable abbreviation for the text

D.

There is not time to format the text

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

A.

Doctor’s symbol (Big Plus)

B.

Small thin plus icon

C.

Mouse Pointer with anchor at the tip

D.

None of above

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

A.

Doctor’s symbol (Big Plus)

B.

Small thin plus icon

C.

Mouse Pointer with anchor at the tip

D.

None of above

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

A.

Doctor’s symbol (Big Plus)

B.

Small thin plus icon

C.

Mouse Pointer with anchor at the tip

D.

None of above

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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

Share

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Long text can be broken down into many lines within a cell. You can do this through

A.

Wrap Text in Format > Cells

B.

Justify in Edit > Cells

C.

Text Wrapping in Format > Cells

D.

All of above