PAPER 3 of notes

Question 1

trap and handle errors in a formula

Answer 1

=IFERROR(value;valueoferror)

Question 2

vertical collumns, find info on other table

Answer 2

=VLOOKUP(valuesearched;fulltable;colume;true or false

Question 3

true =

Answer 3

closest match

Question 4

false =

Answer 4

error if wrong, always put false

Question 5

horizontal rows, find info on other table

Answer 5

=HLOOKUP(valuesearched;fulltable;row;trueorfalse)

Question 6

find year in date

Answer 6

=YEAR(date)

Question 7

find month in date

Answer 7

=MONTH(date)

Question 8

find day in date

Answer 8

=DAY(date)

Question 9

number from 1-7 correspond with monday to sunday

Answer 9

=WEEKDAY(date)

Question 10

which week of the year

Answer 10

=ISOWEEKNUM(date)

Question 11

find the date with different variables

Answer 11

=DATE(year;month;day)

Question 12

adding months to date

Answer 12

=EDATE(start date; number of months)

Question 13

number of working days between 2 dates without weekend and without holidays

Answer 13

=NETWORKDAY(startdate; end date; holidays)

Question 14

returns a date that is a given number of working days ahead of or prior to the start date

Answer 14

=WORKDAY(startdate;number of days;holidays)

Question 15

actual date

Answer 15

=TODAY()

Question 16

Hour of the time

Answer 16

=HOUR(time)

Question 17

minute of the time

Answer 17

=MINUTE(time)

Question 18

second of time

Answer 18

=SECOND(time)

Question 19

=NOW()

Answer 19

actual time

Question 20

count numeric values

Answer 20

=COUNT

Question 21

count non empty cells

Answer 21

=COUNTA

Question 22

empty cells

Answer 22

=COUNTBLANK

Question 23

Count if?

Answer 23

=COUNTIF