Computer Applications
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
Related Questions
What is the difference between copying and moving a range ?
What is the difference between the following commands :
Edit → Delete Contents → Delete all and
Edit → Delete Contents → TextEdit → Delete Contents → Text and
Edit → Delete Contents → FormatsEdit → Delete Contents → Text and
Edit → Delete Contents → Notes
Create the following worksheet in Ooo Calc.
(i) From the above worksheet find out the average marks for the entire class.
(ii) Now copy the range consisting of the mentioned data (including total, average & class average) to a new location. Find out whether the cell references change or not.
(iii) Now move the original data range to a new location. Find out whether the cell references change or not.
(iv) Again move back the data to its original position and make changes in the marks obtained by students. Notice total, average and class average. What happens ? Why does this happen ?
Clear the copied data range (do not touch the 23. original data range).