Computer Applications
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 |
OOo Calc
5 Likes
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 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) The given graph is a bar/column graph.
| 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 | |
|---|---|
| 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 | ✓ |
Answered By
2 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 ?
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 ?
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.