Quiz 5: Internet safety, cyber security and encryption

True or false? Programming an encryption algorithm is much quicker and easier than encrypting one message.

• True

• False

True or false? Programming an encryption algorithm is much quicker and easier than encrypting one thousand messages.

• True

• False

True or false? Programming an encryption algorithm can only be done with a spreadsheet. It can’t be done with a program language such as Python.

• True

• False

True or false? In the digital world, most encryption and decryption is done manually rather than using computer programs.

• True

• False

True or false? Attempting to brute force an encrypted message is much, much quicker using an automated program.

• True

• False

The VLOOKUP function is used to create a spreadsheet that encrypts and decrypts messages using the Atbash Cipher.

The lookup_value should be the cell reference(s) for the

• Ciphertext character

• plaintext character

• atbash table

The VLOOKUP function is used to create a spreadsheet that encrypts and decrypts messages using the Atbash Cipher.

The table_array should be the cell reference(s) for the

• Ciphertext character

• plaintext character

• atbash table

The VLOOKUP function is used to create a spreadsheet that encrypts and decrypts messages using the Atbash Cipher.

The col_index_num should be the column in the Atbash table that holds the

• Ciphertext character

• plaintext character

• atbash table

Which function should you use to find the ASCII value of H in cell B6?

• =NUM(B6)

• =CHAR(B6)

• =VALUE(B6)

• =CODE(B6)

If the shifted value is greater than 90, it needs to be adjusted by subtracting 26 from its value. Which function should be used to find the adjusted values?

• VLOOKUP()

• HLOOKUP()

• IF()

• ADJUST()