Page 232 - IT_Play_V1.0 Class9
P. 232
2
3
4
1
Deleting Rows and Columns
To delete rows and columns in a sheet, follow the given steps:
Step 1: Select the row/column to be deleted.
Step 2: Click on Sheet menu from Menu bar.
Step 3: Select Delete Rows or Delete Columns from the drop-down menu.
Undo and Redo
While working in the sheet, the 'Undo' command helps the user reverse a series of actions, and the 'Redo'
command helps reverse the actions undone by the 'Undo' command.
‘Undo’ can be done by:
Clicking on the Undo option from the Edit menu from Menu bar. OR Clicking on the Undo button from
the Standard toolbar. OR Pressing Ctrl+Z.
‘Redo’ can be done by:
Clicking on the Redo option from the Edit menu from Menu bar. OR Clicking on the Redo button from the
Standard toolbar. OR Pressing Ctrl+Y.
MATHEMATICAL OPERATOR
Mathematical operator is a symbol that performs certain mathematical or logical operations. In a cell, the
calculation takes place in the order of precedence of operators. The table given below shows the operators,
their meaning:
The table given below shows the order of precedence of operators:
Mathematical Operators
+ addition Operator precedence
- subtraction First ( )
× multiplication Second ^
/ division Third /, ×
^ exponentiation (power) Fourth + , -
When two operators share the same ranking or precedence, calculation is done in the order from left to right.
Simple Calculations using Values and Operators
Table below illustrates how different mathematical operators can be used in formulas. You can include multiple
operators in a single formula, and the order of operations determines how these are evaluated.
230 Information Technology Play (Ver 1.0)-IX

