Which of the following inserts a function that computes for the totals of the cells that are adjacent to the selected cell quizlet?Terms in this set (58) The COUNT function returns the total number of cells in the selected range that contain both text and numbers.
Which of the following functions adds a range of cells and then divides by the number of cell entries?SUM: This function adds all the values of the cells in the argument. AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
Which of the following can you use to insert a formula using a function?Which of the following can you use to insert a formula using a function? You can edit cell contents in the Formula bar or in the cell itself. To find the largest value in a cell range, use the MIN function. Which of the following lets you search for a function or select one from a category?
Which function should be used if you want to count the number of nonblank cells in your worksheet?Count nonblank cells in a range by using the COUNTA function
Use the COUNTA function function to count only cells in a range that contain values.
|