CIS 2640 Exam 2 Functions

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