Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental

31

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

A) 0 B) 1 C) 5 D) 10

Discuss

Answer & Solution

Answer: Option B

Solution:

The default value for any series is 1 in Excel.

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

Discuss

Answer & Solution

Answer: Option D

Solution:

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

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

Discuss

Answer & Solution

Answer: Option C

Solution:

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.

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

Discuss

Answer & Solution

Answer: Option C

Solution:

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.

35

The command Edit > Fill Across Worksheet is active only when

A) One sheet is selected B) When many sheets are selected C) When no sheet is selected D) None of above

Discuss

Answer & Solution

Answer: Option B

Solution:

Click the Fill button in the Editing group, and then click Across Worksheet a command only appears when we have multiple worksheets selected.

36

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

A) Linear B) Growth C) Autofill D) Time

Discuss

Answer & Solution

Answer: Option D

Solution:

Time series type is not valid for Fill Series dialog box in excel.

MS Excel mcq solution image

37

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

A) Validation B) Formats C) Formulas D) All of above

Discuss

Answer & Solution

Answer: Option D

Solution:

We can paste formula, value, formats, comments, validation using Paste Special command.

MS Excel mcq solution image

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

Discuss

Answer & Solution

Answer: Option D

Solution:

Paste Special allows Divide operation while you paste to new cell.

MS Excel mcq solution image

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

Discuss

Answer & Solution

Answer: Option D

Solution:

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

40

To remove the content of selected cells you must issue ______ command

A) Delete B) Clear Contents C) Clear All D) Clear Delete

Discuss

Answer & Solution

Answer: Option B

Solution:

To remove the content of selected cells we must issue Clear Contents command. Clear Contents will clear only the data, will not clear any formats.