The key board shortcuts to cut, copy, paste
Cut - Ctrl + X
Copy - Ctrl + C
Paste - Ctrl + V

In Calc, "&" is a text operator which is used to combine two or more text. Joining two different texts is also known as “Text Concatenation". An expression using the text operator has the following
syntax: text referencel & text reference2.

.=(A1 + A2 + A3)/3 (or) = Average (A1 : A3) = 62.7%

(i) OpenOffice Calc is a popular open source spreadsheet application maintained by Apache Foundation.
(ii) Calc is the spreadsheet component of OpenOffice. You can enter any kind of data in a spreadsheet and then manipulate this data to produce certain results.
(iii) Alternatively, enter data and then use Calc in a 'What If..' manner by changing some of the data and observing the results without having to retype the entire spreadsheet.

1. = Sum (B5 : E5) = 4285
2. = Sum (E2 : E6) = 1600
3. = Sum (C5 : D6) = 4395
4. = Average (B2 : B6) = 1760
5. = Average (B2 : B6) = 1760
5. =(B6 - E6) = 1700

Resize the width of a column using the mouse :
Use the right hand border to increase or decrease the width of a column.
(i) Position the cursor on the right hand border of the column letter box, until you see a double headed arrow.
(ii) Hold down the left hand mouse button and drag the border to the left or right to make the column narrower or wider as required.
As you carry out this action, the width of the column displays.

Resize one or more columns using Format :
(i) Select the column(s) whose width you wish to change
(ii) Select Format \(\rightarrow\) Column \(\rightarrow\) Width
(ii) The Column Width dialog displays

(iv) Enter a value in the Width window or check the Default value check box to select the default column width.
(v) Click OK.
The selected columns display with the new width.