Codes With Microsoft Excel Flashcards

1
Q

What can Microsoft Excel be used for?

A

It can be used to convert letters into numbers and create coded messages. It can also be used to convert numbers into letters and decrypt coded messages

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How can you turn a letter into a number using MS Excel?

A

By using:

=code(cell)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How can you turn a number into a letter?

A

By using:

=char(cell)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How can we scramble the code further?

A

We can add extra steps, such as adding and multiplying, to make it harder to decrypt the message

How well did you know this?
1
Not at all
2
3
4
5
Perfectly