FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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 Excel MAX Formula is used to find out the maximum value from a given set of data/ array. MAX function in Excel returns the highest value from a given set of numeric values. Excel MAX formula will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.

There is 1 question to complete.