ICT
ARCHITECTURE OF 8085
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AVERAGE
|
|
|
SUM
|
|
|
SUMIF
|
|
|
TODAY
|
|
|
MAX
|
Detailed explanation-1: -SUM. AVERAGE. AVERAGEIF. COUNTA. COUNTIF. MOD. ROUND.
Detailed explanation-2: -The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition. The condition is referred to as criteria, which can check things like: If a number is greater than another number > If a number is smaller than another number <
Detailed explanation-3: -A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.
Detailed explanation-4: -A mathematical function is a rule that gives value of a dependent variable that corresponds to specified values of one or more independent variables. A function can be represented in several ways, such as by a table, a formula, or a graph.
Detailed explanation-5: -AutoSum; IF function; LOOKUP function; VLOOKUP function; HLOOKUP function; MATCH function; CHOOSE function; DATE function; More items