ICT Spreadsheets Advanced Test C

Hilda has created a spreadsheet of the inventory of her family's kitchen. She wants to make a grocery list based on items that are at zero. Which tool allows Hilda to display specific criteria (such as items that are at zero) within a cell range of her inventory?

• Filter

• Sort

• Hyperlink

• Fill handle

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?

• Pie chart

• Line chart

• Bar chart

• Column chart

Consider the data in the example spreadsheet:

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

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

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

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

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

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?

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

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

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

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

Tina has selected cells A1 through A25. Which of the following has Tina selected?

• Row

• Cell

• Record

• Range

Dora is reviewing her completed spreadsheet and decides she needs to add another column of information between the existing Columns C and D. What is the quickest way for Dora to insert the new column?

• Drag the right border of Column C until it overlaps Column D.

• Drag the right border of Column D until it overlaps Column C.

• Right-click Column C and click the Insert command.

• Right-click Column D and click the Insert command.

Rows within a spreadsheet are identified by:

• Roman numerals

• icons

• letters

• numbers

Rosalind needs to undo a change she just made in her spreadsheet. Which toolbar button should she use?

• 
• 
• 
• 

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

• =AVERAGE(B2:B5)

• =COUNT(B2:B5)

• =TOTAL(B2:B5)

• =SUM(B2:B5)

Allison and her group have completed the data entry for their spreadsheet project. They are in the process of formatting the data to make it easier to read and understand. The title is located in cell A5. The group has decided to merge cells A3:A7 to attempt to center the title over the data. After the merge, Allison points out that it is not centered and looks bad. Where would the title appear if Allison unmerged the cells in an attempt to fix the title problem?

• The text will appear in cell A3.

• The text will appear in each of the cells from A3 through A7.

• The text will appear in cell A5.

• The text will disappear.