Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Excel document with anwsers, Cheat Sheet of MS Microsoft Excel skills

Copy and paste this document in order to get good grade

Typology: Cheat Sheet

2023/2024

Uploaded on 04/24/2025

benet-giesler
benet-giesler 🇺🇸

2 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
PROJECTED PAYCHECK
Number of Expected Hours worked - Regular Time 40
Number of Expected Hours worked - Overtime Time 8
Total 48
Regular Pay Rate $ 10.75
Overtime Pay Rate $ 16.13
Total Regular Earnings $ 430.00
Total Overtime Earnings $ 129.00
Gross Pay $ 559.00
Deductions:
Federal Income Tax Withholding $ 55.90
State IncomeTax Withholding $ 20.96
Social Security $ 34.66
Total Deductions $ 111.52
Net Pay $ 447.48
Yearly Net Pay $ 23,268.93
Monthly Net Pay $ 1,939.08

Partial preview of the text

Download Excel document with anwsers and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity!

PROJECTED PAYCHECK

  • Number of Expected Hours worked - Regular Time
  • Number of Expected Hours worked - Overtime Time
  • Total
    • Regular Pay Rate $ 10.
    • Overtime Pay Rate $ 16.
    • Total Regular Earnings $ 430.
    • Total Overtime Earnings $ 129.
    • Gross Pay $ 559.
    • Federal Income Tax Withholding $ 55. Deductions:
    • State IncomeTax Withholding $ 20.
    • Social Security $ 34.
    • Total Deductions $ 111.
    • Net Pay $ 447.
    • Yearly Net Pay $ 23,268.
    • Monthly Net Pay $ 1,939.