FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT 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]

The COUNT and SUM functions are examples of which functions?

A	text
B	statistical
C	financial
D	logical

Explanation:

Detailed explanation-1: -The SUM Function[1] is categorized under Excel Math and Trigonometry functions. The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel. SUM helps users perform a quick summation of specified cells in MS Excel.

Detailed explanation-2: -The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria. To count the number of cells that contain numbers, use the COUNT function. To count cells based on one criteria (for example, greater than 9), use the following COUNTIF function.

Detailed explanation-3: -What is the COUNTIFS Function? The COUNTIFS Function[1] is categorized under Excel Statistical functions. COUNTIFS will count the number of cells that meet a single criterion or multiple criteria in the same or different ranges.

There is 1 question to complete.