MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 121 - 130 of 1111 Questions

The short cut 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

Option C: Fill the selection with active cells to the right


Discussion

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

Option C: Fill down in the selection


Discussion

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 Edit >> Paste Special, then click Transpose and OK
C Copy the cells then go to Format >> 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 Edit >> Paste Special, mark Transpose check box and click OK.
Correct Answer

Option D: Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.


Discussion

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

A 0
B 1
C 5
D 10
Correct Answer

Option B: 1


Discussion

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 Wraping in Format >> Cells, Layout tab
D All of above
Correct Answer

Option A: Wrap Text in Format >> Cells


Discussion

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

Option C: Double clicking on column right border on column header


Discussion

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
Correct Answer

Option C: Mouse Pointer with anchor at the tip


Discussion

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
Correct Answer

Option B: small thin plus icon


Discussion

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
Correct Answer

Option A: Doctor’s symbol (Big Plus)


Discussion

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

A data will be entered in the adjecent cells
B no data will be entered in the adjacent cells
C there is no suitable abbrevition for the text
D there is not time to format the text
Correct Answer

Option B: no data will be entered in the adjacent cells


Discussion



WhatsApp Support