Page 318 - TP_IT_V1.0_C9_flipbpookl
P. 318
You will see that the formula is automatically copied to the rest of the cells with the cell address automatically adjusted
accordingly as shown below.
Using Copy and Paste for Copying the Formula
Following are the steps to copy a formula using the copy-paste command:
Step 1: Select the cell that contains the formula.
Step 2: Press the Ctrl + C keys to copy the contents of the selected cell.
Step 3: Select the cell to which the formula is to be pasted.
Step 4: Paste the contents in the selected cell.
Step 5: Press the Ctrl + V keys to paste the contents of the selected cell.
Complete the following spreadsheet. Use fill handle, wherever possible to automate the
uiz Bee date entry. F2 should be sum values from B2 to E2. Drag the fill handle to copy the formula
till F6.
G2 should be the average of values from B2 to E2. Copy this formula till G6 using the
Auto Fill feature.
Subject: To show formulas in LibreOffice Calc
Step 1: Click on the View from the Menu bar.
Step 2: Click on the Show Formula option. Now, the formula is visible in place of result.
FIND AND REPLACE
In a spreadsheet, you can find text, formulas, and styles by using Find and Replace dialog box. To open Find and
Replace dialog box, select the Find and Replace option from the Edit menu.
Text or numbers in cells may have been entered directly or may be the result of a calculation. The search method
depends on the type of data you are searching for. By default, Calc searches the current sheet. To search through all
sheets of the spreadsheet, select the All sheets check box.
316 Trackpad Information Technology (Ver. 1.0)-IX

