Question 1

Question 1Below is part of a spreadsheet, which contains data about the sales of sandwiches in Hilltop High School.Answer the following questions (i) to (iv) based on above spreadsheet :(i) List two ways in which the cells in the first row have been formatted.(ii) Can you predict after looking at above worksheet whether the values shown in range B4:F15 have default alignment or a different one given through Formatting ?(iii) What option/setting has been chosen for B3:F3 that they are able to display multi-line text in these cells ?(iv) What command has facilitated the setting of previous question i.e., multi-line text ?

Accepted Answer

(i) Two ways in which the cells in the first row have been formatted are:The cells B2, C2 and D2 are merged.The text has been made bold and in uppercase.(ii) The values shown in range B4:F15 have default alignment as the numbers are right aligned by default.(iii) To display multi-line text in cells, we can select the cells and right click on the selection and select Format Cells option. From the Format cells window, select Alignment tab and select on 'Wrap Text automatically' property and click OK.(iv) The command 'Wrap Text Automatically' has facilitated the setting of multi-line text.

Question 2

Question 2The graph below has been produced using the data on the spreadsheet given just before i.e., Favourite Lunchtime Sandwiches spreadsheet.Answer the questions (i) to (vii) based on above chart and Favourite Lunchtime Sandwiches spreadsheet.(i) List the two cell ranges that have been used to create this graph.(ii) Why is it better to view this information on a graph rather than a spreadsheet ?(iii) Suggest an appropriate title for above chart.(iv) Which data range is the Y-axis range ?(v) What is the name of above chart type ?(vi) Suggest another chart type that would be equivalently effective in conveying the information as above chart.(vii) If a pie chart were created with the same data ranges, what information would it convey ?

Accepted Answer

(i) The two cell ranges that have been used to create this graph are [A4 : A13] and [F4 : F13].(ii) Graphs offer a visual representation of data that simplifies complex information. They enhance understanding, aid in comparisons, highlight exceptions, and facilitate data storytelling, making them more effective than spreadsheets for conveying insights, engaging audiences, and guiding decision-making.(iii) 'Lunchtime Sandwiches Sales' can be an appropriate title for above chart.(iv) The data range of the Y-axis is [A4 : A13].(v) The name of above chart type is column chart.(vi) Another chart type that would be equivalently effective in conveying the information as above chart is bar chart.(vii) If a pie chart were created with the same data ranges, it could easily compare the profits earned through different fillings of sandwiches.

Question 3

Question 3Gina spright has collected data on how much each member of her class spends on magazines each month. She wishes to display this information in graph.(a) Name one suitable graph that Gina could use.(b) Explain how Gina could use her computer to produce the graph.

Accepted Answer

(a) A suitable graph that Gina could use to display this information is a bar graph. Each student's spending on magazines can be represented by a separate bar, allowing for easy comparison between different individuals.(b) Gina can use her computer to create a bar graph by entering student names and their spending data into a spreadsheet software like OpenOffice Calc.Then, she can select the data, choose a bar chart type, customize labels, colors, and axes, save and insert the graph into her project.

Question 4

Question 4A finance officer uses a spreadsheet to record sales from an equipment shop.This is part of the spreadsheet.(a) The cells in the spreadsheet contain different types of data.Complete the sentences using words from this list :text ;	an equation ; currency ; a formula ; a date ; a calculation(i) The content of cell A5 is ............... .(ii) The format of cell B1 is ............... .(iii) The content of cell D5 is ............... .(iv) The format of cell D5 is ............... .(b) The finance officer uses the spreadsheet to generate different types of graph.(i) Write down the type of graph using words from this list :scatter ; pie ; bar (or column) ; line ; stem and leaf ;Tick one box to show which of the following is true.Tick one boxIt is easy to see the approximate sales value of each item of equipmentIt is easy to see which equipment made the most profitIt is easy to see which equipment sold the largest quantityIt is easy to see the price of the equipmentIt is easy to see the date(ii) Write down the type of graph using words from this list :scatter ; pie ;	bar (or column) ;	lint. ;	stem and leafTick one box to show which of the following is true.Tick one boxIt is easy to see the approximate sales value of each item of equipmentIt is easy to see which equipment made the most profitIt is easy to see which equipment sold the largest quantityIt is easy to see the price of the equipmentIt is easy to see the date(iii) Tick three boxes to show why the graph below is not very usefulTick three boxesThe graph is printed in black and whiteAll the data cannot be seen as one column is blocking out anotherThree dimensional graphs are not very usefulSome of the labels are missingOnly the finance officer understands itThe scale used does not show the quantity sold

Accepted Answer

(a)(i) The content of cell A5 is text.(ii) The format of cell B1 is a date.(iii) The content of cell D5 is a formula.(iv) The format of cell D5 is currency.(b)(i) The given graph is a pie graph.Tick one boxIt is easy to see the approximate sales value of each item of equipmentIt is easy to see which equipment made the most profitIt is easy to see which equipment sold the largest quantity✓It is easy to see the price of the equipmentIt is easy to see the date(ii) The given graph is a bar/column graph.Tick one boxIt is easy to see the approximate sales value of each item of equipment✓It is easy to see which equipment made the most profitIt is easy to see which equipment sold the largest quantityIt is easy to see the price of the equipmentIt is easy to see the date(iii)Tick three boxesThe graph is printed in black and whiteAll the data cannot be seen as one column is blocking out another✓Three dimensional graphs are not very usefulSome of the labels are missing✓Only the finance officer understands itThe scale used does not show the quantity sold✓

Question 5

Question 1Data represented in a worksheet can be easily understood by :DatabaseLetterChartSymbol

Accepted Answer

ChartReason — Data represented in a worksheet can be easily understood by a chart.

Question 6

Question 2Which one of the following charts generated from a football statistics spreadsheet could compare the performance of the team from year to year ?BarAreaPieScattergram

Accepted Answer

BarReason — Bar charts generated from a football statistics spreadsheet could compare the performance of the team from year to year.

Question 7

Question 3Which chart will show the direction of change in numbers over a period of time by connecting data points ?BarLinePieScattergram

Accepted Answer

LineReason — Line chart will show the direction of change in numbers over a period of time by connecting data points.

Question 8

Question 4Which chart can track and compare measurements such as temperature and show trends and comparisons ?BarLinePieScattergram

Accepted Answer

LineReason — Line chart can track and compare measurements such as temperature and show trends and comparisons.

Question 9

Question 5Which type of chart displays bars side by side ?BarLinePieScattergram

Accepted Answer

BarReason — Bar chart displays bars side by side.

Question 10

Question 6Which chart generated from spreadsheet data would compare values that represent parts of a whole ?BarLinePieScattergram

Accepted Answer

PieReason — Pie chart generated from spreadsheet data would compare values that represent parts of a whole.

Question 11

Question 7Bar Charts are MOST effectively used to :Present Scientific dataCompare groups of dataShow parts of a wholeShow activity of an item over a period of time

Accepted Answer

Compare groups of dataReason — Bar Charts are MOST effectively used to compare groups of data.

Question 12

Question 8The chart that uses connecting dots to show changes over a period of time is called :BarLinePieScatter graph

Accepted Answer

LineReason — A line chart is used to represent data points by connecting them with lines, making it easy to visualize trends and changes over time.

Question 13

Question 9What do you understand by formatting ?working in empty worksheetemptying a worksheetgenerally arranging data in worksheetdeleting select data from worksheet

Accepted Answer

generally arranging data in worksheetReason — General arrangement of data is known as formatting.

Question 14

Question 10To format text in a worksheet, which option will you select from the format menu ?CellsRowColumnSheet

Accepted Answer

CellsReason — To format text in a worksheet, Cells option will be selected from the Format menu.

Question 15

Question 11I am pictorial representation of worksheet data. Who am I ?FlowgraphChartPictureGraphic

Accepted Answer

ChartReason — Chart is a pictorial representation of worksheet data.

Question 16

Question 12Which of the following is not a legal chart type in OOo Calc ?Area chartColumn chartRow chartXY chart

Accepted Answer

Row chartReason — Row chart is not a legal chart type in OOo Calc.

Question 17

Question 13A ............... is a graphical representation of worksheet data.PicturechartText boxSquare

Accepted Answer

chartReason — A chart is a graphical representation of worksheet data.

Question 18

Question 14In ............... chart, only one data series can be plotted.ColumnAreaPieRow chart

Accepted Answer

PieReason — In Pie chart, only one data series can be plotted.

Question 19

Question 15A chart placed in a worksheet is called a ............... chart.InsideEmbeddedOutsideSheet

Accepted Answer

EmbeddedReason — An embedded chart is inserted directly into a worksheet alongside the data it represents. This allows us to visualize and analyze the data in a graphical format within the same worksheet.

Question 20

Question 16A ................ chart shows the relationship of parts to a whole.Area chartEmbedded chartRow chartStacked Column or Stacked Bar

Accepted Answer

Stacked Column or Stacked BarReason — A Stacked Column or Stacked Bar chart is used to represent data where each column (or bar) is divided into segments, and the height of each segment represents the proportion of a specific category within the whole. It's particularly effective for displaying data with multiple categories and comparing their contributions to the total.

Spreadsheet Tool : OO Calc II

Application Oriented Questions

Objective Type Questions

Theoretical Questions