Excel Notes

Question 1

How would only get certain dates in a table?

Answer 1

Turn all data into table

Click arrow next to dates

Can filter what want to see

Or can use sort filter and custom sort

Question 2

How to use a PIVOT table

Answer 2

Insert PIVOT table

If want to see type of a column put into rows

If want to see the amount of something pull into values

Can go to PIVOT table analyse to and click field items and sets to do calculations in the pivot table

Question 3

SUM?

Answer 3

Adds them all together

Question 4

Average?

Answer 4

Average of them all

Question 5

Count?

Answer 5

The total number of cells

Question 6

Power

Answer 6

A2 = 10

=POWER(A2,3) = 1000

Question 7

Ceiling and Floor

Answer 7

A2 - 35.316

=CEILING(A2,5) = 40

=Floor(A2,5) = 35

Question 8

HOUR function?

Answer 8

Generates the hour from a time value as a number from 0 to 23

Question 9

MINUTE()?

Answer 9

Returns the minute from a time value as a number from 0 to 59

Question 10

SECOND ()?

Answer 10

Returns the second from a time value as a number from 0 to 59

Question 11

DATEFIF()?

Answer 11

Difference between two dates