USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=MAX(B5:B7, B8:B10, B11:B15)
|
|
|
=AVERAGE(B5, B6, B7, B8, B9, B10, B11, B12, B13, B14)
|
|
|
All of the above are invalid formulas.
|
|
|
None-all are valid formulas
|
Detailed explanation-1: -Which of the following are not valid formulas for calculating a statistical value using the data in several cells? All of the above are invalid formulas. Which of the following formulas says: if the value in cell B6 is greater than 500, then display a value equal to B6*20; otherwise, display a zero?
Detailed explanation-2: -Detailed Solution. The correct answer is SUBTRACT().
Detailed explanation-3: -The correct answer is SUM(). The SUM function in excel is an inbuilt function that is used to sum numerical values present in a range of cells.
Detailed explanation-4: -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)
Detailed explanation-5: -SUBTRACT() is not a valid function in MS Excel. Subtract two or more numbers in a cell: 1. Click any blank cell, and then type an equal sign (=) to start the formula.