USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Range
|
|
sort
|
|
Cell
|
|
Colon
|
Detailed explanation-1: -The colon tells Excel to include all cells between the two endpoint cell references. If I just wanted to input the B column into a function, the reference would be B1:B7. If I wanted to input row 5 into a function, the reference would be A5:C5.
Detailed explanation-2: -: (colon) Range operator, which produces one reference to all the cells between two references, including the two references. B5:B15., (comma)
Detailed explanation-3: -What is Excel Formula? In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.
Detailed explanation-4: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-5: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.