Microsoft Excel Test II

13 Questions | Total Attempts: 101

SettingsSettingsSettings
Microsoft Excel Test II - Quiz

Questions and Answers
  • 1. 
    OPEN AN EXCEL SPREADSHEET 1. Enter 25 in A1 2. Enter 30 in A2 3. Enter The Formula For The Sum (DO NOT USE THE AUTOSUM)
  • 2. 
    ON THE SAME SPREADSHEET 1. Enter 5 in B1 2. Enter 6 in B2 3. Enter The Formula To DIVIDE A1 By B1 In Cell C1 4. Enter The Formula To DIVIDE A2 By B2 In Cell C2
  • 3. 
    ON THE SAME SPREADSHEET 1. Enter 10 In A6 2. Enter 5 In A7 3. Enter The Formula To Subtract A7 From A6 In Cell A8
  • 4. 
    ON THE SAME SPREADSHEET 1. Enter 2 In B6 2. Enter 5 In B7 3. Enter The Formula To Multiply A6 By B6 In Cell C6 4. Enter The Formula To Multiply A7 By B7 In Cell C7
  • 5. 
    1. In Cell A10 Type The Below Statement: In Word 2007 I Can Create A Document. I Can Use The Spell Check F7 Functon Key To Check My Spelling. In Excell 2007 I Can Create A Spreadsheet To Track Numberic or Alpha Text Data.  I Can Also Calculate Numbers. 2.  Use The Wrap Text Button To Format The Text You Just Typed. 3.  Center The Text 4.  Save As Week 3 Test II 5.  Print The Spreadsheet
  • 6. 
    Microsoft Excel is an ______________  spreadsheet
    • A. 

      Easy

    • B. 

      Electronic

    • C. 

      Empty

  • 7. 
    You Can Only Edit Data In The Formula Bar
    • A. 

      True

    • B. 

      False

  • 8. 
    The Only Way To Get The Sum of A Set of Numbers Is To Use The Button Below
    • A. 

      True

    • B. 

      False

  • 9. 
    What Tab Is The Wrap Text Button Found?
    • A. 

      Home

    • B. 

      House

    • C. 

      Review

  • 10. 
    You Can Spell Check In Excel By Doing The Following
    • A. 

      Clicking F7 Only

    • B. 

      Selecting Spelling On The Reference Tab

    • C. 

      Selecting Spelling On The Review Tab or Clicking F7

    • D. 

      All of The Above

  • 11. 
    To Save A Worksheet In Excel You Must Click On The _______  _______ and then click ______.
  • 12. 
    What Is This Area Called
    • A. 

      Title Bar

    • B. 

      Menu Bar

    • C. 

      Ribbon Bar

  • 13. 
    'B10' Is Indicated In The ________ Box Area
    • A. 

      Number

    • B. 

      Nancy

    • C. 

      Name

Back to Top Back to top