Page 304 - Trackpad IT-402_Class-IX
P. 304
2. Click on the Insert tab. Select the Chart… option from the available options. The Chart Wizard dialog
box will appear on the screen.
3. If you click on Finish, the Chart Wizard dialog box will close and a Pie chart will be inserted as shown below.
REVISIT
▶ The electronic spreadsheet program is used for storing numeric data in an organised form so that the
calculation and analysis of the data can easily be done. OpenOffice Calc is an open-source spreadsheet
available in the OpenOffice Apache suite.
▶ A file in the OpenOffice Calc is known as a worksheet. The default name of the worksheet is “Untitled1”.
Initially, it has three sheets (or sheet tabs), more can be added or subtracted later as per the need.
▶ Rows are accessed horizontally on a worksheet and are identified by numbers 1, 2, 3, 4, …. written on the left
side of the worksheet. Each sheet has a maximum of 1,048,576 (2 power of 20) rows and 1024 (2 power of 10)
columns, i.e., from A to AMJ.
▶ Columns are accessed vertically on a worksheet and are identified by alphabets A, B, C, …, Z, AA, AB, AC, ….,
AZ, BA to BZ, CA, to CZ, and so on written on the top of each worksheet.
▶ Intersection of a row and column is called a cell. Each cell in a spreadsheet is referred to by an address which
is formed by a combination of the column alphabet first and the row number later.
▶ A group of continuous cells selected with a mouse or keyboard is known as a cell range.
▶ A function is an already created formula in a spreadsheet that has a name followed by circular brackets. For
example, max(), min(), sum(), etc.
▶ The Autofill feature helps you fill a predictable series automatically in a range of cells using the fill handle. This
series could be a sequence of digits, months, days, times, etc.
▶ Charts are considered an effective tool of communication in a spreadsheet program. It represents the data in
a pictorial form, which is easy to read and understand.
▶ There are various types of charts available in OpenOffice Calc. For example Column Chart, Line Chart, Bar
Chart, Pie Chart, XY Scatter Chart, etc.
304 Trackpad Information Technology-IX

