Introduction to computer science dessalegn Mequanint Yehuala Foreword

Manual for Laboratory Practices
97
Figure 19. Creating a Formula
As soon as you complete a formula entry, Excel calculates the result, which is then displayed
inside the cell within the worksheet (the contents of the formula, however, continue to be
visible on the Formula bar anytime the cell is active). If you make an error in the formula that
prevents Excel from being able to calculate the formula at all, Excel displays an Alert dialog
box suggesting how to fix the problem.
Advanced Features
Charts
A chart is a visual representation of numeric values. Charts (also known as graphs) have been
an integral part of spreadsheets. Charts generated by early spreadsheet products were quite
crude, but they have improved significantly over the years.
Excel provides you with the tools to create a wide variety of highly customizable charts.
Displaying data in a well-conceived chart can make your numbers more understandable.
Because a chart presents a picture, charts are particularly useful for summarizing a series of
numbers and their interrelationships.

---

---

Introduction To Computer Science
98
Types of Charts
There are various chart types available in MS Excel as shown in below screenshot.
Figure 20. Creating a Chart
•
Column: 
Column chart shows data changes over a period of time or illustrates
comparisons among items.
•
Bar: 
A bar chart illustrates comparisons among individual items.
•
Pie:
A pie chart shows the size of items that make up a data series, proportional
to the sum of the items. It always shows only one data series and is useful when
you want to emphasize a significant element in the data.
•
Line:
A line chart shows trends in data at equal intervals.
•