NCCE Spreadsheet Modelling Quiz 3

What is meant by a row?

• A singular item within a spreadsheet.

• A horizontal section of cells in a spreadsheet.

• A line of values within a spreadsheet that are all the same.

• A vertical section of cells in a spreadsheet.

What is meant by a column?

• A vertical line of cells in a spreadsheet.

• A linear data structure that holds an ordered list of items.

• A horizontal line of cells in a spreadsheet.

• A singular item in a spreadsheet.

What is an example of a primary source of data?

• A newspaper article you read.

• A questionnaire you carried out yourself.

• Wikipedia.

• Rumours you've heard.

Which of the following is a correct cell reference?

• G6

• 6G

• #6

• *6

What is a cell?

• A vertical line of items within a spreadsheet.

• A location where malicious programs are isolated when quarantined.

• A singular item within a spreedsheet.

• A horizontal line of items within a spreadsheet.

What is meant by formatting in spreadsheets?

• Laying out the cells in a spreadsheet in alphabetical order.

• Resetting a spreadsheet and removing all of the content.

• Ordering the items in a spreadsheet based on conditions.

• Changing the appearance of cells.

What is conditional formatting?

• Determining the order of cells using conditions.

• Scrambling the contents of a spreadsheet so only people with the key can read it.

• Determining the appearance of cells using conditions.

• Comparing 2 rows and swapping them if a condition is met and vice versa.

What is an example of a secondary source of data?

• A questionnaire you carried out.

• Your own observations.

• A newspaper you read.

• Going to a place and carrying out research.

What type of graph is this?

• Pie chart

• Line graph

• Bar chart

• Pictograph

What type of graph is this?

• Pie chart.

• Bar chart.

• Pictograph.

• Line graph.