Microsoft Excel

15 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Basic test to recieve New Image WorkSource Certificate for Basic Microsoft Excel. The Answers to the questions are based on the Document "MikesBudget. Xls" found on the desktop of your computer. �Open the document�"MikesBudget. Xls" and follow along with the test in order to answer the questions properly. �Let instructor know if you have any questions about the document or have any problems. Good Luck!


Questions and Answers
  • 1. 
    What dollar amount is displayed in cell B2?   (Question from WorkSheet "Bills & Income")
    • A. 

      $287

    • B. 

      $51

    • C. 

      $835

  • 2. 
    The document "MikesBudget.xls" is an Excel Document.  The tabs "Bills & Income" and "Entertainment" are called WorkSheets
    • A. 

      True

    • B. 

      False

  • 3. 
    How much is Mike's Tax Return for? (Question from WorkSheet "Bills & Income")
    • A. 

      $789

    • B. 

      $575

    • C. 

      $72

    • D. 

      $287

  • 4. 
    How much is Mike's Cellphone bill this month? (Question from WorkSheet "Bills & Income")
    • A. 

      $150

    • B. 

      $797

    • C. 

      $72

    • D. 

      $376

  • 5. 
    If I wanted to figure out how much money Mike would save if he DIDN'T use any of his income on entertainment, which formula would we use?
    • A. 

      Sum(C2-D2)

    • B. 

      Sum(D7-D10)

    • C. 

      Sum(B5-E5)

    • D. 

      Minus(D7-D10)

  • 6. 
    Mike has crashed his car and will no longer have a car payment.   How much more money will Mike now have in his income? (Question from WorkSheet "Bills & Income")
    • A. 

      $150

    • B. 

      $287

    • C. 

      $72

    • D. 

      $575

  • 7. 
    Mike spends $150 a month on entertainment. (Question from WorkSheet "Entertainment")
    • A. 

      True

    • B. 

      False

  • 8. 
    Mike decided not to go to the Movies this month after all.  How much money will this save him? (Question from WorkSheet "Entertainment")
    • A. 

      $72

    • B. 

      $35

    • C. 

      $100

    • D. 

      $21

  • 9. 
    Mike's Tax Return turned into a Tax Lien! Mike now owes the money from his Tax Return instead of recieving it.   With this in mind, can Mike still afford his bills? (Question from WorkSheet "Bills & Income")
    • A. 

      Yes

    • B. 

      No

    • C. 

      Maybe so

  • 10. 
    What formula is used to get the Value in Cell D7? (Question from WorkSheet "Bill & Income")
    • A. 

      =SUM(E4-B7)

    • B. 

      =SUM(B5-E5)

    • C. 

      =SUM(B2:B4)

  • 11. 
    Notice that there is an empty Cell (cell B14) and a Cell with $338 in it (cell C14).  C14 contains two of Mike's sources of income combined.  Which two sources of income are being added?  (Question from WorkSheet "Bills & Income")
    • A. 

      Tax Return & Paycheck

    • B. 

      Paycheck & Xmas Gift Return

    • C. 

      Tax Return & Xmas Gift Return

    • D. 

      Xmas Gift Return & Cellphone

  • 12. 
    Knowing what you know from the previous question (Question 11), What title/label would best go into Cell B14 to discribe the Value in Cell C14? (Question from WorkSheet "Bills & Income")
    • A. 

      Expenses

    • B. 

      Income (without Paycheck)

    • C. 

      Budget

    • D. 

      Entertainment

  • 13. 
    The Area circled in Red is called what?
    • A. 

      Formula Bar

    • B. 

      Addition Bar

    • C. 

      Typing Zone

    • D. 

      Address Bar

  • 14. 
     The Area Circled in Red is called what?
    • A. 

      The Top

    • B. 

      The Scarf

    • C. 

      The Ribbon

    • D. 

      Formula Bar

  • 15. 
     The Area Outlined in Red is called what?
    • A. 

      Quick Access Toolbar

    • B. 

      Random Access Bar

    • C. 

      The Ribbon

    • D. 

      Formula Bar