Ch – 3 MS EXCXL – IN DEPTH

• I. Fill in the Blanks.
  1.Sreadsheet 2.Charts 3.Standard Types 4. Legend 5. XY Chart 6. Pie Chart 7.Argument 8. Statistical functions 9. MOD 10. Repetitive
  II. True or False
  1.True 2. True 3. False 4. False 5.True 6. False 7. True
  III. Match:
  Mod (90,3) - 1
  Sign - Zero
  ABS (-30) - 30
  Power (4.4, 3) - 85.184
  Ceiling (4.4,1) - 5
  IV. Answer the following:
  1. How will you insert a chart?
  Using Menu
  Click on Insert -> Chart
  Using Toolbar
  Click on Chart Wizard icon on Standard toolbar
  2.Name some chart types.
  1. XY (Scatter) Chart 2. Line Chart 3. Pie Chart
  3. What are custom types charts?
  Custom type charts can be selected from ones built into the system or created by the user.
  4. What is data range? How will you select the data range?
  The data range is the area of tabular data based on which the chart is being made
  It can be selected directly from the worksheet (or)
  Starting and ending cell references can be specified by a colon.
  5. What is the purpose of step 4 of chart wizard?
  It is used to place the chart either as a new sheet or in any location of the existing sheet.
  6. What is XY (Scatter) Chart?
  XY Charts shows the relationship among the numeric values in several data series.
  Scatter charts are commonly used for scientific data.
  7. What is pie-chart? When it is used?
  Is is a circular graph having radii dividing the circle into sectors.
  These graphs are used when data are calculated in terms of percentage.
  8. What is the difference between the functions Ceiling and Floor?
  Ceiling
  It rounds a number up, to the nearest or to the nearest multiple of significance.
  Ex. Ceiling(7.7 , 1) = 8
  Floor
  It rounds a number down toward zero . to the nearest multiple of significance.
  Ex. Floor(7.7 , 1) = 7
  9. Explain the function of power with an example.
  It returns the result of a number raised to a power.
  Ex. Power(4.2 , 2) = 17.64
  10.Explain the arguments of Large function.
  It returns kth largest value in the given data set.
  Syntax: Large (array, k)
  V. Detail:
  1. Write down the procedure to insert a chart.
  select Insert - > Chart
  1st step of the Chart Wizard appears
  Select Chart type and sub-type
  Click on Next button
  2nd step of wizard appears
  It is to specify the data rang.
  The data range can be selected directly from the worksheet.
  Click on Next button
  3rd step of wizard appears
  Enter Chart title, axis name
  Select the place of legend
  Click on Next button
  4th step of wizard appears
  It is used to place the chart either as a new sheet or in any location.
  Select the location
  Click on Finish button.
  2. What is a function? What are the issues associated with function?
  A function is a small assignment that is produces a result.
  A function includes four issues:
  1. Name 2. Purpose 3. Needs 4. Result.
  Name :
  The name is more important in order to use it effectively.
  Purpose:
  The purpose of the function is what the function is used for.
  Needs:
  A function needs a value called argument.
  Result:
  After using a function, the result of the function can be used for its intended purpose.
  3. Write down the steps to merge a worksheet data into a word document.
  Open an existing worksheet.
  Select the data and copy it.
  Open the Ms Word document.
  Click on Edit -> Paste Special.
  In Paste Special dialog box, Click on Paste Link option.
  Select Microsoft Excel Worksheet Object from the list.
  Click on OK.