Computer: MS Excel Questions Set 3

MS Excel Questions Answers for bank exams IBPS PO, IBPS RRB, NIACL, NICL, LIC, BOI, Bank of Baroda and other competitive exams

  1. Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?
    A) NOT
    B) OR
    C) IF
    D) AND
    E) none of these
    View Answer
     Option C
  2. Macros can be executed from the which of the following menu ?
    A) format
    B) home
    C) insert
    D) tools
    E) none of these
    View Answer
     Option D
  3. What function displays row data in a column or column data in a row ?
    A) transpose
    B) index
    C) rows
    D) hyperlinks
    E) none of these
    View Answer
     Option A
  4. You can convert existing Excel worksheet data and charts to HTML document by using the ?
    A) internet assistant wizard
    B) intranet wizard
    C) import wizard
    D) export wizard
    E) None of these
    View Answer
     Option A                 
    Explanation: The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data toHTML format.
  5. Which of the following is not a valid Zoom percentage in Excel ?
    A) 10
    B) 100
    C) 300
    D) 500
    E) none of these
    View Answer
     Option D
  6. MS-EXCEL can be used to automate
    A) Financial statements, Business forecasting
    B) Transaction registers, inventory control
    C) Accounts receivable, accounts payable
    D) Any of the above
    E) none of these
    View Answer
     Option D  
  7. In Excel _______ may not contain in Formula
    A) text constant
    B) number constant
    C) circular reference
    D) all of them
    E) none of these
    View Answer
     Option C
  8. In Excel, by default Numeric Values appears in
    A) left aligned
    B) right aligned
    C) center aligned
    D) justify aligned
    E) none of these
    View Answer
     Option B
  9. What is the shortcut key to insert new sheet in current workbook?
    A) F11
    B) ALT+F11
    C) CTRL+F11
    D) SHIFT+F11
    E) None of these
    View Answer
     Option D
  10. What is the shortcut key to hide entire row?
    A) CTRL+H
    B) CTRL+R
    C) CTRL+9
    D) CTRL+ –
    E) None of these
    View Answer
     Option C

 

 

 

Related posts

10 Thoughts to “Computer: MS Excel Questions Set 3”

  1. Sachin Shukla

    7/10 ty:)) Az

  2. Jellyfish

    Thx az
    8/10

  3. wont rest until i get success

    Thank you

  4. Jeetesh Chandra

    9/10..ty Az..

  5. Player

    I think 3rd should be ..Transpose

  6. swati

    .question 3rd ans must be option no. one i.e. TRANSPOSE

    shortcut key to insert new sheet in current workbook= alt+shift+F1

    thank you team

  7. Ravi Upadhyay

    thnxx

Leave a Comment