# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following are not valid formulas for calculating a statistical value using the data in several cells?
 A =MAX(B5:B7, B8:B10, B11:B15) B =AVERAGE(B5, B6, B7, B8, B9, B10, B11, B12, B13, B14) C All of the above are invalid formulas. D None-all are valid formulas
Explanation:

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.

There is 1 question to complete.