1HOUR 26 MINUTES
EXCEL
FOR ADDITION
To take out sum we will write =select the box one by one and then add+ in etween them and click
enter so we will get the answer for addition.
FOR SUBTRACTION
Likewise, for subtraction we will enter = select the box one by one enter - key and the click enter so
we will get the answer for subtraction .
FOR AVERAGE
For average we will click on the total box then click on / button and click enter so we will get the
answer for the average.
FOR MULTIPLICATION
For multiplication we will do the same select the box or write numbers manually and then put this *
star sign which will come by cicking shift + 8 inbetween numbers or boxes and click enter so we will
get the answer for multiplication.
FOR AADDING ANY ROW OR COLUMN BETWEEN ANY ROW OR COLUMN
For this purpose we will first select the row or column before which we have to add any row or
column and then right click on it and click insert button so one row or column will be inserted
inetween them, we we have to add more then one so we will simply select till the rows or column we
want like three so we will select till three and then click on insert so the required number of rows or
column will be added in between.(for adding new column we can also click alt+i+c)
(for adding new rows we can also click alt+i+r)
FOR CHANGING THE POSITION OF MORE NUMBER OF CELLS
For that we have to select the rows or colum of which we have to change the place click the cut
button after then click on the cell before which we have to add all these cells and right click there and
enter on insert cut cells so the position of all the cells will be changed and will be there where we
wanted them to be.
TO FIND AND REPLACE SOMETHING
FIND
For finding any name or information we will click find button in the home tab or click ctrl + f so we can
check wher the information is actually written.
REPLACE
For replacing any informaton by any other or replace any name by any other name we click manually
on home and click replace button or simply click ctrl+h for replacement of any name like if we have to
change all the ali in saim so will will click on ctrl+h and write on find ali and enter saim on replace then
all the ali in sheet will be alter into saim.
REPLACE SOMETHING IN THE RANGE OF CELLS
To replaCe something in the range of Cells we will select the range and then likewise clcik on ctrl +h
and add info of find what and replace with and all the information in the required range will be
changed.
FOR AUTOCORRECT OPTIONS/ PROOFING
For this we will click on file-more-options-proofing-auto correect oprtions
The purpose for this is to correct spelling and to write short keys like will add info of em and write
email in autocorrect option so when we will write em it will be automatically changed into our email it
make out work easy and reduce spelling mistakes.
Example: we will add ph on replace and on with we will write phone number so whenever we will
write ph it will automatically converted into phone number so it saves our time.
FORMATING
*MERGE AND CENTER: BY SELECTING THE CELL AND THE CLICK ON MEGE WHICH IS IN HOME BUTTON
*FOR ADDING COLOUR WE WILL SIMPLY ADD AND FOR WATCHING FURTHER SETTING WE WILL CLICK
CTRL+1 SO ALL THE FORMAT CELL SETTING WILL BE OPENED AND WE CAN SET ALLIGMENT ADD
GRADIENT FROM THERE ACCORDINGLY.
BORDER TOOL
*ADD BORDER BY CLICKING ON THE CELL AND CLICK ON ANY TYPE O BORDER LIKE THICK OUTIDE
BORDER.
FORMAT PAINTER
*TO COPY AND PASTE SAME FORMAT IN OTHER CELLS AS WELL WE WILL DOUBLE CLICK ON FORMAT
PAINTER AND THEN CLCK ACCORDINGLY ON CELLS WHICH WE HAVE TO KEEP IN SAME FORMAT.
ALLINGNMENT
FOR PROPER ALLIGNMENT WE WILL SELECT ALL THE CELLS AND ALLIGNMENT ACCORDINGLY IN
CENTER OR ANYWHERE REQUIRED.
WRAP TEXT
It is the tool used for allignment of long sentences in the cells accordingly
COPY AND PASTE SPECIAL ACCORDING TO YOUR NEED IF YOU NEED ONLY VALUES OR ANYTHING
FOR FORMATING YOU CAN ALSO USE TEMPLATES GIVEN IN FORMAT AS TABLE AND THEN USE CELL
STYLE FOR THE HEADING ACCORDINGLY