Page 61 - Artificial Intellegence_v2.0_Class_12
P. 61
Data Manipulation
Data stored in a spreadsheet can be used for calculation, graphical representation and information display. Let us learn
more about data manipulation.
Per f or ming C alculations
o perform any calculation in a spreadsheet, use the ' ' equal to) symbol, hich indicates that a formula has been
entered. Only then will the spreadsheet perform the calculation and display the outcome.
onsider the follo ing spreadsheet
o , let s calculate the total sales in each month.
tep Click the cell in which you want your answer.
tep ype equal to) sign to start the formula. lick on the cell using the left mouse button) that contains the
value to be used in your formula. alc ill automatically pick up the cell address. ou can also type in the cell
address)
IC T S ki l l s- IV 59

