Page 53 - Artificial Intellegence_v2.0_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.
Enter ing Data in a S pr eadsheet
erform the follo ing steps to enter the data in a spreadsheet
tep 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.
tep hen, ust type the data using the keyboard and press the nter key. lease note that numeric values ill be
right-aligned and text values will be left-aligned as shown below.
Enter ing F or mulas
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. ach formula must begin ith an equal to) symbol. ust type the formula and press the nter key. alc ill do
the calculations for you!
Data T ypes
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.
et's take a look at hat they're used for. onsider the follo ing
Dheera runs a mobile shop. e keeps track of everything, including mobiles of various companies, headphones,
chargers, and so on. e enters the item's name, quantity purchased, quantity sold, selling price and cost price. e can
use a spreadsheet to enter names, numbers to enter quantities and so on.
IC T S ki l l s- IV 51

