FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What function was used to find the highest data?

A	AVERAGE
B	MIN
C	SUM
D	MAX

Explanation:

Detailed explanation-1: -The MAX function is a premade function in Excel, which finds the highest number in a range. The function ignores cells with text.

Detailed explanation-2: -If the cells are in a contiguous row or column, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.

Detailed explanation-3: -The max() function returns the maximum value from the two given values.

Detailed explanation-4: -If you are given the formula y = ax2 + bx + c, then you can find the maximum value using the formula max = c-(b2 / 4a). If you have the equation y = a(x-h)2 + k and the a term is negative, then the maximum value is k.

There is 1 question to complete.