Computer Applications
Clear the copied data range (do not touch the 23. original data range).
OOo Calc
10 Likes
Answer
To clear the copied data range, we follow the given steps:
Step 1 — Select the entire range by clicking on the first cell of the range and dragging the mouse pointer till the last cell of the range.
Step 2 — Right click on the selected range and select 'Clear Contents' from context menu. A 'Delete Contents' window will appear.
Step 3 — Check the check box in front of 'Delete all' option and press OK button.
Answered By
4 Likes
Related Questions
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
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 ?
Create the following worksheet in Ooo Calc :
From the above created worksheet find out the average marks for the entire class using appropriate formulas.