Which of the following functions CANNOT be used in the Totals row? A. Average B. Count C. Maximum D. Round

Average
Count
Maximum
Round

The correct answer is: D. Round

The Totals row is a special row that appears at the bottom of a table when you select

124.1c-6.3-23.7-24.8-42.3-48.3-48.6C458.8 64 288 64 288 64S117.2 64 74.6 75.5c-23.5 6.3-42 24.9-48.3 48.6-11.4 42.9-11.4 132.3-11.4 132.3s0 89.4 11.4 132.3c6.3 23.7 24.8 41.5 48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/> Subscribe on YouTube
a range of cells. It automatically calculates the sum, average, count, and maximum of the selected cells.

The Round function is not a valid function for the Totals row because it does not calculate a total. It rounds a number to a specified number of decimal places.

The other three functions (Average, Count, and Maximum) are valid functions for the Totals row. They calculate the average, count, and maximum of the selected cells, respectively.

Exit mobile version