COMPUTER SUMIT ARORA "Spreadsheet Tool : OO Calc II"

Theoretical Questions

Question 1

State True or False :

(i) Graphs let the audience visualize trends quickly.

(ii) Graphs are a compact way to show information.

(iii) Graphs make it hard to find the main point of some data.

(iv) Graphs add a visual model to a presentation.

(v) Graphs are not good at showing changes and relationships.

(vi) Line graphs are good at showing changes over time.

(vii) Line Graphs are also called histograms.

(viii) Pie Charts show how parts relate to the whole.

(ix) Pie Charts can make multiple comparisons.

(x) Bar Graphs and Line Graphs show trends.

Answer

(i) True
Reason — Graphs are visual representations that allow viewers to quickly identify trends and patterns in data.

(ii) True
Reason — Graphs are visual representations, thus making it easier to grasp and understand information.

(iii) False
Reason — Graphs are designed to enhance data visualization and understanding. They generally make it easier, not harder, to identify the main point or trends in the data.

(iv) True
Reason — Graphs indeed introduce a visual model to a presentation, helping to illustrate data patterns and trends more effectively than raw numbers.

(v) False
Reason — Graphs are specifically designed to show changes and relationships in data, making them a powerful tool for data visualization.

(vi) True
Reason — Line graphs are particularly effective at displaying changes over time, as they connect data points with lines, highlighting trends and fluctuations.

(vii) False
Reason — Line graphs and histograms are different. Line graphs display the relationship between two variables over a continuous range, while histograms show the distribution of data within intervals or bins.

(viii) True
Reason — Pie charts are suitable for illustrating how different parts contribute to a whole, providing a clear visual representation of proportions.

(ix) False
Reason — Pie charts are best used to show the proportion of parts in relation to a whole.

(x) True
Reason — Both bar graphs and line graphs are excellent for presenting trends in data. Bar graphs use bars of varying lengths to compare different categories, while line graphs depict changes over time or other continuous variables using lines connecting data points.

Question 2

What does this button mean?

1. Align the text on the borders of the page.
2. Extend the content on the entire length of the cell.
3. Group together the selected cells and center the content.
4. None of the above

Answer

Group together the selected cells and center the content.

Reason — The given button means to group together the selected cells and center the content.

Question 3

What type of chart is this ?

1. Doughnut
2. Radar
3. Bar
4. Pie

Answer

Pie

Reason — The given chart is a pie chart as it shows the parts of a whole.

Question 4

We need to bold the contents of Columns A and C, Row 14 and Cells D8 and E7. Is it possible to do all the formatting in the one action ?

1. Yes
2. No

Answer

Yes

Reason — We can highlight the given cells by pressing Shift key and clicking on the cells — A14, C14, D8 and E7 while keeping the Shift key pressed. Once the given cells are highlignted, we can click on the Bold button on the Format toolbar to bold the contents of the cells.

Question 5

I have created a bar chart which represents sales for September, October and November. I add December figures to the end of the range that the chart was created from. Will the chart automatically update to include these figures ?

1. Yes
2. No

Answer

No

Reason — In OpenOffice Calc, if we initially create a bar chart with a specific range of data and then add December figures to the end of that range, the chart will not automatically update to include these new figures. We will need to manually adjust the chart's data range to encompass the new data (including December figures) in order to accurately reflect them in the chart.

Question 6

I want to print the gridlines on my Calc worksheet so that my data is easy to read. The first time I print my worksheet I choose File Print OK from the menu. Will the gridlines be printed ?

1. Yes
2. No

Answer

No

Reason — In OpenOffice Calc, if we choose "File > Print" from the menu, the grid lines might not be printed by default. Grid lines are typically not included in the default print settings. To print grid lines along with our data, we would need to enable the option to print grid lines before printing.

Question 7

When you insert a column into a worksheet, it will always be inserted to the left of the column that contains the active cell.

1. Yes
2. No

Answer

No

Reason — When we insert a column in a worksheet, we need to select either 'Insert Column Before' or 'Insert Column After' option. Depending on our selection, the new column is inserted either on the left or the right of the selected cell.

Question 8

What is formatting ? Why/How is it useful ?

Answer

The general arrangement of data in a worksheet is known as formatting.

Formatting makes our worksheet presentable. It can emphasize certain data, and can create a hierarchy of relative importance among different elements of data. With formatting, we can make some data to be bolder, rotated or in different colour. So, basically formatting provides worksheet a neater and more legible outlook.

Question 9

What are the different components of chart ? Explain.

Answer

The different components of a chart are as follows:

1. X-axis — This is the horizontal axis known as category.
2. Y-axis — This is the vertical axis known as value axis.
3. Data series — This is the set of values we want to plot in the chart.
4. Chart area — This is the total region surrounding the chart.
5. Plot area — This is the area of chart in which our data is plotted. The plot area is bounded by axes in a 2-D chart.
6. Chart Title — This is the descriptive text aimed at helping user identify the chart.
7. Axes titles — These are the titles given to three axes i.e., X, Y and Z axes.
8. Legend — The legends help us identify various plotted data series. Each series can be uniquely identified by assigning a unique colour or pattern. This unique colour or pattern which identifies a data series, is known as legend.
9. Gridlines — These are the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart to enhance its readability.
10. Data label — This is a label that provides additional information about a data marker, which represents a single data item or value coming from a worksheet cell.

Question 10

Define the following terms :

(i) Embedded chart

(ii) Chart sheet.

Answer

(i) Embedded chart — A chart object placed inside a worksheet along with other data is known as an embedded chart.

(ii) Chart sheet — A chart sheet is a sheet having only a chart and no other data.