Free Printable ICT Spreadsheet Essentials Review Part 2

1.

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

a)

The shortest bar

b)

The bar at the top of the chart

c)

The bar at the bottom of the chart

d)

The longest bar

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?

a)

A4:D6

b)

A4:A6

c)

A1:D8

d)

A1:D8

3.

Which chart element identifies the data series that each color represents on the chart?

a)

Vertical axis

b)

Title

c)

Horizontal axis

d)

Legend

4.

Which of the following is displayed?

a)

Chart

b)

Map

c)

Function

d)

Table

5.

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

a)

Scatter chart

b)

Bar chart

c)

Radar chart

d)

Pie chart

6.

Which statement about charts is true?

a)

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

b)

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

c)

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

d)

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

7.

Which type of chart is shown?

a)

Line chart

b)

Bar chart

c)

Scatter chart

d)

Column chart

8.

Which of the following lists the types of charts shown in the correct order?

a)

Bar, pie, line

b)

Column, pie, bar

c)

Pie, line, scatter

d)

Column, pie, line

9.

Mr. Robinson has asked his class to give an example of how to find the sum from data ranges. Felix raises his hand. When called upon, he states that:

a)

data ranges can be added together with the SUM function if they are the same data type, such as currency or numerals.

b)

data ranges can be added together with the ADD function if they are the same data type, such as currency or numerals.

c)

data ranges can be added together with the SUM function even if there are different data types such as date, number and text.

d)

data ranges can be added together with the ADD function even if there are different data types such as date, number and text.

10.

Gary wants a graphical representation of his project data that illustrates the relationships between time and height. What should Gary use to represent this data?

a)

A chart

b)

A table

c)

A cell range

d)

A column

11.

Elsie is quizzing herself on the different chart types in preparation for her spreadsheets exam. The flashcard she is looking at states, "Which type of chart is used to represent data as segments of a whole". What term is written on the other side of Elsie's flash card?

a)

Pie chart

b)

Line chart

c)

Bar chart

d)

Column chart

12.

Adolfo has created a spreadsheet for his class that includes each student's age, number of pets and birth date. Which of the following would enable Adolfo to easily sort, filter and calculate the spreadsheet data?

a)

Column chart

b)

Legend

c)

Pie chart

d)

Table

13.

Andrew needs to create a table using the data shown. Which cell range should he select in order to create a table that includes all of the data in the spreadsheet?

a)

A2:D2

b)

A2:D8

c)

A1:D1

d)

A1:D8

14.

Ernesto's group has made a massive spreadsheet containing data from several sources. Which feature could the group use to easily sort a series of data to help improve their understanding of the information?

a)

Table

b)

Chart

c)

Function

d)

Range

15.

Which choice correctly identifies the label of the horizontal axis on the chart shown?

a)

Shots Made

b)

Basketball Game Results

c)

Eric, Jamie, Elizabeth, Bryan, David

d)

Players

16.

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

a)

Line chart

b)

Bar chart

c)

Column chart

d)

Pie chart

17.

Which statement about this table is true?

a)

All fields in this table have been sorted alphabetically.

b)

This table can sum only one type of data.

c)

All fields in this table use the same data type.

d)

This table includes different data types and sums the values.

18.

Chris has taken a complete inventory of the student store. For each inventory item he has documented the item name, initial count of the item at the beginning of the school year, current count, purchase price, selling price, total value of inventory of the item, and the source it was purchased from. The principal wants to know how many pencils are available. What can Chris use that easily sorts, filters and calculates the spreadsheet data?

a)

Table

b)

Column chart

c)

Legend

d)

Function

19.

Gwen has a great idea for documenting the growth of the bean sprout she planted in her science class. She wants to create a chart that tracks vertical plant growth on a weekly measurement schedule. Which type of chart would be best for Gwen to use to track the plant growth?

a)

Line chart

b)

Pie chart

c)

Scatter chart

d)

Area chart

20.

Which type of chart is shown?

a)

Column chart

b)

Line chart

c)

Pie chart

d)

Bar chart

21.

Jude is unsure what the data in his group's column chart represents. There are two colored columns and he is unsure which color represents his data set. Which chart element would Jude use to identify what each color represents on the chart?

a)

Legend

b)

Identity

c)

Title

d)

Horizontal axis

22.

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

a)

Chart

b)

Function

c)

Fill handle

d)

Table

23.

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

a)

Pie chart

b)

Scatter chart

c)

Area chart

d)

Line chart

24.

Macey has a spreadsheet containing data about the total number of students participating in different sports in her school. She wants to graphically show the relative popularity of each sport. Which type of chart should she choose?

a)

Pie chart

b)

Line chart

c)

Column chart

d)

Scatter chart

25.

Aman wants to multiply the values in cells B2 and B3, and then divide the total by the value in cell D7. Which of the following would be the correct formula?

a)

=(B2*B3)/D7

b)

=B2*B3-D7

c)

=(B2*B3)%D7

d)

=(B2xB3)/D7

26.

Sharla wants the cube of the number from C5 to be displayed in D5. Which formula would she use in D5 to produce the number using the exponent?

a)

=C5^3

b)

=C5/D5

c)

=B2*3

d)

=Exponent3(C5)

27.

Ella has recorded monthly expenses in her budget spreadsheet project. She needs to add all of the dollar amounts in the cell range of F4:F14 and then display the results in cell F16. What should Ella do to perform this task?

a)

She should select cell F16 and input =SUM(F4:F14)

b)

She should select cell F16 and input =ADD(F4:F14)

c)

She should select the cell range F4:14 and input =ADD(F16)

d)

She should select the cell range F4:14 and input =SUM(F16)

28.

Helen used a formula to calculate values using the data in Column A and the data in Column B. Which formula did Helen use in Column C to produce the result in Cell C1?

a)

=A1+B1

b)

=A1/B1

c)

=A1*B1

d)

=A1-B1

29.

Which formula would calculate the average number of shots taken, as shown in the spreadsheet?

a)

AVERAGE(A1:A6)

b)

COUNT(B2:B6)

c)

MAX(B2:B6)

d)

AVERAGE(B2:B6)

30.

Darryl found this formula in his group's science spreadsheet.

=MAX(J5:J9)

What does this formula display?

a)

It displays the highest cell value within a data range.

b)

It displays the average value within a data range.

c)

It displays the preset maximum possible value for any cell within a data range.

d)

It displays the sum of all cells within a data range.

31.

Garret wants to add all of the values from cell C7 through C21. Which spreadsheet function should he use?

a)

=SUM(C7:C21)

b)

=ADD(C7:C21)

c)

=(C7+:+C21)

d)

=(C7:C21)TOTAL

32.

Which of the following is an example of an absolute cell reference?

a)

F4

b)

F5:E5

c)

D5+F5

d)

$A$5

33.

Consider the following formula:

=(H12*H13)/H14

What does this formula accomplish?

a)

It divides the value in Cell H12 by the value in Cell H13, and then multiplies the total by the value in Cell H14.

b)

It adds the values in Cells H12 and H13, and then divides the total by the value in Cell H14.

c)

It subtracts the value in Cell H13 from the value in Cell H12, and then multiplies the total by the value in Cell H14.

d)

It multiplies the values in Cells H12 and H13, and then divides the total by the value in Cell H14.

34.

Column A contains 12 student names. Column B contains each student's weight. Which formula would calculate the average weight of all 12 of the students?

a)

AVERAGE(B1:B12)

b)

COUNT(B1:B12)

c)

MAX(B2:B6)

d)

AVERAGE(A1:B12)

35.

Charles is working with several team members on the same spreadsheet. He wants to use an absolute cell reference for the data in cell C7 in one of his formulas. Which of the following is an example of how he would make this absolute cell reference?

a)

$C$7

b)

C7

c)

&C7

d)

C+7

36.

Which example is an absolute cell reference that would not change the column and row when moved?

a)

C8

b)

$C8

c)

C$8

d)

$C$8

37.

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?

a)

$B7 is a mixed cell reference in which the column would not change when moved.

b)

$B7 is an example of an absolute cell reference in which the column and row would not change when moved.

c)

$B7 is an absolute cell reference in which the row would not change when moved.

d)

$B7 is a relative cell reference in which the row would not change when moved.

38.

Carlos has created a large spreadsheet for class. The spreadsheet contains multiple columns and rows of data. Some of the data has not been entered and is therefore blank. What can Carlos do so that the empty cells will be highlighted in yellow until data is entered?

a)

He can use conditional formatting.

b)

He can use cell shading.

c)

He can use absolute reference.

d)

He can use minimum value.

39.

Serena wants to add the numbers appearing in cells D3:D9 and then place the result in cell D10. What function should she use in cell D10 to get the desired result?

a)

=COUNT(D3:D9)

b)

=AVERAGE(D3:D9)

c)

=ADD(D3:D9)

d)

=SUM(D3:D9)

40.

Which formula would produce the average of the values in cells D5 through D9?

a)

=SUM(D5:D9)

b)

=ADD(D5:D9)

c)

=COUNT(D5:D9)

d)

=AVERAGE(D5:D9)

41.

Derrick has created a spreadsheet that displays the results of a science experiment for Mrs. Blue's class. He needs to write a formula that displays the highest cell value within a data range. Which formula would produce the correct result?

a)

=MOST(J5:J9)

b)

=HIGHEST(J5:J9)

c)

=MIN(J5:J9)

d)

=MAX(J5:J9)

42.

Which formula would produce the sum of cells J5 through J9?

a)

=SUM(J1:J10)

b)

=ADD(J5:J9)

c)

=PLUS(J5:J9)

d)

=SUM(J5:J9)

43.

Which function is calculating the value in cell B6?

a)

=AVERAGE(B2:B5)

b)

=COUNT(B2:B5)

c)

=TOTAL(B2:B5)

d)

=SUM(B2:B5)

44.

Rosie's group has done some conditional formatting to their budget project. Which rows display the results of the conditional formatting?

a)

Rows 2, 3 and 5.

b)

Rows 4 and 6:8.

c)

None.

d)

Rows 2:8.

45.

Consider the following spreadsheet function:

=SUM(G2:G19)

What will be the result of this function?

a)

The number of values that appear in cells G2:G19

b)

The average of the values that appear in cells G2:G19

c)

The highest and lowest values that appear in cells G2:G19

d)

The total of the values in cells G2:G19

46.

Which formula would produce an exponent?

a)

=B2/B4

b)

=B2*2

c)

=Exponent(B2)

d)

=B2^2

47.

What can you determine about the highlighted data in Rows 2, 3, and 5?

a)

The spreadsheet has been conditionally formatted to highlight data values in Rows 2, 3, and 5 only.

b)

The spreadsheet has been conditionally formatted to ignore the data values in Rows 2, 3, and 5 only.

c)

The spreadsheet has been conditionally formatted to highlight data values less than $651.

d)

The spreadsheet has been conditionally formatted to highlight data values greater than $299.

48.

What value would be the result of the formula =A2/B2 in the spreadsheet shown?

a)

4

b)

12

c)

32

d)

2

49.

Bjorn has created a large spreadsheet that contains multiple columns and rows of data. His boss has requested that he ensure there are no duplicate values in the spreadsheet. What could Bjorn use to automatically highlight cells containing specific text within his spreadsheet?

a)

Cell shading

b)

Absolute reference

c)

Minimum value

d)

Conditional formatting

50.

Which function is used to total the values of a series of cells?

a)

Average

b)

Count

c)

Max

d)

Sum

51.

Consider the following formula:

=(H12*H13)/H14

What does this formula accomplish?

a)

It divides the value in Cell H12 by the value in Cell H13, and then multiplies the total by the value in Cell H14.

b)

It multiplies the values in Cells H12 and H13, and then divides the total by the value in Cell H14.

c)

It subtracts the value in Cell H13 from the value in Cell H12, and then multiplies the total by the value in Cell H14.

d)

It adds the values in Cells H12 and H13, and then divides the total by the value in Cell H14.

52.

What value would be the result of the formula =A2/B2 in the spreadsheet shown?

a)

32

b)

2

c)

4

d)

12

53.

Which of the following is an example of an absolute cell reference?

a)

F5:E5

b)

F4

c)

$A$5

d)

D5+F5

54.

Aman wants to multiply the values in cells B2 and B3, and then divide the total by the value in cell D7. Which of the following would be the correct formula?

a)

=(B2*B3)%D7

b)

=B2*B3-D7

c)

=(B2*B3)/D7

d)

=(B2xB3)/D7

55.

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?

a)

$B7 is a mixed cell reference in which the column would not change when moved.

b)

$B7 is a relative cell reference in which the row would not change when moved.

c)

$B7 is an absolute cell reference in which the row would not change when moved.

d)

$B7 is an example of an absolute cell reference in which the column and row would not change when moved.

56.

Charles is working with several team members on the same spreadsheet. He wants to use an absolute cell reference for the data in cell C7 in one of his formulas. Which of the following is an example of how he would make this absolute cell reference?

a)

&C7

b)

C7

c)

$C$7

d)

C+7

57.

Helen used a formula to calculate values using the data in Column A and the data in Column B. Which formula did Helen use in Column C to produce the result in Cell C1?

a)

=A1+B1

b)

=A1/B1

c)

=A1*B1

d)

=A1-B1

58.

Which formula would produce an exponent?

a)

=Exponent(B2)

b)

=B2^2

c)

=B2/B4

d)

=B2*2

59.

Sharla wants the cube of the number from C5 to be displayed in D5. Which formula would she use in D5 to produce the number using the exponent?

a)

=Exponent3(C5)

b)

=B2*3

c)

=C5/D5

d)

=C5^3

60.

Which example is an absolute cell reference that would not change the column and row when moved?

a)

$C8

b)

C8

c)

$C$8

d)

C$8

61.

Which function is used to total the values of a series of cells?

a)

Average

b)

Count

c)

Max

d)

Sum

62.

Study the image. Which function is calculating the value in cell B6?

a)

=TOTAL(B2:B5)

b)

=COUNT(B2:B5)

c)

=SUM(B2:B5)

d)

=AVERAGE(B2:B5)

63.

Which formula would produce the sum of cells J5 through J9?

a)

=SUM(J5:J9)

b)

=SUM(J1:J10)

c)

=ADD(J5:J9)

d)

=PLUS(J5:J9)

64.

Which formula would produce the average of the values in cells D5 through D9?

a)

=AVERAGE(D5:D9)

b)

=COUNT(D5:D9)

c)

=ADD(D5:D9)

d)

=SUM(D5:D9)

65.

Serena wants to add the numbers appearing in cells D3:D9 and then place the result in cell D10. What function should she use in cell D10 to get the desired result?

a)

=AVERAGE(D3:D9)

b)

=COUNT(D3:D9)

c)

=SUM(D3:D9)

d)

=ADD(D3:D9)

66.

Consider the following spreadsheet function:

=SUM(G2:G19)

What will be the result of this function?

a)

The highest and lowest values that appear in cells G2:G19

b)

The total of the values in cells G2:G19

c)

The number of values that appear in cells G2:G19

d)

The average of the values that appear in cells G2:G19

67.

Derrick has created a spreadsheet that displays the results of a science experiment for Mrs. Blue's class. He needs to write a formula that displays the highest cell value within a data range. Which formula would produce the correct result?

a)

=MAX(J5:J9)

b)

=MOST(J5:J9)

c)

=HIGHEST(J5:J9)

d)

=MIN(J5:J9)

68.

Which formula would calculate the average number of shots taken, as shown in the spreadsheet?

a)

AVERAGE(B2:B6)

b)

AVERAGE(A1:A6)

c)

COUNT(B2:B6)

d)

MAX(B2:B6)

69.

Darryl found this formula in his group's science spreadsheet.

=MAX(J5:J9)

What does this formula display?

a)

It displays the average value within a data range.

b)

It displays the preset maximum possible value for any cell within a data range.

c)

It displays the sum of all cells within a data range.

d)

It displays the highest cell value within a data range.

70.

Column A contains 12 student names. Column B contains each student's weight. Which formula would calculate the average weight of all 12 of the students?

a)

COUNT(B1:B12)

b)

AVERAGE(B1:B12)

c)

AVERAGE(A1:B12)

d)

MAX(B2:B6)

71.

Ella has recorded monthly expenses in her budget spreadsheet project. She needs to add all of the dollar amounts in the cell range of F4:F14 and then display the results in cell F16. What should Ella do to perform this task?

a)

She should select cell F16 and input =ADD(F4:F14)

b)

She should select the cell range F4:14 and input =ADD(F16)

c)

She should select the cell range F4:14 and input =SUM(F16)

d)

She should select cell F16 and input =SUM(F4:F14)

72.

Garret wants to add all of the values from cell C7 through C21. Which spreadsheet function should he use?

a)

=SUM(C7:C21)

b)

=ADD(C7:C21)

c)

=(C7+:+C21)

d)

=(C7:C21)TOTAL

73.

Consider the data in the example spreadsheet:

What can you determine about the highlighted data in Rows 2, 3, and 5?

a)

The spreadsheet has been conditionally formatted to highlight data values greater than $299.

b)

The spreadsheet has been conditionally formatted to highlight data values less than $651.

c)

The spreadsheet has been conditionally formatted to ignore the data values in Rows 2, 3, and 5 only.

d)

The spreadsheet has been conditionally formatted to highlight data values in Rows 2, 3, and 5 only.

74.

Bjorn has created a large spreadsheet that contains multiple columns and rows of data. His boss has requested that he ensure there are no duplicate values in the spreadsheet. What could Bjorn use to automatically highlight cells containing specific text within his spreadsheet?

a)

Cell shading

b)

Absolute reference

c)

Minimum value

d)

Conditional formatting

75.

Carlos has created a large spreadsheet for class. The spreadsheet contains multiple columns and rows of data. Some of the data has not been entered and is therefore blank. What can Carlos do so that the empty cells will be highlighted in yellow until data is entered?

a)

He can use absolute reference.

b)

He can use cell shading.

c)

He can use conditional formatting.

d)

He can use minimum value.

76.

Rosie's group has done some conditional formatting to their budget project. Which rows display the results of the conditional formatting?

a)

None.

b)

Rows 2:8.

c)

Rows 2, 3 and 5.

d)

Rows 4 and 6:8.

ICT Spreadsheet Essentials Review Part 2

Total questions: 76

Worksheet time: 38mins

Similar Resources on Wayground