USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM(B1:B4)/4
|
|
|
=COUNT(B1:B4)/4
|
|
|
=AVERAGE(B1:B4)/4
|
|
|
=MAX(B1:B4)/4
|
Detailed explanation-1: -Functions can do complex calculations that would be very time-consuming to build manually. For example, if you wanted to add up a range of cells without using a function, you’d need to write something like: =A1+A2+A3+A4+A5 instead of =SUM(A1:A5).
Detailed explanation-2: -For example, cells B1, B2, and B3 contain 20, 44, and 67 respectively. The formula “=SUM(B1:B3)” adds the numbers of the cells B1 to B3. It returns 131.
Detailed explanation-3: -The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Detailed explanation-4: -The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays. The default operation is multiplication, but addition, subtraction, and division are also possible.