Scribd
Upload
6 views2 pages

Payroll Spreadsheet Task for Tuckshop

Uploaded by

naisha632010
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views2 pages

Payroll Spreadsheet Task for Tuckshop

Uploaded by

naisha632010
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

THE WESTMINSTER SCHOOL, DUBAI

Year: 10 Worksheet No/Term: 3/1

Topic: Data Analysis Date: 08/10/2024

GROUP 1
You are going to prepare an payroll using a spreadsheet for a tuck-shop. Open the
files tuckshop and complete the following task

1) Insert header with your name in the centre and year & section on the right side.
2) All salary values to be formatted as currency dollar with 2 decimal places.
3) Calculate Average number of days worked in cell C15
4) Find Maximum number of days worked in cell C16
5) Round C3 to 2 decimal places
6) Round C6 to nearest whole number
7) Inset a formula in C17 to Count the number of text in the Name column
8) Insert a formula in C18 to Count the number of values in days worked

Post your answer on the following padlet wall under your group number

[Link]

Extended question Level (2)


Insert a new row above the first row, merge it and add the title School Tuckshop

Count number of employees having salary grater than 2000.

You might also like