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

• processed data with context

• Information is

• make sense

• Information DOES

• raw facts and figures

• Data is

• make sense

• Data DOESN'T

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

• Quick and easy to collect

• 
• Data may not be exactly what the researcher wanted

• Data is exactly what researcher requires

• Collected by someone else, used by the researcher

• 
• 
• 
• Takes more time and effort

• Collected by researcher

Which of these is NOT an arithmetic operator?

• +

• -

• x

• *

• /

Add the correct labels to the spreadsheet

a

b

c

d

Column A

Row 4

Active cell

Cell E2

What is the formula needed for cell E2?

(a)  

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