Taxes
Math
OT Pay
Excel
Fixed v. Variable Expenses
100

What are the 5 types of taxes that we have learned?

Medicare tax, State tax, Income tax, Sales tax, and Social Security Tax

100

If your daily quota was to make $5,000.00 in sales, and you only make $3,738.00, how much did you miss your quota by?

$1,262.00

100

What is the formula for overtime pay?

Hourly Pay rate x 1.5 x Overtime Hours Worked

100
What is the control center in Excel?

The ribbon.

100

What qualifies something as a fixed expense?

The bill must be paid regularly with no change in cost. 

200

What is the % of tax added to the price of taxable goods, items, or products that you buy?

Sales Tax

200

Frederic worked 46 hours last week. His hourly rate is $7.80. What was his gross pay? 

$452.40

200

Mark wanted to work overtime last week. His hourly rate is $9.00. What is his overtime pay rate?

$13.50.

200

What is the column letter above the grid?

The column heading. 

200

Are mortgage payments fixed or variable expenses?

Fixed

300

A tax by a state on income earned in or from the state

State tax

300

If your company has a 15% market share and the total market size is $10M, how much revenue are you gathering?

$1.5 Million

300

Nina worked 88 hours in the last 14 days. How many hours did she receive overtime pay for? 

8 hours. 

300

What is the basic unit of a worksheet that you enter data into?

A cell.

300

If I order takeout every month, is that a fixed or variable expense?

Variable

400

A tax imposed on individuals or entities in respect of the income or profits earned by them

Income Tax

400

If your average sale is $50.00 and your profit margin is 30%, how much do you make per sale?

$15.00

400

If you are regularly paid $10.50 per hour and you work 9 hours of overtime within one week, what is your total overtime pay?

$141.75.

400

What is the list of frequently used commands relating to a right-clicked object?

The shortcut/context menu.

400

Bob owns a Tesla and has to charge his car at minimum 5 times per month. Would this be a fixed or variable expense?

Variable

500

A tax applied to the earned income of Americans throughout their working years

Social Security Tax

500

Kerry worked 46 hours last week. His hourly rate is $9.60. He has the following deductions taken from his pay: Federal Income tax at the rate of 10%, Social Security tax at the rate of 6.2%, Medicare tax at the rate of 1.45%, Health Ins. Premiums of $12.20, and Union dues of $9.50. What was his net pay?

$365.68

500

You worked 50 hours last week. Your regular hourly rate is $8.50. What was your gross pay?

$467.50.

500

What provides easy access to frequently used commands?

The Quick Access Toolbar. 

500

Jenna has a medical condition, and must buy herself medication when she feels the need to. Is this a fixed or variable expense?

Variable

M
e
n
u