Computer Applications
The 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 ?
OOo Calc
11 Likes
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.
Answered By
10 Likes
Related Questions
Define the following terms :
(i) Embedded chart
(ii) Chart sheet.
Below 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 ?
Gina 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.
A 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 box It is easy to see the approximate sales value of each item of equipment It is easy to see which equipment made the most profit It is easy to see which equipment sold the largest quantity It is easy to see the price of the equipment It 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 leaf
Tick one box to show which of the following is true.
Tick one box It is easy to see the approximate sales value of each item of equipment It is easy to see which equipment made the most profit It is easy to see which equipment sold the largest quantity It is easy to see the price of the equipment It is easy to see the date (iii) Tick three boxes to show why the graph below is not very useful
Tick three boxes The graph is printed in black and white All the data cannot be seen as one column is blocking out another Three dimensional graphs are not very useful Some of the labels are missing Only the finance officer understands it The scale used does not show the quantity sold