Functions

Question 1

Importrange()

Answer 1

Imports data from another collection

Question 2

Value

Answer 2

Changes text string format to number

Question 3

Xlookup

Answer 3

=xlookup(lookup value, lookup array, return array, [if not found],[match mode],search mode)
Match mode
0 exact match
-1 exact match, if not found next lower number
+1 exact match, if not found next greater number
2 a wildcard match
Search mode

Question 4

V lookup

Answer 4

=vlookup(lookup value, range, return column number from beginning selection, false is exact match)

Question 5

Product(value1,value2)

Answer 5

Value1*value2

Question 6

Sumproduct

Answer 6

Sumproduct(array1, array2) this multiplies each cell in array 1 by each cell in array 2 and adds it up