Unit 3 Computational Thinking

Question 1

Column- columns are labelled with letters
Row- rows are labelled with numbers
Cell- each cell has a unique cell reference

Answer 1

Each box has its own special address, like a house on a street. We find a box by looking at the column letter and the row number. So, a box might be at B3, which means it’s in the second column (B) and the third row (3).

Question 2

Cell reference

Answer 2

These boxes can hold information. You can type numbers, words, or anything you want in them. It’s like writing in your notebook, but on the computer.

Question 3

Label of a spreadsheet

Answer 3

A piece of text that you can add to a spreadsheet to help describe the numbers

Question 4

Value of a spreadsheet

Answer 4

A value is a number that you can type into a spreadsheet. It is a number that you already know

Question 5

Addition in spreadsheets

Answer 5

If you have numbers in cells A1 and B1, you add them with the formula =A1+B1.

Question 6

Subtraction in spreadsheets

Answer 6

Similarly, you can subtract with =A1-B1.

Question 7

Multiplication of spreadsheets

Answer 7

For multiplication, it’s =A1*B1.

Question 8

Division of spreadsheets

Answer 8

for division, it’s =A1/B1

Question 9

Using cell address

Answer 9

In a formal like (A1, A5) you are telling the computer to use the values in the cells

Question 10

Formula using function

Answer 10

=Sum(A1:A5) adds up all the numbers from cell A1 to A5
=Average(B1:B10) calculates the average of the numbers in cells B1 to B10