Various problems: Use of the spreadsheet for real life and other scenarios

Area : Math. Type : Individual. Level : Second Cycle of ESO

• Using the Spreadsheet, using copies of a taxpayer's annual payroll (with personal data omitted), calculate gross income, Social Security contributions, and personal income tax withholdings. Construct a bar chart with their absolute values and a pie chart with their percentages of these data.

• It establishes directly proportional and inversely proportional magnitudes in the payment of personal income tax.

• Calculate the VAT amounts for the following amounts (all of which include VAT ):

  • 760€ (21% VAT )

  • 425€ (10% VAT )

  • 32€ (4% VAT )