Page 71 - Web_Application_v2.0_C12_Fb
P. 71
Step 3: In the Print dialog box appears on the screen, specify the options such as:
• Name of the printer that is attached and is being used for printing.
• The range of pages to be printed that is all sheets or selected sheets.
• Number of copies to be printed.
• The page layout is to be selected that is page size or orientation.
Step 4: Click on the Print button and the sheet will be printed. Press Ctrl+P keys from the keyboard to print
a file.
3.10 WORKING WITH DATA AND FORMATTING TEXT
Spreadsheets are versatile tools that allow data to be used for calculations, visual representations, and
information display. Let’s dive deeper into how to effectively work with data in a spreadsheet.
Formula
A formula is a mathematical expression that performs calculations using values, cell references, and operators.
One of the most important features of a spreadsheet package is the ability to perform calculations, for which
formulas are used. Formulas are entered to carry out mathematical operations such as addition, subtraction,
multiplication, and division.
Entering a formula in a cell is a logical entry that shows the relationship between different cells. In LibreOffice
Calc or Excel, a formula always starts with an equal (=) sign. The formula applied in a particular cell can be
viewed in the formula bar when the specific cell is selected.
Formulas in Calc include the following:
Adding Values Directly
To calculate anything in a spreadsheet, start with the ‘=’ (equal-to) symbol. This informs the spreadsheet that
a formula is being entered, adds numbers directly, performs the calculation, and displays the result.
For example: Consider a spreadsheet that has the following details:
Step 1: Click on the cell where you want the result.
Step 2: Type =5+3+5+6+5.
ICT Skills-IV 69

