USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The average for the cell range
|
|
|
The median number in the cell range
|
|
|
The largest number in the cell range
|
|
|
The total of averages in different columns
|
Detailed explanation-1: -The MAX function in Excel returns the highest value in a set of data that you specify. The syntax is as follows: MAX(number1, [number2], …) Where number can be represented by a numeric value, array, named range, a reference to a cell or range containing numbers.
Detailed explanation-2: -The MAX function is a premade function in Excel, which finds the highest number in a range. The function ignores cells with text. It will only work for cells with numbers. Note: There is another function called MIN, which finds the lowest value in a range, the opposite of MAX.
Detailed explanation-3: -The MAX function returns the largest numeric value in the data provided. The MAX function can be used to return the largest value from any type of numeric data. For example, MAX can return the slowest time in a race, the latest date, the largest percentage, the highest temperature, or the top sales number.
Detailed explanation-4: -In a blank cell, type “=MAX(“ Select the cells you want to find the largest number from. Close the formula with an ending parentheses. Hit enter and the largest number from your selection will populate in the cell.