Worksource Certificate For Basic Microsoft Excel

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By NIESWorkSource
N
NIESWorkSource
Community Contributor
Quizzes Created: 2 | Total Attempts: 16,674
Questions: 14 | Attempts: 160

SettingsSettingsSettings
Worksource Certificate For Basic Microsoft Excel - Quiz


The basic test to receive 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 the 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

    Correct Answer
    C. $835
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 2. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The document "MikesBudget.xls" is an Excel document, which implies that it is created using Microsoft Excel software. In Excel, different sections within a document are referred to as worksheets. Therefore, the tabs "Bills & Income" and "Entertainment" within the document are indeed called worksheets.

    Rate this question:

  • 3. 

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

    • A.

      $789

    • B.

      $575

    • C.

      $72

    • D.

      $287

    Correct Answer
    D. $287
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 4. 

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

    • A.

      $150

    • B.

      $797

    • C.

      $72

    • D.

      $376

    Correct Answer
    C. $72
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 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)

    Correct Answer
    B. Sum(D7-D10)
    Explanation
    The formula sum(D7-D10) would be used to calculate how much money Mike would save if he didn't use any of his income on entertainment.

    Rate this question:

  • 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

    Correct Answer
    A. $150
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 7. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Question from WorkSheet "Entertainment"

    Rate this question:

  • 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

    Correct Answer
    D. $21
    Explanation
    Question from WorkSheet "Entertainment"

    Rate this question:

  • 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

    Correct Answer
    A. Yes
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 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)

    Correct Answer
    B. =SUM(B5-E5)
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 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

    Correct Answer
    C. Tax Return & Xmas Gift Return
    Explanation
    The correct answer is Tax Return & Xmas Gift Return. This is because the question states that cell C14 contains two of Mike's sources of income combined. Since the options given are different combinations of income sources, we can conclude that the sources being added in cell C14 are Tax Return and Xmas Gift Return.

    Rate this question:

  • 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

    Correct Answer
    B. Income (without Paycheck)
    Explanation
    Question from WorkSheet "Bills & Income"

    Rate this question:

  • 13. 

     The Area Circled in Red is called what?

    • A.

      The Top

    • B.

      The Scarf

    • C.

      The Ribbon

    • D.

      Formula Bar

    Correct Answer
    C. The Ribbon
    Explanation
    The area circled in red is called the Ribbon. The Ribbon is a graphical control element in the Microsoft Office suite of programs, including Word, Excel, and PowerPoint. It is located at the top of the program window and contains various tabs, each with a set of commands and tools specific to the program. The Ribbon provides easy access to commonly used features and functions, making it a crucial part of the user interface.

    Rate this question:

  • 14. 

     The Area Outlined in Red is called what?

    • A.

      Quick Access Toolbar

    • B.

      Random Access Bar

    • C.

      The Ribbon

    • D.

      Formula Bar

    Correct Answer
    A. Quick Access Toolbar
    Explanation
    The area outlined in red is called the Quick Access Toolbar. This toolbar provides quick access to commonly used commands and functions in the software. It is customizable, allowing users to add or remove commands based on their preferences and needs. The Quick Access Toolbar is located at the top of the software interface, usually below the main menu or ribbon, and is easily accessible for efficient workflow.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jun 04, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 19, 2011
    Quiz Created by
    NIESWorkSource
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.