Worksource Certificate For Basic Microsoft Excel
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!
- 1.
What dollar amount is displayed in cell B2? (Question from WorkSheet "Bills & Income")
- A.
$287
- B.
$51
- C.
$835
Correct Answer
C. $835Explanation
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. TrueExplanation
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. $287Explanation
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. $72Explanation
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. $150Explanation
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. FalseExplanation
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. $21Explanation
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. YesExplanation
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 ReturnExplanation
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 RibbonExplanation
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 ToolbarExplanation
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
-
Mar 14, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 19, 2011Quiz Created by
NIESWorkSource
Back to top