ill in the blank: The spreadsheet function _____ returns the number of cells within a range that match a specified value.1 pointCOUNTIFCOUNT DISTINCTARRAYVALUE

Question 2Fill in the blank: The spreadsheet function _____ can be used to add up the number of times a range of cells contains the value “paid.”1 pointRANGECOUNT DISTINCTRETURNCOUNT

Which function enables a data professional to count the total number of spreadsheet values within a specified range?1 pointSUMWHOLETOTALCOUNTA

The Excel function of ________ is used to find the largest value in a range of cells.Group of answer choicesSUM(range)COUNT(range)MAX(range)COUNTIF(range, criteria)

________ function in Excel tells how many numeric entries are there.AchknumBcumCcountDnum

Question 3What is an example of an array in a spreadsheet? 1 pointThe values in cells B2 through B31All cells with values greater than 100 All cells with number valuesCells D7, E14, and F20