5. Which function calculates the sum of the cells and then divides that value by the number of cells in the argument?
A. AVERAGE
B. COUNT
C. MIN
D. SUM
6. Which of the following functions count the number of data in a selected range of spreadsheet?
A. AVERAGE
B. COUNT
C. MAX
D. ROUND
7. Which among the type of spreadsheet functions locates the smallest value in a range of cells?
A. COUNT
B. MAX
C. MIN
D. ROUND
8. What gives the highest value in a range of selected range of cells?
A. AVERAGE
B. COUNT
C. MAX
D. SUM
9. Which spreadsheet function calculates the total of values in a range of cells?
A. COUNT
B. MAX
C. MIN
D. SUM
Answer (2)
To calculate the sum of the cells and then divide that value by the number of cells in the argument, you use the AVERAGE function.
The AVERAGE function finds the mean of a group of numbers by adding them up and dividing by the count of numeric values.
The function that counts the number of data entries in a selected range of a spreadsheet is COUNT .
The COUNT function returns the number of cells that contain numbers within the specified range.
To locate the smallest value in a range of cells, you use the MIN function.
The MIN function scans the specified range and identifies the smallest numerical value.
The function that gives the highest value in a selected range of cells is MAX .
The MAX function examines the specified range and determines the largest value.
The function that calculates the total of values in a range of cells is SUM .
The SUM function adds together all the numbers in the specified range to provide a total.
The correct answers are AVERAGE for the first question, COUNT for the second, MIN for the third, MAX for the fourth, and SUM for the fifth question.
;
