Maximum Value Function Overview
The ______ function in Excel returns the highest value in a set of data that you specify.
ایکسل میں ______ فنکشن آپ کے بتائے ہوئے ڈیٹا کے سیٹ میں سب سے زیادہ قدر واپس کرتا ہے۔
Answer: MAX
Explanation
The MAX function in Excel returns the highest value in a set of data that you specify.
It can be used to find the maximum value in a range of cells, a list of numbers, or an array.
Example: =MAX(A1:A10) returns the highest value in cells A1 through A10.
This question appeared in
Past Papers (5 times)
PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
PPSC Assistant Past Papers PDF (1 times)
PPSC Past Papers (2 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- which function returns the average of all the cells in a range that meet given criteria in MS Excel 2016
- MS-Excel uses the _____ function when creating a data table.
- The Function ________ in Excel is used to look up information in a table and extract the corresponding data.
- In Excel, We use the ______ function to return the number of whole days between start_data and end_data.
- In MS Excel, the Chart wizard term data categories refers to ______?
- The function to insert data in a stack data structure is _____?
- In MS Excel, a formula that looks for a value in the leftmost column of a table and then returns a value in the same row for a specific column is called:
- Which one is not a Function in MS Excel?
- In Excel, what is the function of the F11 key?
- MOD () function is used in MS excel to get
