USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=(B6>500, B6*20, 0)
|
|
|
=SUM(B6>500, B6*20, 0)
|
|
|
=MULT(B6>500, B6*20, 0)
|
|
|
=IF(B6>500, B6*20, 0)
|
Detailed explanation-1: -Which type of cell address will be adjusted in the new location based on the relative position of the original formula’s input cells? A revolving cell address.
Detailed explanation-2: -The order of operations is a rule that tells the correct sequence of steps for evaluating a math expression. We can remember the order using PEMDAS: Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right).
Detailed explanation-3: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells. A spreadsheet formula is a mathematical equation that will calculate a result.
Detailed explanation-4: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.