CIS 2640 Exam 2 Functions
Réussis tes devoirs et examens dès maintenant avec Quizwiz!
CountBlank
Counts the number of blank cells
Count
Counts the number of cells in a range containing numbers
CountIfs
Counts the number of cells in a range for a set of criteria
CountIf
Counts the number of cells in a range for a single given criteria
CountA
Counts the number of non blank cells in a range
Excel stores dates and times as a ________
number representing the number of days in a year (or as a fraction of a 24 hour period)
Slicers are used to _____
As a tool to help filter the table
Pivot tables are used as a way to _____
aggregate data using summary functions