ICT Spreadsheet Essentials Lesson 2

Benjamin needs to create a table with employee information regarding only Bryan, Ashley, and Andrew using the data shown. Which cell range should he select in order to create a table that includes the required data located in this spreadsheet?

• A4:A6

• A1:D8

• A1:D8

• A4:D6

Study the example. Which of the following is displayed?

• Map

• Chart

• Table

• Function

Study the example. Which type of chart is shown?

• Bar chart

• Scatter chart

• Column chart

• Line chart

Study the example. Which type of chart is shown?

• Line chart

• Pie chart

• Bar chart

• Column chart

Which type of chart is divided into portions representing data percentages?

• Column chart

• Bar chart

• Line chart

• Pie chart

Which type of chart compares the quantities or amounts in a series of cells?

• Scatter chart

• Bar chart

• Radar chart

• Pie chart

Which of the following allows a user to easily sort multiple series of data?

• Fill handle

• Table

• Chart

• Function

Which statement about charts is true?

• Chart data is usually represented as text, with graphics used only to annotate the data.

• Chart data is usually represented in animated form so that it can be more quickly interpreted than reading through the raw data.

• A chart is a graphical representation of data that illustrates the relationships between parts of the data.

• A chart is a tabular representation of data that displays the data in columns and rows.

In a horizontal bar chart, which bar represents the greatest amount or value of the data being illustrated?

• The longest bar

• The shortest bar

• The bar at the top of the chart

• The bar at the bottom of the chart

Which type of chart would be appropriate if you want to show how some particular data changes over time to illustrate a trend?

• Area chart

• Line chart

• Pie chart

• Scatter chart