7.1 Modelling Data Essential Knowledge Assessment

What are spreadsheets used for?

• Writing reports

• Organising data

• Performing calculations

• Creating websites

Match the descriptions of data and information

• make sense

• Data DOESN'T

• raw facts and figures

• Information is

• make sense

• Data is

• processed data with context

• Information DOES

Organize these options into the right categories to explain the difference between primary and secondary data sources:

Groups:

(a) Primary Data Sources

,

(b) Secondary Data Sources

• Data is exactly what researcher requires

• 
• 
• Collected by someone else, used by the researcher

• Data may not be exactly what the researcher wanted

• Collected by researcher

• 
• Takes more time and effort

• 
• Quick and easy to collect

Which of these is NOT an arithmetic operator?

• +

• -

• x

• *

• /

Add the correct labels to the spreadsheet

a

b

c

d

Active cell

Cell E2

Column A

Row 4

What is the formula needed for cell E2?

What is the formula needed for cell D12?

• = 12A * 12C

• =A12 x C12

• = A12 * C12

• A12 * C12

If the drag handle was pulled down to cell J12, what would the value in cell J12 be?

• 12

• 15

• 9

• 18

Reorder the following to create the SUM function required in cell B1 to add up all the values in the column A

• )

• =

• A1:A10

• (

• SUM

Look at the formatted spreadsheet.

Which of the following are formatting techniques has NOT been used on the spreadsheet.

• Bold text

• Cell fill colour

• Borders

• Font style

• Underlined text