DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In MS Excel, the expression =SUM( 3, 5, MAX(2, 7, 10)) + MIN(2, 7, 9) will return the result
|
|
20
|
|
|
24
|
|
|
12
|
|
|
23
|
Explanation:
Detailed explanation-1: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Detailed explanation-2: -Description. Returns the largest value in a set of values.
Detailed explanation-3: -For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use-the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.
There is 1 question to complete.