demand schedul

LIVE PROJECT ONINFORMATION TECHNOLOGYINTRODUCTION TO EXCEL : LIVE PROJECT ONINFORMATION TECHNOLOGYINTRODUCTION TO EXCEL SUBMITTED TO := MR. SANJAY BAHUGUNA SUBMITTED BY := NILANJANA DUTTA SECTION =D, M.B.A.- I ENROLLMENT NO. = 7NBDH203

SETTING CONDITIONS FOR DATA : SETTING CONDITIONS FOR DATA Conditional formating allows 3 conditions .By setting up conditions correctly (least t most restrictive),you can really allow 4 conditions when the default formating of the cell is also taken into consideration.

SELECT RANGE OF CELLS : SELECT RANGE OF CELLS Select the format menu<

FUNCTIONS : FUNCTIONS CALCULATING OPERATIONS USING FUNCTION WIZARD A function can be inserted into a cell, using the insert >> Function option, where a wizard will appear .

DESIGNING CHARTSFOR THE DATA : DESIGNING CHARTSFOR THE DATA Charts are used to represent the data in the form of a graph, which gives a clear picture about the data analysis.

STEPS FOR CREATINGA CHART : STEPS FOR CREATINGA CHART Drag the cursor over the columns you want to show in the chart. open the Insert’ menu and select ‘Chart’. Select the chart which has to be made, Press ‘Finish’ if do not want to label or format the chart. press ‘Next’ to label and format the chart.

Slide 7 : THANK YOU