Excel MCQ

1.       Default text is aligned within a cell to the ---- a)       Right      b) Left    c)       Center    d) None      2.       AutoSum button is displayed towards the ---- end of the ribbon a)       Right          b) Left c)    Center        d) None 3.       By default, each new workbook contains ---- worksheet. a)  Single            b) Double c)  Multiple        d) None 4.       Press Ctrl+N is the keyboard shortcut key to create a new blank -----. a)  Workbooks      b) Workbook c)  Worksheet       d) b & c 5.       Press Ctrl+O is the keyboard shortcut key to open ----- file. a)  An existing   b) A new c)  Multiple        d) None 6.       Alt+Tab is the keyboard shortcut to switch between ---- programs. a)  Open            b) Close c)  Maximize    d) Minimize 7.       COUNTBLANK is used to count ------ within a cell range? a)  empty cells           b) cells of text c)  cells of numbers   d) None 8.       Getting data from a cell located in a different sheet is called ---- . a)  Accessing           b) Updating c)  Referencing        d) None 9.       If you press ---- , the cells accepts whatever you have typed as its content. a)  Ctrl+Enter   b) Shift+Enter c)  Shift            d) None 10.    Which of the following symbols is used for entering a formula?. a)  =         b) SUM c)  @        d) None

11. Which is not an operator? a)    +     c) * b)       -      d) & 12. Which is the formula for finding out Average        from A3 to A10 ? a)       =AVERAGE(A3.A10)  b) =AVERAGE(A3,A10)  c)    =AVERAGE (A3; A10) d)   None 13. In Excel, alignment group is found on the ----. a)       Home Tab   c) Data Tab b)    Insert Tab    d) View Tab    14. To select entire worksheet, we can press ----. a)       Ctrl+A      c) Ctrl+B    b)       Ctrl+C     d) Ctrl+L `      15. If we click between any two row headers, we can               drag the row height up or down to modify the ----.               a) column width     c) row height               b) column height    d) row width  `      16. Charts are found on the ---- tab.                    a) Home     c) Review               b) Insert     d) View `      17. We can  rotate  text diagonally or vertically from                ----- group.               a) Font           c) Cells               b) Alignment d) None `      18. Which of the following formula has been                entered correctly?               a) =A5*A7              c) =B7/B3               b) = SUM(A5:A7)  d) All of the above `      18. Which of the following formula has not been                entered correctly?               a) =A5*A7              c) =B7.B3               b) = SUM(A5:A7)  d) None `      20. In MS Excel worksheet, active cells are look like                ---- box.               a) square              c) triangle               b) parallelogram   d) None      .