Page 53 - Web Applications (803) Class 12
P. 53
Performing Basic Operations in a Spreadsheet
A spreadsheet allows you to enter, edit and delete data and use data functions. Let us see the functions that spreadsheet
allows you to perform.
Entering Data in a Spreadsheet
Perform the following steps to enter the data in a spreadsheet:
Step 1: Click on the cell where you want to enter the data. Suppose you want to enter data in cell C1. So, click on C1
to select the cell.
Step 2: Then, just type the data using the keyboard and press the Enter key. Please note that numeric values will be
right-aligned and text values will be left-aligned as shown below.
Entering Formulas
A formula is an expression that helps to perform arithmetical calculations and also executes non-arithmetical tasks. It
consists of operands and operators that operate upon the data. Formulas can be entered in a cell or typed in the formula
bar. Each formula must begin with an ‘=’ (equal to) symbol. Just type the formula and press the Enter key. Calc will do
the calculations for you!
Data Types
Text, numbers and formulas are the three main types of data. These along with pictures, audio, video, and shapes can
be entered into a spreadsheet.
Let's take a look at what they're used for. Consider the following:
Dheeraj runs a mobile shop. He keeps track of everything, including mobiles of various companies, headphones,
chargers, and so on. He enters the item's name, quantity purchased, quantity sold, selling price and cost price. He can
use a spreadsheet to enter names, numbers to enter quantities and so on.
ICT Skills-IV 51

