MS Excel MCQs

Which of following is an active cell in excel?

1. Cell address
2. Range
3. Formula
4. Current cell

Which of following is invalid statement?

1. The width of a row and be specified manually or fit automatically
2. You can set the column width automatically fit the amount of text
3. ome picture can be applied as a background of a sheet
4. none

Which of following format you can decide to apply or not in or not in auto formatted dialogue box?

1. Font format
2. Number format
3. Border format
4. All of above

Which of following action removes a sheet from workbook?

1. Select the sheet, then choose Edit > Delete Sheet
2. Select the sheet then choose Format > Sheet > Hide
3. Both
4. None

Which menu can be used to split windows into two?

1. Window > Split
2. Review > Window
3. View > Window > Split
4. none

Which is not the function of "Edit clear command"?

1. Delete cells
2. Delete notes
3. Delete contents
4. None

How a cell can be edit on Excel sheet?

1. Edit contents of cell directly in cell
2. Edit by typing in formula bar
3. Edit mode
4. All above mentioned

How you can update the values of formula cell.If auto calculate the mode of excel cell is disabled

1. f9
2. f2
3. f7
4. none

Which of following you can paste selectively using paste special command______?

1. Formats
2. Validation
3. Formulas
4. All of above

In --- tab you will find auto sum button:

1. formatting tab
2. Formulas tab
3. standard tab
4. none