MS Excel MCQ

Below MS Excel quiz are Multiple Choice Questions (MCQs) type Quiz. These MS Excel MCQ Questions helps you to refresh your MS Excel, you can see the correct option by clicking on it. .
  • 1. Ctrl + D shortcut key in Excel will

    • Open the font dialog box
    • Apply double underline for the active cell
    • Fill down in the selection
    • None of above
  • 2. The Name box on to the left of formula bar

    • Shows the name of workbook currently working on
    • Shows the name of worksheet currently working on
    • Shows the name of cell or range currently working on
    • None of above
  • 3. Microsoft Excel is a powerful ________

    • Word processing package
    • Spreadsheet package
    • Communication S/W Package
    • DBMS package
  • 4. You can set Page Border in Excel from

    • From Border tab in Format Cells dialog box
    • From Border tool in Formatting toolbar
    • From Line Style tool in Drawing toolbar
    • You can not set page border in Excel
  • 5. Which of the following is not true regarding Conditional Formatting?

    • You can add more than one condition to check
    • You can set condition to look for Bold and apply Italics on them
    • You can apply Font, border and pattern formats that meets the specified conditions
    • You can delete any condition from Conditional Formatting dialog box if it is not requried
  • 6. Located on the left side or the entry bar, displays the active cell reference:

    • entry bar
    • cell reference
    • name box
    • none of the above
  • 7. Located on the left side or the entry bar, displays the active cell reference:

    • entry bar
    • cell reference
    • name box
    • none of the above
  • 8. A program using a table comprising of rows, columns and cells.

    • MS Word
    • MS PowerPoint
    • MS PowerPoint
    • MS Excel
  • 9. When a range is selected, how can you activate the previous cell?

    • Press the Alt key
    • Press Tab
    • Press Enter
    • None of above
  • 10. When a row of data is to be converted into columns

    • Copy the cells in row, select the same number of cells in row and paste
    • Copy the cells in column then choose Paste Special, then click Transpose and OK
    • Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK
    • Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK