S3 AIT Key Excel Terms

The SQA will use words which they expect you to know.

• True

• False

Sometimes it is these words that will ______ you.

• Help

• Confuse

• Guide

• Inform

What will this PowerPoint cover?

• Key terms and formulas

• Historical events

• Scientific theories

• Literary analysis

Salary/Income can be calculated on which of the following bases?

• Daily

• Weekly

• Monthly

• Annually

What is gross pay?

• Your pay after deductions

• Your pay before any deductions are taken off

• Your net pay

• Your bonus pay.

How should gross pay be formatted?

• As a percentage

• As a fraction

• As currency

• As a decimal

What is 'Net Pay'?

• The total salary before deductions

• The 'take home' pay after deductions

• The amount paid in taxes

• The gross pay including bonuses.

Which of the following is included in the deductions from gross pay?

• Rent

• Tax

• Grocery bills

• Entertainment expenses.

The formula for calculating Net Pay is: A) Gross Pay + National Insurance + Tax B) Gross Pay - National Insurance - Tax C) Gross Pay * National Insurance * Tax D) Gross Pay / National Insurance / Tax.

• Gross Pay + National Insurance + Tax

• Gross Pay - National Insurance - Tax

• Gross Pay * National Insurance * Tax

• Gross Pay / National Insurance / Tax

What is a commission?

• A regular salary

• An extra amount received on top of your normal wage

• A tax deduction

• A loan repayment