p6 Y10 Homework - BTEC DIT quiz on Component 2 Lesson 11-14

Which of the following are potential impacts of invasion of privacy? Choose three options.

• Sharing data with unknown third-parties
• Targeted advertising
• Blackmail
• Inaccurate data
• Manipulating voters

True or False: data you share publicly on social media can be used for fraud purposes.

• True
• False

Creating bank accounts in another person's name is an example of...

• Bank Fraud
• Identity Fraud

Completing a transaction using someone else's credit card.

• Bank Fraud
• Identity Fraud

In what tab are the import data options in Excel?

• Home
• Insert
• Data
• Review

When importing from a file we’re asked to specify how items of data are split up. What is the term for the method of splitting up the data?

• Tab
• Delimiter
• CSV
• Divider

In what tab are the sort data options in Excel?

• Home
• Insert
• Page Layout
• Formulas

True or False: when sorting by two columns, the first column has to be sorted ascending and the second by descending.

• True
• False

What do all formulae being with?

• +
• =
• A function
• A cell reference

What is a cell reference?

• Where we use the column letter and row number to get the value of a cell.
• A pre-set method for performing specific actions.
• All of the above.
• None of the above.