Excel application for accounting principles
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Excel application for accounting principles PowerPoint PPT Presentation


  • 46 Views
  • Uploaded on
  • Presentation posted in: General

Excel application for accounting principles. Creating Charts in Excel. Creating a New Chart. Before you create a chart, you need to identify the data that is to be included.

Download Presentation

Excel application for accounting principles

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Excel application for accounting principles

Excel application for accounting principles


Creating charts in excel

Creating Charts in Excel


Creating a new chart

Creating a New Chart

  • Before you create a chart, you need to identify the data that is to be included.

  • Once you’ve done that, you can then select from a wider range of chart types to set the layout and format for your chart.


Creating a new chart1

Creating a New Chart


Changing the chart layout

Changing the Chart Layout

  • The Layout tab under Chart Tools now contains most of the commands that you would need to use to change the appearance and placement of chart elements.


Changing the chart layout1

Changing the Chart Layout


Formatting chart elements

Formatting Chart Elements

  • The Format tab under Chart Tools provides an extensive array of formatting options for any of the elements in a chart.

  • The buttons on the Format tab will change depending on what element you have selected.


Formatting chart elements1

Formatting Chart Elements


Moving the location of a chart

Moving the Location of a Chart

  • You can easily move or resize the embedded chart but, you may wish to display the chart in a separate chart sheet.

  • The Move Chart button can be used to move an embedded chart to a chart sheet and vice versa.


Moving the location of a chart1

Moving the Location of a Chart


Excel application for accounting principles

MCQs

(1) The Format tab under Chart Tools provides an extensive array of formatting options for any of the elements in a chart.

(a) True.

(b) False.

(2) The Move Chart button can be used to move an embedded chart to a chart sheet

(a) True.

(b) False.


Excel application for accounting principles

(3) The Layout tab under format tools now contains most of the commands that you would need to use to change the appearance and placement of chart elements.

(a) True.

(b) False.

(4) When formatting chart elements, you should first select the embedded chart.

(a) True.

(b) False.


Excel application for accounting principles

(5) To change the chart layout, you can click on data tab.

(a) True.

(b) False.

(6) You should select the data you wish to plot first to Create a New Chart

(a) True.

(b) False.


Excel application for accounting principles

(7) To move the location of a Chart, ......... Should be used

(a) Data tab.

(b) Layout tab.

(c) Design tab.

(d) Insert tab.

(8) .......... tab can be used to create a new chart.

(a) Data tab.

(b) Layout tab.

(c) Design tab.

(d) Insert tab.


Excel application for accounting principles

(9) When changing the Chart Layout, ........ Will be used

(a) Data tab.

(b) Layout tab.

(c) Design tab.

(d) Insert tab.

(10) When performing all the tasks related to chart, you should select the embedded chart first except when .............

(a) Changing the chart layout.

(b) Moving the chart.

(c) Formatting Chart Elements

(d) Creating a new chart.


  • Login