WorkSource Certificate for Basic Microsoft Excel

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

True

False

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.

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.

2.

The Area Outlined in Red is called what?

Quick Access Toolbar

Random Access Bar

The Ribbon

Formula Bar

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.

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.

3.

The Area Circled in Red is called what?

The Top

The Scarf

The Ribbon

Formula Bar

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.

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.

4. 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")

Expenses

Income (without Paycheck)

Budget

Entertainment

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"

5. 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")

Yes

No

Maybe so

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"

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

=SUM(E4-B7)

=SUM(B5-E5)

=SUM(B2:B4)

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"

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

True

False

Question from WorkSheet "Entertainment"

Explanation

Question from WorkSheet "Entertainment"

8. What dollar amount is displayed in cell B2? (Question from WorkSheet "Bills & Income")

$287

$51

$835

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"

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

$150

$797

$72

$376

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"

10. 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")

Tax Return & Paycheck

Paycheck & Xmas Gift Return

Tax Return & Xmas Gift Return

Xmas Gift Return & Cellphone

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.

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.

11. 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?

Sum(C2-D2)

Sum(D7-D10)

Sum(B5-E5)

Minus(D7-D10)

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.

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.

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

$789

$575

$72

$287

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"

13. 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")

$150

$287

$72

$575

Question from WorkSheet "Bills & Income"

Explanation

Question from WorkSheet "Bills & Income"