Microsoft Excel - Set 6

10 Questions

Settings
Please wait...
Microsoft Excel - Set 6

Online MCQ Quiz on Microsoft Excel - Set 6 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. 
    B7:B9 indicates:
    • A. 

      Cells B7 and cell B9 only

    • B. 

      Cells B7 through B9

    • C. 

      Cell B8 only

    • D. 

      None of the above

  • 2. 
    The Cancel and Enter buttons appear in the:
    • A. 

      Title bar

    • B. 

      Formula bar

    • C. 

      Menu bar

    • D. 

      Sheet tabs

  • 3. 
    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

  • 4. 
    NOT, AND, OR and XOR are
    • A. 

      Logical Operators

    • B. 

      Arithmetic operators

    • C. 

      Relational operators

    • D. 

      None of the above

  • 5. 
    In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
    • A. 

      Calendar

    • B. 

      Photograph of rainfall

    • C. 

      Chart showing rainfall amounts

    • D. 

      Database of rainfall

  • 6. 
    You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:
    • A. 

      Word processing

    • B. 

      Spreadsheet

    • C. 

      Database

    • D. 

      Graphics

  • 7. 
    You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?
    • A. 

      New

    • B. 

      Save As

    • C. 

      Edit

    • D. 

      Save

  • 8. 
    If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
    • A. 

      Re-format the spreadsheet

    • B. 

      Insert a row

    • C. 

      Increase the column width

    • D. 

      Use the spacebar

  • 9. 
    In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
    • A. 

      Ascending order

    • B. 

      Descending order

    • C. 

      Alphabetical order

    • D. 

      Random order

  • 10. 
    In order to perform a calculation in a spreadsheet, you need to use a:
    • A. 

      Table

    • B. 

      Formula

    • C. 

      Field

    • D. 

      Variable