Formatting Data and Charts

In Excel, there are several aspects of formatting, number formatting, data and time formatting and text formatting. Numbers are formatted to change their appearance. Formatting does not affect actual cell value. Only the appearance changes, the number behind appearance remains as it is. Date and time are formatted to change their appearance. Formatting does not affect the actual date or time, only the appearance date and time changes. Text is formatted to change its appearance. Formatting does not affect the actual text, only the appearance changes.

In Excel, chart is an effective way to display the data in a pictorial form. Charts help to draw comparisons and analysis of Information. The various components of a chart are Chart title, Y-axis title, Y-axis, X-axis title, X-axis, Chart Area, Plot Area, Legends, Data Series and Gridlines. To create a chart in Excel, arrange the data in the worksheet. Select the cells which contain data. On the Insert tab, from the menu list, choose the chart in Chart type category. The chart is created and displayed on the worksheet. Some of the most commonly used charts in Excel are Column Chart, Bar Chart, Line chart and Pie chart. Legend is a key that is used to identify the colour, patterns or symbols assigned to data series. Data Series are the bars or slices that show data values.

To Access the full content, Please Purchase

  • Q1

    Define Embedded charts.

    Marks:1
    Answer:

    Embedded chart is a chart object that is placed inside the worksheet with other data.

    View Answer
  • Q2

    What is a chart area?

    Marks:1
    Answer:

    Total region surrounding the chart is known as the chart area.

    View Answer
  • Q3

    What do you mean by chart sheet?

    Marks:1
    Answer:

    A sheet in a workbook having only a chart and no other data.

    View Answer
  • Q4

    What is chart?

    Marks:1
    Answer:

    Chart is a pictorial representation of the worksheet data.

    View Answer
  • Q5

    Why is formatting essential in worksheet?

    Marks:1
    Answer:

    Formatting makes our worksheet more presentable.

    View Answer