chapter 4

Question 1

function that randomly selects decimal (0-1)

Answer 1

RAND

this random-D(ecimal)

Question 2

random integer number selected between two parameters

Answer 2

RANDBETWEEN

Question 3

VLOOKUP

Answer 3

looks for a certain value in one column

returns the corresponding value in another collumn

Question 4

HLOOKUP

Answer 4

look for a certain value in one row of a table

returns corresponding value from another row of same table

Question 5

MATCH

Answer 5

search for a certain value in a range of cells and returns its position in the same range

Question 6

INDEX

Answer 6

returns a value from within a range or a table based on a specified row and column coordinates

Question 7

note days are seen as the base value (1)

Answer 7

each hour in the day is seen as a decimal

e.g. midday is 0.5

Question 8

normalizing data for dates means we have to get it on the base unit of (days)

Answer 8

hence…
2 hours = 2/24
3 weeks = (3*7)/7

Question 9

TODAY vs. NOW function

Answer 9

returns correspoding serial number of todays date

while NOW returns the date AND time as an integer

Question 10

how to turn serial number into date… day, month or year

Answer 10

DAY()…. MONTH()…. YEAR()…. function

Question 11

return serial number of a specified date

Answer 11

DATE()

NOTE- must be (year,month,day)

Question 12

function to return no. of days between two dates

Answer 12

DAYS()

Question 13

from serial number to hour, minute, second

Answer 13

HOUR()—MINUTE()—-SECOND()

Question 14

get the weekday corresponding to a certain date

Answer 14

WEEKDAY

note. gives from numbers 1-7

Question 15

number of working days between two dates

Answer 15

NETWORKDAYS()

Question 16

given birth date and current date… find the age

Answer 16

DATEDIF()
returns value in months or years
interval argument must be “d”,”m” or “y”