Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental Page-4 section-1

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

A. 0

B. 1

C. 5

D. 10

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

A. Linear

B. Growth

C. Autofill

D. Time

Answer & Solution Discuss in Board Save for Later

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

A. Validation

B. Formats

C. Formulas

D. All of above

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

A. Delete

B. Clear Contents

C. Clear All

D. Clear Delete

Answer & Solution Discuss in Board Save for Later

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

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

Answer & Solution

32. When a row of data is to be converted into columns

Answer & Solution

33. Ctrl + D shortcut key in Excel will

Answer & Solution

34. The shortcut key Ctrl + R is used in Excel to

Answer & Solution

35. The command Edit > Fill Across Worksheet is active only when

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

39. Edit > Delete command

Answer & Solution

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

Answer & Solution

Read More Section(MS Excel)

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

32.
When a row of data is to be converted into columns

33.
Ctrl + D shortcut key in Excel will

34.
The shortcut key Ctrl + R is used in Excel to

35.
The command Edit > Fill Across Worksheet is active only when

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

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

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

39.
Edit > Delete command

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