Current Affairs

Microsoft Excel (Ms Excel) Introduction

Introduction Microsoft Excel  (full name  Microsoft Of fice Excel)  is  a  spread sheet-applica tion  written  and  distributed by Microsoft for Microsoft Win dows and Mac OS X. It fea tures calculation, graphing tools, pivot tables and a macro pro gram ming language called  VBA  (Vi sual Ba sic for Applications). It has been the most widely used spreadsheet application available for these platforms since version 5 in 1993. Excel is included as  part of Microsoft Office. A spreadsheet is a  software tool that lets one enter,  calculate,  manipulate and  analyse  set of numbers.

Worksheet ::  It is  a grid  of cells  made up of horizontal rows and vertical columns.  Worksheet contains 65,536 rows and 256 columns.

Row Number  :: Each row is given a number that identifies it, starts from  1, 2, 3,  4, … so on.

Column  Letter ::Each column  is given a  let ter that iden ti fies it,  starts from A … Z, AA … AZ, BA …  BZ, … IA – IV.

Cell  ::  It is  a ba sic unit of worksheet where num bers, text, for mu las etc, can be placed.

Cell Pointer ::It is a  cell-bound ary that spec i fies which cell is ac tive at that mo ment.

Current  Cell ::  It is a  cell which is ac tive.

Range of Cell  ::  It is a group of con tig u ous cells that forms a rect an gu lar area in shape.

Work Book :: A worksheet  is a grid of cells  made up of rows and col umns.  Mul ti ple worksheets can be com bined un der a file know as work book.

Data in Worksheet  :: Three types of data can be en tered, num bers/char ac ters (012345678 + – (), 1 $; %, E,  e), text and for mu las.

Formula ::  It is  a se quence of val ues,  cell ad dress,  names func tions  or op er a tors  in a cell that  pro duces  a new value from ex ist ing values. Cell  Ref er enc ing  Each cell in worksheet has  a unique ad dress,  when cell ad dress is  re ferred  in for mu las, it is called cell ref er enc ing. Rel a tive  Ref er enc ing 

Cell referencing :: in which the cells are re ferred by their rel a tive po si tion in the worksheet  rel a tive  to  a  par tic u lar  cell.

Referencing  Cell ::  ref er enc ing in which the cells are re ferred by their fixed po si tion (ab so lute po si tion) in  the worksheet.

Mixed  Referencing  :: Com bi na tion  of  rel a tive  and  ab so lute  ref er enc ing  is  called  mixed  ref er enc ing.

Functions  ::Functions  are  predefined  formulas  that  per form  calculations  by  using  spe cific  val ues,  called arguments.

Arguments  :: Ar gu ments are the val ues passed to the  func tions, us ing which the  func tion car ries out some task. It can be numbers,  text,  logical values, constants,  formulas  or other functions.

Structure  :: The struc ture of a func tion be gins with the  func tion name, fol lowed  by an open ing pa ren the sis, the ar gu ments for the func tion sep a rated by com mas and a clos ing parenthesis.

Charts :: Charts/Graphs are the pictorial representation of worksheet data.

Area Chart  :: An area  chart emphasizes  the magnitude of change over  time.

Column Chart  :: A column chart shows  data-changes  over a period of time or illustrates comparisons among item.

Bar Chart  :: It illustrates  comparisons  among individual items. Categories are organized vertically and values horizontally.

Line  Chart :: It shows trends  in data at equal intervals. It is useful for depicting the change in a value over a period  of time.

Pie Chart ::  It shows  the proportional size of items that make up  a data  series  to the sum of the items.

XY  (Scatter) Chart  ::It shows  the relationships  among the numeric values in several data series or  plots two groups  of numbers  as series of  XY  coordinates.

Components of a Chart ::

X-axis :: This is a horizontal  axis known as category axis.

Y-axis :: This  is a vertical axis  known as values  axis.

Data series ::  This  is the set of values you want to plot  in the chart.

Chart area ::  This is the total  region surrounding the chart.

Plot area  ::  The area where data is plotted. The plot area is bounded by axes in a 2D-chart whereas in 3Dchart it is bounded by walls and floor.

Chart title :: The descriptive text aimed at helping user identify the chart.

Axis title  :: These are the titles  given to three axis  ie, X, Y, Z.

Legend  :: The legend helps to identify various  plotted  data series.

Gridlines  :: These are horizontal and vertical lines which inserted in the chart to  enhance its readability.

Data Label :: It provides additional information about a data marker.

About the author


Leave a Comment

error: Content is protected !!