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:B7)
|
|
|
=COUNT(B1:B7)
|
|
|
=AVERAGE(B1:B7)
|
|
|
=MAX(B1:B7)
|
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 SUMIF function, also known as Excel conditional sum, is used to add up cell values based on a certain condition. The function is available in Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and lower.
Detailed explanation-4: -REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string.