Exploring Microsoft Excel FunctionsAs you saw in Excel Chapter 2, inserting formulas and functions into your Excel workbook is not an extremely difficult task (particularly with the use of "Help" menu). The challenge is knowing what functions exists, when to use them, and what information you need. There are tons of resources to help you discover and learn the numerous functions in Microsoft Excel including, the help menu, YouTube, and Google searches.So, below is a list of many commonly used Microsoft Excel functions. Choose a set of functions, search for information on them, and share with the class what you find. Be sure to include information such as:What does the function do?When would you use the function?What information do you need to complete the function?How do you complete the function?How will knowing these functions help you in the future?SUM & SUMIFStatisticalROUND, ROUNDUP, & ROUNDDOWN** please help me to answer this question I attached sample answer of my peer sample discussion. Please help me to answer like that

SUM AND SUMIF The Microsoft Excel Function that caught my attention was the SUM function which adds values, You can add individual values, cell references or ranges, or a mix of all three. For example, =SUM (A2:410) adds the values in cell A2:10. Another way to use the function SUM is by typing out =SUM (A2:A10, C2: C10), which adds the values in cell A2:A10, as well as cells in C2:C10. The Sum function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. If you need to sum a column of row of numbers, Excel can do the math. You just need to select the cell next to the numbers you want to sum, click AutoSum on the Home tab, and press Enter. SUMIF is a function to sum cells that meet multiple criteria. SUMIFS can be used to sum values when corresponding cells meet criteria based on dates, numbers, and text. SUMIFS supports logical operators (>. . =). The purpose of this feature is to sum cells that match multiple criteria. SUMIF only supports a single condition. SUMIF can calculate sums based on cells that are blank or not blank. For example, you would type in =SUMIF (A2:46, D2, C2:C6) and would sum up your result. In order to use this feature, you must select the range of cells that you want to be evaluated by criteria. Cells in each range must be numbers, names, arrays, or references that contain numbers. Another thing you need to have set is criteria, which is a requirement. The criteria are in the form of a number, expression, a cell reference, text, or a function that defines which cell will be added, Not only are the SUM and SUMIF functions are important to know but the whole functions that Excel provides. Excel provides users with the ability to calculate, organize, and evaluate quantitative data which allows managers to have the information they need to make important decisions. 344 words