DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Functions
|
|
|
Tables
|
|
|
Formulae
|
|
|
Statistical tools
|
Detailed explanation-1: -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-2: -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-3: -One such situation is calculating the sum of the data ( in numbers) based on the matching values. We can combine the SUM function with the VLOOKUP function in such situations. The method is: =SUM(VLOOKUP(reference value, table array, index number, match).