Lecture 1 + 2

Question 1

What is in the cell is not equal to

Answer 1

what’ seen in the formula bar

Question 2

give an example of an array

Answer 2

C6: C12

Question 3

What is an array

Answer 3

collection of different cells in a row or column

Question 4

Give me the 3 types of data entry

Answer 4

typing in
copying and pasting data
autofill option

Question 5

what to remeber when typing in data

Answer 5

press enter

Question 6

what is excels assumption when copying a formula

Answer 6

you want RELATIVE REFERENCING

Question 7

What does relative referencing do

Answer 7

automatically enter the cells in the column or row when doing a formula

e.g it will do A1 X B1
A1 X B2
A1 X B3

Question 8

What does ABSOLUTE REFERENCING /FIXING THE REFERENCE do?

Answer 8

prevents relative referencing occuring

means something will be x(or operationalised) by the same cell even when drag something down

fixing the value of a particular cell reference.

Question 9

how do you do absolute referencing

Answer 9

adding a dollar sign e.g

Question 10

why would ? x $E2 work

Answer 10

E is locked in but as you move down you have E3 , E4 but for the purposes of this case

nothing would be there

Question 10

what does B2 * $E$2 mean

Answer 10

locks E2 in place as the multiplication cell

this means even if you drag down / autofill each cell i.e B3 B4 will be * by E2

Question 11

what does ? * E$2 mean and when would this be helpful

Answer 11

column reference is absolute
row reference is relative

lock a specific column (in this case, column E) while allowing the row number to change as you drag the reference to different cells.

Question 12

what happens when I press F4 once , twice , three times , four times

Answer 12

If you hold down F4 it will add dollar signs to lock cell+ number
If pressed again it will lock the number
If pressed again lock letter
If pressed again goes back to og