Microsoft Excel - Set 1

10 Questions

Settings
Please wait...
Microsoft Excel - Set 1

Online MCQ Quiz on Microsoft Excel - Set 1 No. Of Questions:- 10 Time:- 10 Minutes Full Mark:- 100 Pass Mark:- 70 This Quiz if for those user who wants to test their knowledge in Microsoft Excel. For more MCQ Questions and Online Quizzes please visit https://www. McqQuestions. Com


Questions and Answers
  • 1. 
    Comments put in cells are called …..
    • A. 

      Smart Tip

    • B. 

      Cell Tip

    • C. 

      Web Tip

    • D. 

      Soft Tip

  • 2. 
    Comments can be added to cells using …..
    • A. 

      Edit -> Comments

    • B. 

      Insert -> Comment

    • C. 

      File -> Comments

    • D. 

      View –> Comments

  • 3. 
    • A. 

      Format -> Window

    • B. 

      View -> Window-> Split

    • C. 

      Window -> Split

    • D. 

      View –> Split

  • 4. 
    Getting data from a cell located in a different sheet is called….
    • A. 

      Accessing

    • B. 

      Referencing

    • C. 

      Updating

    • D. 

      Functioning

  • 5. 
    Which of the following is not a valid data type in Excel?
    • A. 

      Number

    • B. 

      Character

    • C. 

      Label

    • D. 

      Date/Time

  • 6. 
    • A. 

      Contents

    • B. 

      Objects

    • C. 

      Scenarios

    • D. 

      All of the above

  • 7. 
    A numeric value can be treated as label value if …… precedes it.
    • A. 

      Apostrophe (‘)

    • B. 

      Exclamation (!)

    • C. 

      Hash (#)

    • D. 

      Tilde (~)

  • 8. 
    Concatenation of text can be done using
    • A. 

      Apostrophe (‘)

    • B. 

      Exclamation (!)

    • C. 

      Hash (#)

    • D. 

      Ampersand (&)

  • 9. 
    Which area in an Excel window allows entering values and formulas?
    • A. 

      Title Bar

    • B. 

      Menu Bar

    • C. 

      Formula Bar

    • D. 

      Standard Tool Bar

  • 10. 
    Multiple calculations can be made in a single formula using…..
    • A. 

      Standard Formulas

    • B. 

      Array Formula

    • C. 

      Complex Formulas

    • D. 

      Smart Formula