Get premium membership and access questions with answers, video lessons as well as revision papers.
(a) Pie chart: This chart is used to show the relationship among parts of a whole so that the reader can assess and compare items of the chart.
(b) Scatter chart: Plots and compares two groups as one series, that is, compares pairs of values on the same axis.
(c) Line graph: Used to illustrate linear changes in a large number of values. This chart is useful when you want to emphasize trends and change of value over time.
(d) Bar graph/ chart: Used to compare values at a particular point in time by the lengths or heights of bars.
maurice.mutuku answered the question on April 10, 2018 at 09:15
- Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were...(Solved)
Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were some ties on similar names that appeared in a disorganized manner.
Advise him on how to break the tie.
Date posted: April 10, 2018. Answers (1)
- Why would you prefer to use forms for data entry in a worksheet than entering data directly onto the cells?(Solved)
Give the reason why you would prefer to use forms for data entry in a worksheet than entering data directly onto the cells.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "Autofilter" and "Advanced Filter?"(Solved)
Differentiate between "Autofilter" and "Advanced Filter"
Date posted: April 10, 2018. Answers (1)
- What is the difference between Sorting and filtering?(Solved)
Differentiate between Sorting and filtering.
Date posted: April 10, 2018. Answers (1)
- What types of format are you likely to carry out on data in a worksheet?(Solved)
Give the types of format you are likely to carry out on data in a worksheet.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "justify" with "Center across selection?"(Solved)
Distinguish between "justify" with "Center across selection"
Date posted: April 10, 2018. Answers (1)
- How would you adjust the column width entries to best fit in your spreadsheet?(Solved)
Explain how you would adjust the column width entries to best fit in your spreadsheet.
Date posted: April 10, 2018. Answers (1)
- What are the golden rules of formatting?(Solved)
List the golden rules of formatting.
Date posted: April 10, 2018. Answers (1)
- What is 'Worksheet formatting?'(Solved)
Define 'Worksheet formatting'
Date posted: April 10, 2018. Answers (1)
- What are the possible causes of the #VALUE! error?(Solved)
Explain the possible cause of the #VALUE! error.
Date posted: April 10, 2018. Answers (1)
- How can you clear as well as edit a cell's content in Excel?(Solved)
Explain how you can clear as well as edit a cell's content in Excel.
Date posted: April 10, 2018. Answers (1)
- What activities would you undertake while editing a worksheet or a worksheet item?(Solved)
Discuss activities you may undertake while editing a worksheet or a worksheet item.
Date posted: April 10, 2018. Answers (1)
- What does editing a worksheet mean?(Solved)
Explain the meaning of editing a worksheet.
Date posted: April 10, 2018. Answers (1)
- List 10 commands that can be used to edit a text(Solved)
List 10 commands that can be used to edit a text
Date posted: April 10, 2018. Answers (1)
- What is 'Relative cell reference?'(Solved)
Explain the meaning of 'Relative cell reference'
Date posted: April 9, 2018. Answers (1)
- What is 'Absolute cell reference?'(Solved)
Define 'Absolute cell reference'
Date posted: April 9, 2018. Answers (1)
- What is the difference between external and remote cell references?(Solved)
Distinguish between external and remote cell references.
Date posted: April 9, 2018. Answers (1)
- What is cell referencing?(Solved)
Define 'cell referencing'
Date posted: April 9, 2018. Answers (1)
- What is an argument?(Solved)
Describe the meaning of an argument.
Date posted: April 9, 2018. Answers (1)
- What are the advantages of functions over formulae in spreadsheets?(Solved)
Highlight the advantages of functions over formulae in spreadsheets.
Date posted: April 9, 2018. Answers (1)