USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Functions
|
|
|
Mixed Reference
|
|
|
Complex Formula
|
|
|
Absolute Cell Reference
|
Detailed explanation-1: -An Excel complex formula uses more than one arithmetic operator.
Detailed explanation-2: -A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells your spreadsheet which operation to calculate first. In order to use complex formulas, you will need to understand the order of operations.
Detailed explanation-3: -An Excel complex formula uses for than one arithmetic operator. Predefined formulas in Excel are called functions and can be accessed using the Insert Function Button. Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells.
Detailed explanation-4: -You can nest up to 64 levels of functions in a formula. Click the cell in which you want to enter the formula. Excel inserts the equal sign (=) for you.