chapter 4 Flashcards Preview

Excel 1 > chapter 4 > Flashcards

Flashcards in chapter 4 Deck (16)
Loading flashcards...
1

function that randomly selects decimal (0-1)

RAND
this random-D(ecimal)

2

random integer number selected between two parameters

RANDBETWEEN

3

VLOOKUP

looks for a certain value in one column
returns the corresponding value in another collumn

4

HLOOKUP

look for a certain value in one row of a table
returns corresponding value from another row of same table

5

MATCH

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

6

INDEX

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

7

note days are seen as the base value (1)

each hour in the day is seen as a decimal
e.g. midday is 0.5

8

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

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

9

TODAY vs. NOW function

returns correspoding serial number of todays date
while NOW returns the date AND time as an integer

10

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

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

11

return serial number of a specified date

DATE()
NOTE- must be (year,month,day)

12

function to return no. of days between two dates

DAYS()

13

from serial number to hour, minute, second

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

14

get the weekday corresponding to a certain date

WEEKDAY
note. gives from numbers 1-7

15

number of working days between two dates

NETWORKDAYS()

16

given birth date and current date... find the age

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