COMPUTER SOFTWARE
APPLICATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
formula
|
|
|
graphs/ charts
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The =SUMIF function is an essential formula in the world of data analytics. The formula adds up the values in cells which meet a selected number. In the above example, the formula is adding up the numbers in cells that are higher than the number 5.
Detailed explanation-2: -Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
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: -Microsoft Excel formulas-the basics All Excel formulas begin with an equal sign (=). After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5. Use the SUM function: =SUM(B1:B5)