Create the following worksheet and save the workbook as WAGES.ods.

(i) Find out the number of days each worker has worked, by subtracting date on which worker was hired from today's date.

(ii) Calculate Gross wages for each worker. The gross wages can be calculated by using the following formula :

Gross wages = No. of days worked * Pay rate

(i) To find out the number of days each worker has worked, follow the given steps:

Step 1 — Select cell C7 and type the formula =$\text{\textdollar}$C$\text{\textdollar}$3 - B7. Press Enter key. The number of working days will appear in the cell.

The given formula subtracts the date on which the worker was hired from today's date. This gives us the number of days the worker has worked.

Step 2 — With C7 selected, dragging the cell handle from C8 to C12 will copy the formula to the cell range [C8 : C12].

Notice that the formula =$\text{\textdollar}$C$\text{\textdollar}$3 - B7 will modify itself according to the cell. Cell address $\text{\textdollar}$C$\text{\textdollar}$3 is an absolute address, so it will not change. But the relative address B7 will change according to the position of the cell.

So, the formula =$\text{\textdollar}$C$\text{\textdollar}$3 - B8 will be pasted in cell C8, =$\text{\textdollar}$C$\text{\textdollar}$3 - B9 will be pasted in C9, =$\text{\textdollar}$C$\text{\textdollar}$3 - B10 will be pasted in cell C10 and so on.

(ii) To calculate the gross wages for each worker, follow the given steps:

Step 1 — Select cell D7 and type the formula =C7*$\text{\textdollar}$C$\text{\textdollar}$4. Press Enter key. The gross wages of Kushagra will appear in the cell.

The given formula multiplies the number of working days and the pay rate per day.

Step 2 — With D7 selected, dragging the cell handle from D8 to D12 will copy the formula to the cell range [D8 : D12].

Notice that the formula =C7*$\text{\textdollar}$C$\text{\textdollar}$4 will modify itself according to the cell. Cell address $\text{\textdollar}$C$\text{\textdollar}$4 is an absolute address, so it will not change. But the relative address C7 will change according to the position of the cell.

So, the formula =C8*$\text{\textdollar}$C$\text{\textdollar}$4 will be pasted in cell D8, =C9*$\text{\textdollar}$C$\text{\textdollar}$4 will be pasted in D9, =C10*$\text{\textdollar}$C$\text{\textdollar}$4 will be pasted in cell D10 and so on.