# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The LEFT and MID functions are fully interchangeable. In other words, can you always use the LEFT function instead of MID, as well as using MID instead of LEFT?
 A True B False C Either A or B D None of the above
Explanation:

Detailed explanation-1: -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-2: -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-3: -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.

Detailed explanation-4: -SUBTRACT() is not a valid function in MS Excel. Subtract two or more numbers in a cell: 1. Click any blank cell, and then type an equal sign (=) to start the formula.

There is 1 question to complete.