- =MAX(H2:H30)
- =MAXIMUM(H2:H30)
- =LARGE(H2:H30,29)
- =UPPER(H2:H30,1)
Which function returns the largest value in the range H2:H30?
June 29, 2021June 29, 2021
0 Comment
Related Posts
The text filter in column A is designed to display only those rows where column A entry has a particular attribute. What is this attribute?The text filter in column A is designed to display only those rows where column A entry has a particular attribute. What is this attribute?
The second character in the cell is 9. The number 9 appears one or more times within the cell. The[...]
You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?
Add an image of the chart to a comment. Add a hyperlink to another worksheet that displays a chart when[...]
When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _____.When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _____.
mode modulus average median[...]