FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
SUM, AVERAGE, IF, MIN and MAX are examples of ____
A
user-defined functions
B
online functions
C
table functions
D
predefined functions
Explanation: 

Detailed explanation-1: -Expert-Verified Answer. Explanation: AutoSum is ideal if you are just starting out and want a smarter way to work with your data. The AutoSum feature has five basic functions – SUM, AVERAGE, COUNT, MIN and MAX.

Detailed explanation-2: -The Average function calculates the average, or arithmetic mean, of its arguments. The Max function finds the maximum value. The Min function finds the minimum value. The Sum function calculates the sum of its arguments.

Detailed explanation-3: -Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

Detailed explanation-4: -Select a cell below or to the right of the numbers for which you want to find the smallest number. On the Home tab, in the Editing group, click the arrow next to AutoSum., click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.

There is 1 question to complete.