Microsoft Excel Questions

MCQ bookmark_border

31.

MS Excel provides the default value for step in Fill Series dialog box

B

1

C

5

D

10

Correct Answer: B

The default value for any series is 1 in Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

When a row of data is to be converted into columns

A

Copy the cells in row, select the same number of cells in row and paste

B

Copy the cells in column then choose Paste Special, then click Transpose and OK

C

Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK

D

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Correct Answer: D

Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose
Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

Ctrl + D shortcut key in Excel will

A

Open the font dialog box

B

Apply double underline for the active cell

C

Fill down in the selection

D

None of above

Correct Answer: C

Ctrl+D fills the cell beneath with the contents of the selected cell in a column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

The shortcut key Ctrl + R is used in Excel to

A

Right align the content of cell

B

Remove the cell contents of selected cells

C

Fill the selection with active cells to the right

D

None of above

Correct Answer: C

Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

The shortcut key Ctrl + R is used in Excel to

A

Right align the content of cell

B

Remove the cell contents of selected cells

C

Fill the selection with active cells to the right

D

None of above

Correct Answer: C

Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

Which of the following series type is not valid for Fill Series dialog box?

A

Linear

B

Growth

C

Autofill

D

Time

Correct Answer: D

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

Which of the following you can paste selectively using Paste Special command?

A

Validation

B

Formats

C

Formulas

D

All of above

Correct Answer: D

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A

Square

B

Percentage

C

Goal Seek

D

Divide

Correct Answer: D

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

Edit > Delete command

A

Deletes the content of a cell

B

Deletes Formats of cell

C

Deletes the comment of cell

D

Deletes selected cells

Correct Answer: D

Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

Edit > Delete command

A

Deletes the content of a cell

B

Deletes Formats of cell

C

Deletes the comment of cell

D

Deletes selected cells

Correct Answer: D

Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.

Check Answer report_problem Report forum Discussion