Excel Other Flashcards
1
Q
What function do you use to count just numbers?
A
=Count
2
Q
What function do you use to count numbers & text?
A
=Counta
3
Q
What function do you use to count blank cells?
A
=Countblank
4
Q
What functions do you use to find the maximum or minimum value within a dataset, based on criteria?
A
=Maxifs / Minifs
5
Q
What is the function to get the date at the end of the month?
A
=eomonth(start date,0)
0 means the same month, 1 would be next month
6
Q
How is time stored in excel?
A
as a serial number, which represents a proportion of 24 e.g. 6pm is 18/24 so 0.75
7
Q
How do you work out the difference between a start and end time?
A
= (end time - start time) x 24
