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
   48   49   50   51   52   53   54   55   56   57   58