Calculate Gross Pay, Superannuation, Tax Withheld and Net Pay.
Monthly Pay Roll
The purpose of spreadsheet is to categorize and organize the data in a logical format.
Spreadsheet can store all different kinds of data such as financial data, product data and client’s
data. Business now a day use spreadsheet to track all the business accounts and data. Formulas
are provided in spreadsheet by which it will help to do all the calculations. This reduce a lot of
time by doing the calculations manually. The characteristics of a good spreadsheet are the
design of the workbook, the areas of the worksheet and the standards that the company
required for. When creating a spreadsheet, it should be accurate, flexible, clear, efficient and
In this spreadsheet, the design used is the timesheet style. The “fill” function will be used to
auto fill all the data with same formula. While the formatting and formula used are summation,
multiplication and subtraction. The formulas used will allow to make calculation more accurate
Sometimes, it is difficult to navigate the large workbooks. The row of sheet tabs across the
bottom of the window is a terrible mechanism for finding way around if there are more than a
handful of tabs. When there are more tabs than can be displayed across the screen, it becomes