· MS OFFICE EXCEL 2007
MICROSOFT OFFICE 2007 IS A SPREAD SHEET PROGRAM IN WHICH WE CAN CALCULATE
ANY TYPE OF CALCULATION.IT IS A MATRICS OF ROWS AND COLUMNS.UNDER THIS PROGRAM
,WHEN WE CALCULATE ANY SAME CALCULATION THAN ONLY ONE CALCULATION
WILL BE CREATED AND OTHER ALL READY CALCULATE WITH DRAGE OPTION.WHENEVER WE
MAKE A CHANGES IN A VALUE OR NO. THAN
FORMULA WILL ALL READY RE-CALCULATE.
EXTENSION CODE OF MS OFFICE EXCEL 2007 :- .XLSX
(I)COLUMNS:- VERTICAL LINES THAT IS CALLED COLUMNS.AND COLUMNS DENOTED BY
A,B,C,D,E,…….XFD
NO. OF COLUMNS IN ONE SHEET:-16384
(II)ROWS:- HORIZENTAL LINES THAT IS CALLED ROWS.AND ROWS DENOTED BY
1,2,3,4,…….1048576.
NO. OF ROWS IN ONE SHEET:-1048576
(III)CELL:- DEVIDING BY ROWS AND COLUMNS IS CALLED CELLS.AND CELLS DENOTED
BY A1,B1,C1,……XFD1048576
(IV)SHEET:-MATRICS OF ROWS AND COLUMNS THAT IS CALLED SHEET.AND SHEET
DENOTED BY SHEET1,SHEET2,SHEET3,………etc.
Q. HOW TO OPEN MS OFFICE EXCEL 2007?
STEPS:-START BUTTON=>ALL PROGRAM=>MS OFFICE=>MS OFFICE EXCEL
2007.
OR,
START BUTTON=>TYPE
EXCEL(UNDER SEARCH PROGRAM AND FILE)=>ENTER.
Q. HOW TO CHANGE IN ANY WRITTEN CELL ?
STEPS:- (I)SELECT THE CELL=>CHANGE IN FORMULA BAR
(II)SELECT THE
CELL=>PRESS F2 BUTTON=>CHANGE IN THE CELL.
(III)SELECT THE
CELL=>DOUBLE LEFT CLICK(THAN CURSOR
APPEAR UNDER THE SELECTED CELL)=>CHANGE IN THE CELL.
· ALIGNMENT GROUP:-
· ALIGNMENT:-THIS OPTION IS USE TO
APPLY ANY ALIGNMENT ON THE SELECTED CELL WITH THE HELP OF
LEFT,RIGHT,TOP,BOTTOM,MIDDLE,CENTER.
STEPS:-SELECT THE CELL=>HOME TAB=>ALIGNMENT GROUP=>SELECT ANY
ALIGNMENT(LEFT/RIGHT/TOP/BOTTOM/MIDDLE/CENTER).
· ORIENTATION:-THIS OPTION IS USE TO
SET THE ORIENTATION OF THE SELECTED CELL.
STEPS:-SELECT THE CELL=>HOME TAB=>ALIGNMENT
GROUP=>ORIENTATION=>SELECT ANY ORIENTATION.
BUT WHEN WE WANT TO
SET ANY OTHER ORIENTATION THAN GOTO =>FORMAT CELL ALIGNMENT=>SELECT ANY
ALIGNMENT=>OK.
· WRAP TEXT:-THIS OPTION IS USE TO
ARRANGE THE WRITTEN TEXT IN ONE CELL IN MANY LINES.
STEPS:-SELECT THE WRITTEN CELL=>HOME TAB=>ALIGNMENT GROUP=>WRAP
TEXT.
· MERGE AND CENTER:-THIS OPTION IS USE
TO MERGE THE SELECTED CELLS.
STEPS:-SELECT THE CELLS =>HOME TAB=>ALIGNMENT GROUP=>MERGE AND
CENTER.
· CUSTOM NUMBER FORMAT:-THIS OPTION IS
USE TO SET THE NO. FORMAT WITH THE HELP OF NO. AND TEXT.
STEPS:-ALIGNMENT GROUP LOUNCHER=>NUMBER=>CUSTOM=>TYPE NO.
FORMAT(UNDER GENERAL OPTION) LIKE “ST/”000=>OK.
· INSERT:-THIS OPTION IS USE TO INSERT
ANY ROW ,COLUMN,CELL AND SHEET BESIDES THE SELECTED CELL.
STEPS:-SELECT THE CELL=>HOME TAB=>CELLS
GROUP=>INSERT=>SELECT ANY ONE(INSERT CELL/COLUMN/SHEET/ROW).
· DELETE:-THIS OPTION IS USE TO DELETE
ANY ROW ,COLUMN,CELL AND SHEET BESIDES THE SELECTED CELL.
STEPS:-SELECT THE CELL=>HOME TAB=>CELLS GROUP=> DELETE
=>SELECT ANY ONE(DELETE CELL/COLUMN/SHEET/ROW).
· AUTOFIT ROW/COLUMN:-THIS OPTION IS
USE TO ADJUST THE COLUMN WIDTH AND ROW
HIGHT.
STEPS:-SELECT ROW/COLUMN=>HOME TAB=>CELLS
GROUP=>FORMAT=>SELECT ANY ONE(AUTOFIT ROW HIGHT/AUTOFIT COLUMN WIDTH).
· RENAME SHEET:-THIS OPTION IS USE TO
RENAME ANY SELECTED SHEET.
STEPS:-SELECT THE SHEET=>HOME TAB=>CELLS
GROUP=>FORMAT=>RENAME SHEET=>TYPE ANY NAME =>ENTER.
· HIDE & UNHIDE:-THIS OPTION IS USE
TO HIDE OR UNHIDE ANY SELECTED ROW,COLUMNS,SHEET.
STEPS:-CLICK ON ANY CELL=>HOME TAB=> CELLS
GROUP=>FORMAT=>HIDE & UNHIDE=>SELECT ANY ONE(HIDE
ROW/COLUMN/SHEET)
BUT
WHEN WE WANT TO UNHIDE ANY HIDE COLUMN,ROW,SHEET THAN GOTO SELECT
ROW/COLUMN/SHEET BESIDE THE HIDDEN ROW/COLUMN/SHEET.=> HOME TAB=> CELLS
GROUP=>FORMAT=>HIDE & UNHIDE=>SELECT ANY ONE(UNHIDE
ROW/COLUMN/SHEET).
· MOVE OR COPY SHEET:-THIS OPTION IS
USE TO MOVE ANY SELECTED SHEET ON THE ANOTHER SHEET PLACE AND CREATE A OTHER
COPY OF THE SELECTED SHEET.
STEPS:-SELECT THE SHEET=> HOME TAB=>CELLS GROUP=>FORMAT=>MOVE
OR COPY SHEET=>SELECT THAT SHEET NAME WHERE WE WANT TO MOVE THE SELECTED
SHEET=>OK.
BUT
WHEN WE WANT TO CREATE A ANOTHER COPY OF THE SELECTED SHEET THAN GOTO=>MOVE OR COPY SHEET=>CREATE A
COPY=>OK
· TAB COLOR:-THIS OPTION IS USE TO
APPLY ANY COLOR WITH SHEET NAME .
STEPS:-SELECT THE SHEET NAME=> HOME TAB=>CELLS
GROUP=>FORMAT=>TAB COLOR=>SELECT ANY COLOR.
· PROTECT SHEET:-THIS OPTION IS USE TO
PROTECT ANY SELECTED SHEET BY THE PASSWORD.
STEPS:-SELECT THAT SHEET IN WHICH PASSWORD APPLY=> HOME TAB=>CELLS
GROUP=>FORMAT=>PROTECT SHEET=>TYPE PASSWORD=>OK=>AGAIN TYPE
PASSWORD=>OK.
· PROTECT EXCEL DOCUMENT:-THIS OPTION
IS USE TO PROTECT ANY EXCEL DOCUMENT BY THE PASSWORD.
STEPS:-OFFICE BUTTON=>PREPARE=>ENCRYPT DOCUMENT=>TYPE
PASSWORD=>OK=>AGAIN TYPE PASSWORD=>OK.
· STYLE GROUP:-
*CELL STYLE:-THIS OPTION IS USE TO APPLY ANY COLOR STYLE ON THE SELECTED
CELL.
STEPS:-SELECT THE CELLS=>HOME TAB=>STYLE GROUP=>CELL
STYLE=>SELECT ANY CELL STYLE.
*FORMAT AS TABLE:-THIS OPTION IS USE TO APPLY ANY STYLE ON THE SELECTED
TABLE.
STEPS:-SELECT THE TABLE=>HOME TAB=>STYLE GROUP=>FORMAT AS
TABLE=>SELECT ANY TABLE STYLE.
*CONDITIONAL FORMATING:-THIS OPTION IS USE TO APPLY ANY FORMATING ACCORDING TO CONDITION
WITH THE HELP OF FOLLOWING FORMATING:-
(I)HIGHLIGHT CELL RULE:-THIS OPTION IS USE TO HIGHLIGHT ANY SELECTED CELL
NO.(WITH THE HELP OF GREATTER /LESS/BETWEEN/EQUAL) AND TEXT(WITH THE HELP OF
TEXT THAT CONTAIN).
STEPS:-SELECT THE NO./TEXT CELL=> HOME TAB=>STYLE
GROUP=>CONDITIONAL FORMATING=>HIGHLIGHT CELL RULE=>SELECT ANY ONE(GREATTER
/LESS/BETWEEN/EQUAL/TEXT THAT CONTAIN)=>TYPE NO./TEXT=>SELECT
COLOR=>OK.
(II)TOP/BOTTOM RULE:-THIS OPTION IS USE TO HIGHLIGHT THE SELECTED NO.
CELL ACCORDING TO LARGEST AND SMALLEST.
STEPS:-SELECT THE NO. CELL=> HOME TAB=>STYLE GROUP=>CONDITIONAL
FORMATING=>TOP/BOTTOM RULE=>SELECT ANY ONE(TOP 10 ITEM/BOTTOM 10
ITEM)=>SELECT NO.=>SELECT COLOR=>OK.
(III)DATA BAR AND COLOR SCALE :-THIS OPTION IS USE TO APPLY ANY COLOR
WITH THE HELP OF DATA BAR AND COLOR SCALE ONLY ON THE NO. CELLS.
STEPS:-SELECT ANY NO. CELLS=> HOME TAB=>STYLE GROUP=>CONDITIONAL
FORMATING=>SELECT ANY ONE(DATA BAR/COLOR SCALE)=>CLICK ON ANY STYLE.
(IV)ICON
SET:-THIS OPTION IS USE TO APPLY ANY ICON WITH ANY NO. CELLS.
STEPS:-SELECT THE NO. CELLS=> HOME TAB=>STYLE GROUP=>CONDITIONAL
FORMATING=>ICON SETS=>SELECT ANY ICON.
· CELL
REFERENCE:- REFERENCE IS USE WHEN ANY FORMULA DRAGE IN OTHER CELLS.
(I)RELATIVE REFERENCE:-DRAGE OF THAT FORMULA IN WHICH ALL USED
CELL ARE CHANGE ACCORDING TO DRAGE THAN USE ONLY CELL NAME IN FORMULA.
EX:-
(II)ABSOLUTE REFERENCE:- DRAGE OF THAT FORMULA IN WHICH SOME CELLS
ARE CHANGE BUT SOME CELL ARE NOT CHANGE THAN PRESS F4 FOR FIXING THE FIXED
CELL.
EX:-
(III)MIXED REFERENCE:- DRAGE OF THAT FORMULA IN WHICH DRAGE
FORMULA IN ROW AND COLUMN BOTH.BUT WHEN WE DRAGE IN COLUMN THAN ROW CELL FIXED
AND DRAGE THE FORMULA IN ROW THAN COLUMN CELL FIXED THAN USE $ BEFORE THE
COLUMN CELL AND USE $ BETWEEN THE ROW CELL.
EX:-
· FILL
· SERIES
(I)LINEAR:-THIS OPTION IS USE TO WRITE COUNTING,TABLE(ALL ADD
VALUE).
STEPS:-SELECT FIRST NO. CELL=>HOME TAB=>EDITING
GROUP=>FILL=>SERIES=>SELECT ROW/COLUMN=>SELECT LINEAR=>TYPE STEP
VALUE AND STOP VALUE=>OK.
(II)GROWTH:-THIS OPTION IS USE TO WRITE GROWTH VALUE.
STEPS:-SELECT FIRST NO. CELL=>HOME TAB=>EDITING
GROUP=>FILL=>SERIES=>SELECT ROW/COLUMN=>SELECT GROWTH=>TYPE STEP
VALUE AND STOP VALUE=>OK.
(III)DATE:-THIS OPTION IS USE TO WRITE ANY DATE VALUE WITH
DIFFERENT IN DAY/MONTH/YEAR/WEEKDAY .
STEPS:- SELECT FIRST DATE CELL=>HOME TAB=>EDITING
GROUP=>FILL=>SERIES=>SELECT ROW/COLUMN=>SELECT DATE=>SELECT ANY
ONE(DAY/MONTH/YEAR/WEEKDAY)=>TYPE STEP VALUE AND STOP VALUE=>OK.
· CUSTOM
LIST:-THIS OPTION IS USE TO CREATE A LIST WITH MANY NAMES.
STEPS:-OFFICE BUTTON=>EXCEL OPTION=>EDIT CUSTOM
LIST=>TYPE A NEW LIST WITH THE HELP OF (,) OR ENTER=>ADD=>OK=>OK.
· SOME
MATHEMETICAL CALCULATION IN MS EXCEL:-
· SUM
FUNCTION:-THIS FUNCTION IS USE TO CALCULATE ANY ADD VALUE OF THE SELECTED
CELLS.
FORMULA:- =SUM(FIRST CELL :
LAST CELL)
EX:- =SUM(A1:D1)
· MAX
FUNCTION:-THIS FUNCTION IS USE TO CALCULATE ANY MAXIMUM VALUE OF THE SELECTED
CELLS.
FORMULA:- = MAX (FIRST CELL
: LAST CELL)
EX:- = MAX (A1:D1)
· MIN
FUNCTION:-THIS FUNCTION IS USE TO CALCULATE ANY MINIMUM VALUE OF THE SELECTED
CELLS.
FORMULA:- = MIN(FIRST CELL
: LAST CELL)
EX:- = MIN (A1:D1)
· AVERAGE FUNCTION:-THIS FUNCTION IS USE TO CALCULATE
ANY AVERAGE VALUE OF THE SELECTED CELLS.
FORMULA:- = AVERAGE(FIRST
CELL : LAST CELL)
EX:- = AVERAGE(A1:D1)
· SQRT FUNCTION:-THIS FUNCTION IS USE TO CALCULATE
ANY SQRT VALUE OF THE SELECTED CELLS.
FORMULA:- = SQRT(SELECT THE
CELL)
EX:- = SQRT (A1)
· POWER FUNCTION:-THIS FUNCTION IS USE TO CALCULATE
ANY POWER VALUE OF THE SELECTED CELLS WITH GIVEN POWER NO.
FORMULA:- = POWER(SELECT
THE NO. CELL,NO. OF POWER)
EX:- = POWER(A1,2)
· ROUND FUNCTION:-THIS FUNCTION IS USE TO CALCULATE
ANY ROUND VALUE OF THE SELECTED CELLS WITH GIVEN NO. AFTER DECIMAL.
FORMULA:- = ROUND(SELECT
THE NO. CELL,NO. AFTER DECIMAL)
EX:- = ROUND(A1,2)
· COMMENT
:-THIS OPTION IS USE TO ADD ANY TEXT WITH THE SELECTED CELL.
STEPS:-SELECT THE TEXT=>REVIEW TAB=>COMMENT GROUP=>NEW
COMMENT=>TYPE ANY COMENT.
Q. HOW TO EDIT, DELETE, HIDE ANY COMMENT ?
STEPS:-RIGHT CLICK ON THE COMMENT CELL=>SELECT ANY
ONE(EDIT/HIDE/DELETE COMMENT).
· DATE RELATED
FUNCTION:-
(I)DATE FUNCTION:-THIS FUNCTION IS USE TO WRITE THE DATE WITH THE HELP OF DAY,MONTH AND
YEAR.
FORMULA:-
=DATE(YEAR,MONTH,DAY)
(II)TODAY FUNCTION:-THIS FUNCTION IS USE WHEN FIND OUT THE CURRENT
DATE AND TIME.
FORMULA:- =TODAY()
10 DAYS AFTER
TODAY- =TODAY()+10
10 DAYS BEFORE TODAY - =TODAY()-10
(III)NOW FUNCTION :-THIS FUNCTION IS USE TO FIND OUT THE CURRENT
TIME AND DATE.
FORMULA:- =NOW()
· LOGICAL
FUNCTION:-THIS TYPE OF FUNCTION IS USE WHEN TWO OR MORE CONDITION ARE APPLY IN
ONE TIME AND RESULT WILL BE DIFFERENT.
· IF
FUNCTION:-THIS FUNCTION IS USE WHEN TWO CONDITION ARE APPLY AND RESULT WILL BE
DIFFERENT.
FORMULA:-
=IF(CONDITION,”POSSITIVE RESULT”,”NEGATIVE RESULT”)
EX:-
· NESTED IF
FUNCTION:-THIS FUNCTION IS USE WHEN MORE THAN TWO CONDITION ARE APPLY IN
ONE TIME AND RESULT WILL BE DIFFERENT.
FORMULA:- =IF(1ST
CONDITION,RESULT,IF(2ND CONDITION,RESULT,…………))……
EX:-
· AND
FUNCTION:-THIS FUNCTION IS USE TO APPLY TWO CONDITION IN ONE TIME AND BOTH ARE
FULLFILL.
FORMULA:- =IF(AND(1ST
CONDITION,2ND CONDITION),REST TRUE,RESULT FALSE)
EX:-
· OR
FUNCTION:-THIS FUNCTION IS USE WHEN TWO CONDITION ARE APPLY IN ONE TIME BUT ANY
ONE CONDITION IS FULLFILL.
FORMULA:- =IF(OR(1ST
CONDITION,2ND CONDITION),REST TRUE,RESULT FALSE)
EX:-
· NOT
FUNCTION:-THIS FUNCTION IS USE WHEN NEGATIVE CONDITION APPLY IN FIRST TIME AND SECONDLY
POSSITIVE.
FORMULA:-
=IF(NOT(CONDITION),NEGATIVE RESULT,POSSITIVE RESULT)
EX:-
· SUMIF
FUNCTION:-THIS FUNCTION IS USE TO ADD ANY PARTICULAR AMOUNT OF THE SELECTED
CELL.IN THIS FUNCTION THREE COMPONENTS ARE USE:-
(I)RANGE:-THAT AREA WHERE ALL ITEMS AVAILABLE THAT IS CALLED
RANGE.
(II)CRITERIA:-NAME OF THE PARTICULAR ITEM THAT IS CALLED CRITERIA.
(III)SUM RANGE:-THE COLUMN IN WHICH RANGE AMOUNT AVAILABLE THAT IS
CALLED SUM RANGE.
Formula:- =SUMIF(RANGE,CRITERIA,SUM
RANGE)
·
COUNT FUNCTION:-THIS FUNCTION IS USE TO CALCULATE THE
QUANTITY OF THE SELECTED ITEMS BUT COUNT FUNCTION DOES NOT SUPPORT ANY BLANK
CELL OR TEXT CELL.
FORMULA:-
=COUNT(FIRST CELL:LAST CELL)
·
COUNT IF FUNCTION:-THIS FUNCTION IS USE WHEN CALCULATE
THE NO. OF ANY PARTICULAR ITEMS.
FORMULA:-
=COUNTIF(RANGE,CRITERIA)
EX:-
·
ISBLANK FUNCTION:-THIS
FUNCTION IS USE WHEN SOME USES CELLS ARE BLANK .
FORMULA:-
=IF(ISBLANK(BLANK CELL),FULL AMOUNT,FULL AMOUNT-INSTOLMENT)
·
FINANCIAL FUNCTION:-
EXCEL IS OFTEN USED TO PERFORM CALCULATION INVOLVING MONEY
FROM BASIC HOME BUDGET TO COMPLEX FINANCIAL DECESSION MAKING.
LOAN FUNCTION:-SOME COMPONENT OF LOAN CALCULATION
(1)LOAN AMOUNT
(2)THE INTREST RATE
(3)THE NO. OF PAYMENT PERIOD
(4)THE PERIODIC PAYMENT AMOUNT
IF
WE KNOW ANY THREE OF COMPONENT WE CAN
CREAT A FORMULA TO CALCULATE THE UNKNOWN COMPONENT
NOTE:-THE LOAN CALCULATION IN THIS SECTION ALL ASSUME AT
FIXED RATE LOAN WITH A FIX TERM.
·
THE PMT FUNCTION:-THE PMT FUNCTION RETURN THE LOAN PAYMENT
(PRINCIPAL+INTEREST)PER PERIOD ,ASSUMING CONSTENT PAYMENTAMOUNT AND A FIXED
INTEREST RATE.
FORMULA:- =PMT(RATE
,NPER,PV,FV,TYPE)=>ENTER
OR
=PMT CTRL+A =>FILL UP THE
BOX(VALUE)=>OK
·
THE PPMT FUNCTION
(PRINCIPAL PERIODIC AMOUNT) THE PPMT FUNCTIONAL RETURNS THE PRINCIPAL PARTS OF
A LOAN PAYMENTS FOR A GIVEN PERIOD ASSUMING CONSTENT PAYMENT AMOUNT AND A FIXED
INTREST RATE.
FORMULA:- =PPMT(RATE
,PER,NPER,PV,FV,TYPE)
OR
=PPMT CTRL+A=>OK
·
THE IPMT FUNTION
(INTEREST PERIODIC AMOUNT):-THE IPMT FUNCTION RETURNS THE INTEREST PARTS OF A
LOAN PAYMENT FOR A GIVEN PERIOD ASSUMING CONSTENT PAYMENT AMOUNT AND A FIXED
INTEREST RATE.
FORMULA:- =IPMT(RATE,PER ,NPER,PV,FV,TYPE)
OR
=IPMT
CTRL+A=>OK
·
THE PV FUNCTION :-THE PV(PRESENT VALUE)RETURNS THE PRESENT
VALUE (I.E THE ORIGNAL LOAN AMOUNT)FOR A LOAN ,GIVEN THE INTEREST RATE THE NO.
OF PERIOD AND PERIOD PAYMENT AMOUNT.
FORMULA:-
=PV(RATE,NPER,PMT,FV,TYPE)=>ENTER
OR
=PV
CTRL+A=>OK
·
THE RATE FUNCTION:-THE RATE FUNCTION RETURNS THE RATE OF
INTEREST OF THE GIVEN PRESENT VALUE WITH A LIMIT PERIOD.
FORMULA:-
=RATE(NPER,PMT,PV,FV,TYPE)=>ENTER
OR,
=RATE Ctrl+A
=>OK
·
NPER FUNCTION:-THE NPER FUNCTION RETURNS THE NO. OF PERIOD OF
THE AMOUNT WITH GIVEN AMOUNT AND FIXED INTEREST RATE.
FORMULA:- =NPER(RATE,PMT,PV,FV,TYPE)=>ENTER
OR,
=NPER Ctrl+A =>OK.
·
SORT:-THIS OPTION IS USE TO ARRANGE THE DATA IN ASCENDING AND
DESCENDING ORDER.
STEPS:-SELECT THAT CELL ACCORDING TO,WE WANT TO ARRANGE THAT
DATA=>DATA TAB=>SORT AND FILTER GROUP=>SORT=>SELECT EXPEND THE
SELECTION(WHEN WE WANT TO CHANGE ALL VALUE ACCORDING TO ARRANGING =>SELECT
THAT NAME ACCORDING TO WE WANT TO ARRANGE(UNDER SORT BY OPTION)=>SELECT
ASCENDING OR DESCENDING ORDER=OK.
BUT WHEN WE WANT TO ARRANGE ANY COLUMN
BUT ALL COLLUMNS SHOULD NOT BE CHANGE THAN=>SELECT CONTINUE WITH THE CURRENT
SELECTION=>SELECT ASCENDING OR DESCENDING ORDER=>OK.
·
SUB TOTAL AND GRAND TOTAL:-THIS OPTION IS USE TO ADD EACH
PARTICULAR ITEM IN THE SELECTED LIST(i.e SUB TOTAL)AND TOTAL OF ALL ITEMS IS
CALLED GRAND TOTAL.
STEPS:-SELECT THE LIST =>DATA TAB=>OUTLINE
GROUP=>SUB TOTAL=>SELECT THAT ITEM NAME ACCORDING TO, WE WANT TO ADD
THE VALUE(UNDER AT EACH CHANGE IN
OPTION)=>SELECT THE FUNCTION(UNDER USE FUNCTION OPTION)=>CLICK ON THAT
ITEM WHICH WE WANT TO ADD=>SELECT EACH ACCORDING TO REQUAREMENT((I)REPLACE
CURRENT SUB TOTAL,(II)PAGE BREAK BETWEEN GROUP(III)SUMMARY BELOW DATA=>OK.
·
FILTER:-THIS OPTION IS USE TO SHOW THE FILTER MARK ON THE
HEADING OF THE DATA ROW AND THE WORK OF FILTER IS HIDE ANY PERSONAL INFORMATION
BY THE CLICKING ON THE FILTER MARK.
STEPS:-SELECT THE TABLE=>DATA TAB=>SORT AND FILTER
GROUP=>FILTER (THAN FILTER MARK SHOW ON THE TABLE)=>CLICK ON ANY FILTER
MARK=>CLICK OF THAT NAME WHICH WE WANT TO HIDE=>OK.
·
ADVANCE FILTER;-THIS OPTION IS USE TO COPY ANY PARTICULAR
DATA ON THE SELECTED LIST WITH ALL DETAILS.
STEPS:-FIRST OF ALL WRITE CRETERIA ON ANY WHERE=>SELECT
THE LIST=>DATA TAB=>SORT AND FILTER GROUP=>ADVANCE(THAN SHOW THE
ADVANCE FILTER OPTION ON THE SCREEN) =>SELECT CRETERIA =>COPY TO ANOTHER
LOCATION=>SELECT THAT CELL IN WHICH WE WANT TO COPY DATA(UNDER COPY TO
OPTION)=>OK.
·
FREEZE:-THIS OPTION IS USE TO FREEZE ANY FIRST ROW/FIRST
COLUMN/SELECTED AREA.
STEPS:-CLICK ON THE LIST=>VIEW TAB=>WINDOWS
GROUP=>FREEZE PANNES=>SELECT ANY ONE(FREEZE TOP ROW/FREEZE FIRST COLUMN)
BUT
WHEN WE WANT TO FREEZE ANY SELECTED AREA=>CLICK ON THE LAST CORNNER CELL OF
THE FREEZING AREA=>VIEW TAB=>WINDOW GROUP=>FREEZE PANES=>FREEZE
PANES.
Q. HOW TO UNFREEZE ANY FREEZE AREA?
STEPS:- VIEW TAB=>WINDOWS GROUP=>FREEZE
PANNES=>UNFREEZE PANES.
·
DATA FORM:-THIS OPTION IS USE TO ADD OTHER LIST WITH ANY
SELECTED LIST ,WHEN WE CAN NOT DRAGE ANY FORMULA.
Q. HOW TO SHOW FORM OPTION ON THE TITLE BAR?
STEPS:-OFFICE BUTTON=>EXCEL OPTION=>CUSTOMIZE=>SELECT
COMMAND NOT IN THE RIBBON(UNDER CHOOSE COMMAND FROM OPTION)=>SELECT
FORM(UNDER SEPERATOR)=>ADD=>OK(THAN FORM OPTION APPEAR ON THE TITLE BAR).
Q.HOW TO USE FORM OPTION IN THE LIST?
STEPS:-SELECT THE LIST=>FORM(THAN FORM OPTION SHOW ON THE
SCREEN)=>NEW=>FILL UP THE BOX=>NEW.
·
BACKGROUND:-THIS OPTION IS USE TO SET THE PICTURE IN SHEET
BACKGROUND.
STEPS:-SELECT THE SHEET=>PAGE LAYOUT TAB=>PAGE SETUP
GROUP=>BACKGROUND=>SELECT THE LOCATION OF PICTURE=>SELECT ANY
PICTURE=>INSERT.
·
PRINT AREA:-THIS OPTION IS USE TO SET THE PRINT AREA FOR
PRINT.
STEPS:-SELECT THAT AREA WHICH WE WANT TO PRINT=>PAGE
LAYOUT TAB=>PAGE SETUP GROUP=>PRINT AREA=>SET PRINT AREA.
·
BREAK:-THIS OPTION IS USE TO BREAK THE SHEET WHERE WE WANT TO BREAK THE SELECTED SHEET IN
DIFFERENT PAGES.
STEPS:-CLICK ON THE LAST CORNNER CELL WHERE WE WANT TO BREAK
THE SHEET=> PAGE LAYOUT TAB=>PAGE SETUP GROUP=>BREAK=>INSERT PAGE
BREAK.
·
CHART:-CHART IS VIDUAL REPRESENTATION OF ANY NUMERIC VALUE
WITH THE HELP OF MANY CHARTS LIKE COLUMN,AREA,LINE,BAR,SCATTER,PIE,OTHER CHART
etc.
STEPS:-SELECT THE LIST=>INSERT TAB=>CHARTS
GROUP=>SELECT ANY ONE(COLUMN, AREA, LINE, BAR, SCATTER, PIE, OTHER
CHART)=>SELECT ANY CHART.